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

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 :
http://tech-findings.com/2013/07/insert-records-in-sql-server-using-wcf.html

http://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 en07ies.

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


Scenario for this post:  

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:

http://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!!!!!!!!!!!!



Related Post 

  • 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 Orches07ation using DefaultPipeline - BizTalk 2010

  • ServerLess360



    Comments

    Popular posts from this blog

    The request has both SAS authentication scheme and 'Bearer' authorization scheme. Only one scheme should be used

    Getting Started with Logic Apps - AS2

    How to Debug and Trace request in Azure APIM - Portal, Postman, RequestBin