Geeks With Blogs

News
Stuart Brierley Integration Management - BizTalk and More BizTalk Maps, Mapping and Functoids Information related to BizTalk Maps, Mapping and Functoids.
BizTalk Server 2010 - Using the WCF-SQL adapter to make multiple stored procedure calls
BizTalk Server 2010 - Using the WCF-SQL adapter to make multiple stored procedure calls A recent project that I was working on required that I take an incoming flat file, containing multiple transaction records, and load these transactions into a database. Within the source file were multiple instances of any of seven transaction types. The database had a separate table for each transaction type, each with its own stored procedure for inserting a record. So thats seven transaction types and seven ......

Posted On Wednesday, October 19, 2011 5:18 PM

BizTalk 2009 - Flat File Mapping Issue
Recently when mapping froma flat file schema that was created using the Flat File schema wizard I ran across a problem where a test of the map gave an error realated to unexpected data in the source message. The problem in this case was related to optional, repeating records in the source message/schema. Eventually I discovered the “Parser Optimization” property, which can be found on the Schema node of the Flat File Schema. This is set to speed by default and cannot handle optional or repeating ......

Posted On Thursday, September 16, 2010 3:30 PM

BizTalk 2009 - The Scope of the Table Looping Functoid
When mapping in BizTalk you will find there are times when you need to map from flat and dispersed elemements in your source schema to a repeated record with child elements in your destination schema. Below is an example of how you can make use of the Table Looping Functoid to bring together these flat elements and create your repeated group. Although this example is purposely simple, I have previsouly encounted this issue on a much more complex scale when mapping the response from a credit scoring ......

Posted On Tuesday, June 1, 2010 9:24 AM

BizTalk 2009 - Size Functoid Fun
Recently when mapping a flat file from a third party source, I needed to check whether some elements had been sent with any content or not. In the source message these elements were being supplied in the form: <comment /> I though I would try using the size functoid, assuming that it would return a size of 0 for these empty elements. What actully happens is that the Size funtoid returned a size of 1 rather than the 0 I was expecting. To get what I considered to be the correct output I needed ......

Posted On Friday, May 28, 2010 4:00 PM

BizTalk 2009 - Error when Testing Map with Flat File Source Schema
I have recently been creating some flat file schemas using the BizTalk Server 2009 Flat File Schema Wizard. I have then been mapping these flat file schemas to a "normal" xml schema format. I have not previsouly had any cause to map flat files and ran into some trouble when testing the first of these flat file maps; with an instance of the flat file as the source it threw an XSL transform error: Test Map.btm: error btm1050: XSL transform error: Unable to write output instance to the following <file:///C:\Documents ......

Posted On Wednesday, May 19, 2010 3:36 PM

BizTalk 2009 - Naming Guidelines
The following is effectively a repost of the BizTalk 2004 naming guidlines that I have previously detailed. I have posted these again for completeness under BizTalk 2009 and to allow an element of separation in case I find some reason to amend these for BizTalk 2009. These guidlines should be universal across any version of BizTalk you may wish to apply them to. General Rules All names should be named with a Pascal convention. Project Namespaces For message schemas: [CompanyName].XML.Schemas.[... ......

Posted On Wednesday, March 31, 2010 2:41 PM

BizTalk 2009 - Scoped Record Counting in Maps
Within BizTalk there is a functoid called Record Count that will return the number of instances of a repeated record or repeated element that occur in a message instance. The input to this functoid is the record or element to be counted. As an example take the following Source schema, where the Source message has a repeated record called Box and each Box has a repeated element called Item: An instance of this Source schema may look as follows; 2 box records - one with 2 items and one with only 1 ......

Posted On Friday, May 28, 2010 9:57 AM

BizTalk Server 2009 - SOA Patterns Chapter 1
As stated in my previous post I am currently reading Richard Seroter's book "SOA Patterns with BizTalk Server 2009". Having just finished Chapter 1, Building BizTalk Server 2009 Applications, I thought I would record some immediate thoughts on what I have read so far. This chapter works as an introduction to BizTalk Server, covering the basic architecture, schemas, maps, messaging and orchestrations. While this is not likely to offer much to an experienced BizTalk developer, it does work as a good ......

Posted On Wednesday, December 16, 2009 5:17 PM

BizTalk 2009 - Custom Functoid Categories
I recently had cause to code a number of custom functoids to aid with some maps that I was writing. Once these were developed and deployed to C:\Program Files\Microsoft BizTalk Server 2009\Developer Tools\Mapper Extensions a quick refresh allowed them to appear in toolbox. After dropping these on a map and configuring the appropriate inputs I tested the map to check that they worked as expected. All but one of the functoids worked as expecetd, but the final functoid appeared not to be firing at all. ......

Posted On Thursday, May 27, 2010 11:27 AM

BizTalk 2009 - Creating a Custom Functoid Library
If you find that you have a need to created multiple Custom Functoids you may also choose to create a Custom Functoid Library - a single project containing many custom functoids. As previsouly discussed, the Custom Functoid Wizard can be used to create a project with a new custom functoid inside. But what if you want to extend this project to include more custom functoids and create your Custom Functoid Library? First create a Custom Functoid Library project and your first Custom Functoid using the ......

Posted On Wednesday, May 26, 2010 1:39 PM

BizTalk 2009 - Custom Functoid Wizard
When creating BizTalk maps you may find that there are times when you need perform tasks that the standard functoids do not cover. At other times you may find yourself reapeating a pattern of standard functoids over and over again, adding visual complexity to an otherwise simple process. In these cases you may find it preferable to create your own custom functoids. In the past I have created a number of custom functoids from scratch, but recently I decided to try out the Custom Functoid Wizard for ......

Posted On Wednesday, May 26, 2010 9:19 AM

BizTalk Server 2009 - SOA Patterns Introduction
I have recently picked up a copy of Richard Seroter's book "SOA Patterns with BizTalk Server 2009", and thought that I would try and make some useful comments on each chapter as I read it. I am currently working in an environment where we have been implementing BizTalk Solutions as a part of an overall SOA strategy for a number of years, and I am hoping that this book will help me to gain a new perspective on the use of BizTalk in this type of architecture, and hopefully expand my understanding of ......

Posted On Monday, December 14, 2009 3:40 PM

BizTalk 2009 - Double Click the Functoid
This may have been somthing which was re-introduced in BizTalk 2006 or R2, but having a play with BizTalk 2009 I am glad to see the return of the double clickable functoid! When I first moved from BizTalk 2000 to 2004, I was disappointed to see the loss of the ability to double click on a functoid in a map and be rewarded with the funtoid configuration window. I found that this was a backward step for BizTalk 2004 as far as developer productivity was concerned, as it added unnesessary steps which ......

Posted On Friday, December 4, 2009 2:16 PM

BizTalk 2004 Naming Guidelines
The following BizTalk naming guidlines are heavily based on those proposed by Scott Colestock over at Trace Of Thought. As you can see from the link, Scott wrote his naming conventions for BizTalk Server 2006, whereas I am still using BizTalk Serevr 2004. In reality these guidlines are pretty much universal across any version of BizTalk you may wish to apply them to. Although the general principles for these guidlines are the same as Scott's, I have made some changes based on personal preference ......

Posted On Monday, November 9, 2009 11:47 AM

Copyright © Stuart Brierley | Powered by: GeeksWithBlogs.net