Category Archives: BizTalk

Resolving an obscure BizTalk 2010 build issue

I recently started work on upgrading a BizTalk 2006 R2 application to BizTalk 2010. I upgraded the solution to VS 2010, deployed the application to my local BizTalk and verified everything was working.
The next step was to start work on automating the build and deployment process. A perfect opportunity to leverage the TFS and MSBuild [...]

Posted in BizTalk | Tagged , , | 1 Comment

Book Review: BizTalk 2010 Recipes: A Problem-Solution Approach

Just recently, I finished reading the book BizTalk 2010 Recipes: A Problem-Solution Approach – by Mark Beckner, published by Apress. Overall, I think the read was worthwhile since it helped me fill in some knowledge gaps in BizTalk and introduced me to some of the new features in BizTalk 2010. I am looking at this [...]

Posted in BizTalk | Tagged , , | Leave a comment

Issue with Updating Receive Shape Filters in BizTalk 2006 R2

The issue…
If you’ve worked with Receive Shape filters in BizTalk Server 2006 R2, you may have found that updating existing filters is sometimes problematic, in that the change isn’t always applied after deploying it.
I set out to find out when this issue occurs, and what the resolve is.  I added a condition to an existing [...]

Posted in BizTalk | 1 Comment

BizTalk- SMTP E-Mail: Compress Attachment in Memory

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 Tutorial, Performance Tuning | Tagged , , | 1 Comment

BizTalk Performance Analysis of Logs (PAL) Tool

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 Tutorial, Performance Tuning | Tagged , , , , , | 1 Comment

Calling EDI Pipelines from Orchestrations

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 Tutorial | Tagged , , , , , | 11 Comments

BizTalk Property Schemas in Different Namespaces

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 Tutorial | Tagged , | 1 Comment

BizTalk File Backup

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

Also posted in Biztalk Tutorial | Tagged , | 1 Comment

Updategram with multiple tables with foreign keys

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 Biztalk Tutorial, General | Tagged , | 3 Comments

Setting up an HL7 Solution

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 Biztalk Tutorial, General | Tagged , | Leave a comment