Category Archives: Biztalk Tutorial

BizTalk- SMTP E-Mail: Compress Attachment in Memory

By Karl Schwirz | February 23, 2011

When trying to send a message via the SMTP adapter in BizTalk we have the option of attaching messages as part of Multi-Part Messages.  If the message being attached is too large the message will fail to send.  In our application, we send email notifications of failed messages in BizTalk with the original message sent [...]

Also posted in BizTalk, Performance Tuning | Tagged , , | 1 Comment

BizTalk Performance Analysis of Logs (PAL) Tool

By Stan Kennedy | January 20, 2011

OverviewÂ
The PAL (Performance Analysis of Logs) tool is a powerful tool that reads in a performance monitor counter log and analyzes it using known thresholds.  A template is created from the PAL tool and imported to the server’s Performance tool as a new counter.  This includes relative BizTalk and SQL metrics that will be tracked.  [...]

Also posted in BizTalk, Performance Tuning | Tagged , , , , , | 1 Comment

Calling EDI Pipelines from Orchestrations

By Stan Kennedy | January 14, 2011

In a recent client project, I found a need to call an EDI pipeline from my orchestration.Â
Environment:
BizTalk Server 2009
Use Case:
Call external synchronous web service that expects a string type with contents of an EDI document.  The orchestration receives response and takes action based on response code type.  In my case, I passed a 270 and [...]

Also posted in BizTalk | Tagged , , , , , | 11 Comments

BizTalk Property Schemas in Different Namespaces

By Stan Kennedy | April 15, 2010

In BizTalk 2006 R2, I have noticed that sometimes the promoted property fields are not available.  This seemed to be a random occurance so I decided to spend a little time investigating.
Problem Scenario:
The property schema field will not show up in a Receive Shape filter. No matter how many times you build, rebuild, and close [...]

Also posted in BizTalk | Tagged , | 1 Comment

BizTalk File Backup

By Stan Kennedy | March 26, 2010

Business or system constraints may force you to leverage BizTalk for File backups.  BizTalk can actually handle this pretty well if it’s planned out carefully.
Here is a diagram of the overall design:

One way to implement this is to set up a receive port and location to poll the original drop location of the files.  This receive location will [...]

Posted in Biztalk Tutorial | Tagged , | 1 Comment

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 [...]

Also posted in 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 [...]

Also posted in General | Tagged , | Leave a comment

Import flat file using BizTalk server

By Leo Wang | October 15, 2007

Recently I worked with a client to implement a solution to import data from an Excel file to SQL Server database. In order to provide a seamless user experience, we created a web page to allow user to upload file to server, then use BizTalk server to convert Excel file to XML file and call [...]

Posted in Biztalk Tutorial | 1 Comment