Geeks With Blogs

Bill Osuch - Random geek notes BizTalk There are 22 entries for the tag BizTalk
Using Dynamic Maps in Microsoft BizTalk
Using maps in a Microsoft BizTalk orchestration is pretty straightforward – create your source and destination schemas, map from one to the other, drop a Transform shape onto your orchestration, and configure the source and destination messages. But what if you need to apply different maps based on some property inside the message, or even who the message is coming from? In our case, we process X12 837 healthcare claim files. In the X12 schemas, the same piece of information can be stored in different ......

Posted On Monday, December 30, 2013 8:00 PM

BizTalk–Looping through repeating message nodes in orchestrations
Say that you have an incoming BizTalk message with many repeating nodes, and you want to process each one the same. The easiest thing to do would be to use the envelope to split the single message into multiple messages, then have multiple instances of your orchestration handle each one (similar to how the HIPAA “multiple” message schemas work). But what if you need to do some work after every individual message has been processed? I’ll show you how to use the Loop functoid along with xpath queries ......

Posted On Wednesday, August 15, 2012 3:10 PM

BizTalk–Mapping a NACHA file using the Flat File Mapping Wizard and preserving header information
In a previous post I demonstrated how to use the Flat File Mapping Wizard to map a NACHA financial file, and at the end I said I’d follow up with a post on setting up the pipeline and preserving the header information. Well, I totally forgot about that until someone asked where the post was, so here it is… Begin by creating the three schemas as shown in the previous post. Add a pipeline to the project, and drag the Flat file disassembler component from the toolbox to the Disassemble stage. Right-click ......

Posted On Friday, April 20, 2012 2:50 PM

BizTalk–Mapping repeating EDI segments using a Table Looping functoid
BizTalk’s HIPAA X12 schemas have several repeating date/time segments in them, where the XML winds up looking something like this: <DTM_StatementDate> <DTM01_DateTimeQualifier... <DTM02_ClaimDate>2012... </DTM_StatementDate> <DTM_StatementDate> <DTM01_DateTimeQualifier... <DTM02_ClaimDate>2012... </DTM_StatementDate> The corresponding ......

Posted On Thursday, March 29, 2012 8:07 AM

BizTalk 2010 EDI batching–using an external release trigger
In an earlier post I showed you how to implement basic EDI batching, releasing the batch every time 3 messages were waiting. In the real world, you’re probably going to have some other criteria for releasing the batch; in our case a back-end system notifies BizTalk when all HIPAA 837 claims in a single file are ready to be sent. The MSDN page for this process is actually very easy to follow, but I’ll summarize it here. First, you’ll set up a new receive port and location to receive the trigger file. ......

Posted On Monday, February 27, 2012 3:04 PM

BizTalk 2006 & 2009 hotfix for EDI leap year date errors
Microsoft has released a hotfix to fix a date problem in BizTalk Server 2006 R2 & 2009 when processing EDI files where a data element contains a leap date. BizTalk Server 2006 and 2010 are not affected. This issue occurs because the EDI interchange cannot validate a data element that contains a leap date value, such as "20120229". This issue can be resolved by either installing the BizTalk Server 2009 cumulative update package 1 (if you’re running 2009…) or the hotfix at the top of KB article ......

Posted On Thursday, February 23, 2012 1:10 PM

BizTalk 2010 EDI Batching Tutorial
In two previous posts I talked about party configuration and routing of EDI messages: Basic Party Resolution in BizTalk 2010 EDI Party Resolution (& trading partners) in BizTalk 2010 In this post I’ll build off of those examples and set up EDI batching so that we can deliver more than one EDI 810 invoice per file. You’ll need to have worked through the previous two posts to have your BizTalk application ready to follow along with these steps. First, change the File name: of the Contoso Send Port ......

Posted On Thursday, February 16, 2012 3:04 PM

Accessing all context properties in a custom BizTalk pipeline component
Previously I talked about how to create a custom BizTalk pipeline component, and gave a few examples for accessing specific context properties. I wanted to be able to dump all the context properties to disk for examination, so I added a few lines of code and an on/off switch. First, add two properties to your component: private bool _EnableContextTrace; private string _FileTraceLocation; public bool EnableContextTrace { get { return _EnableContextTrace; } set { _EnableContextTrace = value; } } public ......

Posted On Monday, February 6, 2012 2:06 PM

Creating a custom BizTalk 2010 pipeline component–Part 3
I hadn’t intended for there to actually be a part 3 to this series, but I realized that I failed to talk about how to get the xml back into the message once you’re done messing with it. You have to convert it to a MemoryStream and assign it to IBaseMessage.BodyPart.Data, like this: public Microsoft.BizTalk.Message.I... Execute(Microsoft.BizTalk.C... pc, Microsoft.BizTalk.Message.I... inmsg) { IBaseMessagePart bodyPart = inmsg.BodyPart; ......

Posted On Thursday, January 26, 2012 11:10 AM

Creating a custom BizTalk 2010 pipeline component–Part 2
In the last post I showed how to create the skeleton of a pipeline components, add it to the toolbox, integrate it into a BizTalk app and deploy & test it. This time I’ll go over working with the XML, reading and writing message context properties, and reading and writing custom component properties. To get the xml portion of the message, you can get a Stream from IBaseMessage.Body.Part.GetO... and load it into an XmlDocument. In our case we’re manipulating the structure of an ......

Posted On Wednesday, January 25, 2012 3:17 PM

Creating a custom BizTalk 2010 pipeline component–Part I
Recently at work we had a need to be able to manipulate the XML version of a HIPAA EDI file before it hit any of our BizTalk orchestrations, so I decided to do this with a custom pipeline component. There are other (possibly better…) ways of doing this, but sometimes you just have to work with what you’ve got. I can never remember all the little bits and pieces you have to set up in a custom pipeline component, so I decided to give the BizTalk Server Pipeline Component Wizard a try. The wizard walks ......

Posted On Tuesday, January 24, 2012 12:40 PM

Generating HIPAA 5010 acknowledgments in BizTalk Server 2010
Microsoft has released a hotfix that supports 999 functional acknowledgments and 277CA for HIPAA 5010 Errata in Microsoft BizTalk Server 2010. This post will be a quick walk-through on getting the 999s working. To start, download and install the hotfix (part of Cumulative update package 3) at: If you don't have a solution that currently uses 997 responses, and you want to test the 999s out, just do the quick tutorial (Walkthrough (X12): Receiving EDI Interchanges ......

Posted On Monday, December 5, 2011 4:37 PM

EDI Party Resolution (& trading partners) in BizTalk 2010
In my last BizTalk post, I showed a project that routed xml messages to different parties based on the destination party name. It worked for simple xml messages, but if you want to work with EDI files you need to set up actual trading partner agreements between the parties, in order to configure the additional information needed to send an EDI X12 message (the ISA & GS segments). We'll build off the solution previously created by adding an X12 schema, mapping the xml purchase order to it, and ......

Posted On Wednesday, October 26, 2011 12:46 PM

Basic Party Resolution in BizTalk 2010
BizTalk parties are external entities that BizTalk communicates with. You create parties in the admin console to determine how (or where) messages are routed, as well as controlling various pieces of envelope information for EDI messages. Today I'm going to walk through a very simple method of routing a message through an orchestration to any location based just on the party name. Begin by creating a new BizTalk solution. Add a schema called PurchaseOrder that looks like this: Promote the customer ......

Posted On Monday, October 17, 2011 1:29 PM

Changing the BizTalk message output file name
By default, BizTalk creates the filename of the message dropped to a send port as %MessageID%, which is the unique identifier (GUID) of the message. What if you want to create your own filename? To start, create a simple schema, and a basic orchestration that will receive the message and send it right back out, like this: If you deploy this and wire up the ports, you can drop an xml file into your receive port and have it come out at your send port named something like {7A63CAF8-317B-49D5-871F-9F... ......

Posted On Friday, June 24, 2011 2:40 PM

New BizTalk 2010 Developer Training from Microsoft
Microsoft has publically released the content from their BizTalk 2010 training course - this includes the PowerPoint decks (with instructor notes), Word docs of all the modules, 1.5 gigs of videos, and virtual machines (for Hyper-V only) for all the labs. The downloads are available at: BizTalk Server 2010 Developer Training Kit From Microsoft's site: About This Hands-On Lab This five-day instructor-led course consists of a series of hands-on labs that provides students with the knowledge and skills ......

Posted On Wednesday, May 25, 2011 9:58 AM

Problems with the BizTalk HIPAA 5010 schemas

We've been having a problem getting BizTalk to recognize an 837I A2 (00501X223A2) file, and Microsoft just yesterday released a fix for it:

It can be downloaded as part of the new Cumulative update package 1 for BizTalk Server 2010.

Technorati Tags:

Posted On Tuesday, May 24, 2011 12:52 PM

BizTalk: Using the Flat File Mapping Wizard to map a NACHA financial file
If you've ever had to work with any financial ACH transactions (Automated Clearing House, think direct deposit...) then chances are you've run into a NACHA file. These are flat, positional files composed of repeating 94 character records. The basic structure looks like this: File Header Record Batch Header Record Entry Detail Record Entry Detail Record Entry Detail Addenda Record (optional) Batch Control Total Batch Header Record Entry Detail Record Batch Control Total File Control Record Notice ......

Posted On Thursday, April 21, 2011 2:54 PM

New Microsoft BizTalk 2010 certification exam
TS: Developing Business Process and Integration Solutions by Using Microsoft BizTalk Server 2010 Microsoft has released the newest BizTalk 2010 certification exam, which will qualify you as a Microsoft Certified Technology Specialist (MCTS): Microsoft BizTalk Server 2010. Unfortunately, at this point it appears there is absolutely no training material for it; looking at the Preparation Materials tab at the link above says "Microsoft Learning recommends that you have hands-on experience with the product ......

Posted On Wednesday, April 20, 2011 3:03 PM

BizTalk - keeping the GAC clean
Chances are that for anyone running a development BizTalk machine, you've deployed quite a few solutions as you've tested various things. It's easy enough to delete them from the BTS Administration Console with a right-click, but (assuming you've kept the default properties) they're also sitting in the GAC as well. In most cases this won't cause a problem, but eventually you may run into the dreaded "Message can not be serialized as the schema <schema name> could not be located. Either the ......

Posted On Tuesday, August 10, 2010 8:47 AM

BizTalk Orchestration & Port Tutorial Part 2
In Part 1 I showed how to create and publish a simple Orchestration demo. Now we’ll finish configuring it in the admin console and test it. Open the BizTalk Server 2009 Administration Console, and expand BizTalk Server 2009 Administration, then Applications. You should have an entry for OrchestrationPortDemo – expand it as well. First, we’ll add the Receive Port – the place that we’ll drop the test file. Right-click on Receive Ports and select New One-way Receive Port. On the General tab, name it ......

Posted On Friday, March 19, 2010 1:59 PM

Simple BizTalk Orchestration & Port Tutorial
(This is a reference for a lunch & learn I'm giving at my company) This demo will create a BizTalk process that monitors a directory for an XML file, loads it into an orchestration, and drops it into a different directory. There’s no real processing going on (other than moving the file from one location to another), but this will introduce you to Messages, Orchestrations and Ports. To begin, create a new BizTalk Project names OrchestrationPortDemo: When the solution has been created, right-click ......

Posted On Friday, March 19, 2010 12:26 PM

Copyright © Bill Osuch | Powered by: