Author Archives: Shawn

Updategram with multiple tables with foreign keys

By Shawn | February 10, 2009

Updategram Overview
Since SQL Server 2000, updategrams along with OPENXML have been available to insert, update, or delete data using XML documents. An updategram works against the XML views that are provided by the annotated XSD schema that contains the information required to map to the tables and columns to be modified. Using an [...]

Posted in Biztalk Tutorial, General | Tagged , | 3 Comments

Setting up an HL7 Solution

By Shawn | January 28, 2009

Setting up an HL7 Solution
HL7 Accelerator Overview
As you might know, the BizTalk Accelerator for HL7 offers a great deal of enhanced messaging capabilities for the healthcare industry. Although it is offered as a separate download, it comes with the license of BizTalk. The nice part about it is that it offers all of [...]

Posted in Biztalk Tutorial, General | Tagged , | Leave a comment

BizTalk and Systems Center: Operations Manager w/ BizTalk Management Pack

By Shawn | June 9, 2008

The BizTalk 2006 R2 Management Pack is a rewrite from the original pack for Microsoft Operations Manager 2005 (MOM).  It is designed around all of the new features of BizTalk 2006 R2 including RFID and EDI.  The pack ties into SCOM very nicely and once it has been imported into SCOM, it can automatically scan [...]

Posted in General | 1 Comment

Shortcuts and Tips

By Shawn | February 12, 2008

As with any application, keyboard shortcuts can save a developer a tremendous amount of time. I have found that keyboard shortcuts are absolutely necessary for creating BizTalk schemas with more than a few nodes. An advanced schema can take many times longer if you have to continually insert each node one at a time. Shortcuts [...]

Posted in General | Leave a comment