Grouping and debatching Inbound Messages from WCF SQL Adapter - BizTalk 2010

byMaheshkumar Tiwari •5:19 PM

0

It is a very common scenario where a Purchase Order is received and data within it is inserted in multiple tables , viz. Header, Item, Address tables etc.

How to insert in SQL using WCF-SQL adapter can be seen at :
https://tech-findings.com/2013/07/insert-records-in-sql-server-using-wcf.html

https://tech-findings.com/2013/07/insert-records-in-sql-server-using-wcf_5.html

And when it comes to send Ack , Ship notification or Invoice we need to poll data from different tables with the help of unique Id (most of time its the OrderId along with some other field) which minimizes the risk of duplicate entries.

How to poll from SQL using WCF-SQL adapter can be seen at:
https://tech-findings.com/2013/08/polling-data-from-sql-using-wcf-sql.html

We polled data for order and as it has many items ,thus we get multiple set of repeating nodes with each node having Header data(which is common for all items) and Item data. But we want to group them based on OrderId i.e.,multiple set to be merge into single set with repeating items in it for a particular OrderId.

Lets see how to do it:

https://social.technet.microsoft.com/wiki/contents/articles/18845.grouping-and-debatchingsplitting-inbound-messages-typedpolled-from-wcf-sql-adapter-biztalk-2010.aspx

Will keep on posting as an when I find something to share!!!!!!!!!!!!

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 !!!!!!

BizTalk Server: Multiple XML files to Single FlatFile Using File Adapter

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

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

Is it possible to have Map Chaining on the Port Level

Promoting custom context property using Pipeline Component

Custom ZipReceivePipeline to Unzip Multi-Type Messages

Grouping and debatching Inbound Messages from WCF SQL Adapter - BizTalk 2010

Polling data from SQL using WCF-SQL Adapter in BizTalk 2010 - TypedPolling(From Multiple table)

Grouping XML Messages using custom XSLT- BizTalk 2010

Insert Records in SQL Server using WCF-SQL Adapter in BizTalk 2010 - Composite operation(Multiple Records insertion)

Insert Records in SQL Server using WCF-SQL Adapter in BizTalk 2010- Composite Operation (Message Transformation Pattern)

Debatching(Splitting) XML Message - BizTalk 2010

Debatching(Splitting) XML Message in Orchestration using DefaultPipeline - BizTalk 2010