BizTalk 2013: Inserting RawXML (Whole Incoming XML Message) in SQL database - Part 2

Configuring the Application and Testing

After Developing and  deploying the application start with creating ReceivePort with a File based receive location.

configure receive port

Send port which will send data to SQL, in this case you need to use WCF-SQL adapter or WCF-Custom adapter can be used.
1. PassThru pipeline is used as no processing is to be done .

WCF-custom adapter

2. SQL binding is to be selected as WCF-Custom adapter is used, if WCF-SQL was used then it would have already been there.

WCF-custom adapter sql binding

After both Receive port and Send Port are created, bind it to the Orchestration. Right click the orchestration and configure.

Update Bindings


After done with configuration, time to test the application. Start the application and drop the sample Order File at Receive Location and you should be able to see in SQL as shown below.

Testing order file

If you have questions or suggestions, feel free to do in comments section below !!!

Do share if you find this helpful .......
                          Knowledge Sharing is Caring !!!!!!

Related Post 


If you have any suggestions or questions or want to share something then please drop a comment

  1. I keep encounter the following error after I go through the whole steps, any iea where I made it wrong ? thanks
    The adapter failed to transmit message going to send port "InserttoSQL" with URL "mssql://aglbiztest//testDb?". It will be retransmitted after the retry interval specified for this Send Port. Details:"System.ArgumentNullException: Value cannot be null.
    Parameter name: key
    at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
    at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfClient`2.CreateChannelFactory[TChannel](IBaseMessage bizTalkMessage)
    at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfClient`2.InitializeValues(IBaseMessage message)
    at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfClient`2..ctor(IBaseMessage message, WcfTransmitter`2 transmitter)
    at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfTransmitter`2.GetClientFromCache(String spid, IBaseMessage message)
    at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfAsyncBatch`2.BatchWorker(List`1 messages)".

Previous Post Next Post