Saturday, September 28, 2013

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.blogspot.co.uk/2013/07/insert-records-in-sql-server-using-wcf.html

http://tech-findings.blogspot.co.uk/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:
http://tech-findings.blogspot.in/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!!!!!!!!!!!!


Tuesday, September 24, 2013

BizTalk Server : Deep dive in schema design

After seeing many questions asked based on schema design on the BizTalk forums, thought of writing article on it  and share as much as I know.

Below is the snapshot of what the article talks about:


Read full article here.



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

Monday, September 23, 2013

Top Contributors Awards! Monster scores! New record contribution numbers! Crawler crashes! Ninja editors!

Tuesday, September 17, 2013

My Interview on TechNet

Sunday, September 15, 2013

Top Contributors Awards!! System Center, Active Directory, T-SQL, C#, Gurus and Greatness!!

Thursday, September 12, 2013

Silver Medal : TechNet Guru Awards - August 2013

I had not expected  to be a winner(Silver) as there were excellent articles from leaders in BizTalk (Steef-Jan Wiggers, Tord Glad Nordahl and Lex Hegt). Feels good and motivating.......



Read about other categories :

TechNet Guru Awards - August 2013

Saturday, September 7, 2013

Top Contributors Awards! SharePoint 2013, BizTalk, eDiscovery, Sketetons and Gurus!

Sunday, September 1, 2013

Top Contributors! Meet Maheshkumar. Read about Windows Server 2012, T-SQL Guru entries, Data Protection Manager and... REAL LIFE Ninjas!!! :D