Geeks With Blogs

News
Stuart Brierley Integration Management - BizTalk and More BizTalk Adapters Information related to BizTalk Adapters.
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 Adapters - The Scheduled Task Adpater: Receive Location
The BizTalk Scheduled Task Adapter is an in process receive adapter that can be implemented on a receive location to execute a prescribed task on a daily, weekly or monthly schedule. I have previously talked about the installation of the Scheduled Task Adapter with BizTalk Server 2009, detailed below are details of how this adapter can be configured on a receive port. Within the BizTalk Administration console, right click and add a new one way receive location. Select the receive port that your receive ......

Posted On Wednesday, June 23, 2010 4:15 PM

BizTalk 2009 Adapters - The Scheduled Task Adpater: Installation
The BizTalk Scheduled Task Adapter is an in process receive adapter that can be configured to execute a prescribed task on a daily, weekly or monthly schedule. "The adapter is configured entirely within Biztalk, all config is stored within the SSODB and can be exported and imported via binding files. The schedule capabilities are similar to those available with the Windows Scheduled Task Service." Although defined on codeplex as an adapter for BizTalk Server 2004 or BizTalk Server 2006, the Scheduled ......

Posted On Wednesday, June 23, 2010 10:19 AM

BizTalk 2009 - The Community ODBC Adapter: Receive Location
I have previously talked about the installation of the Community ODBC adapter and also using the ODBC adapter to generate schemas. But what about creating a receive location? An ODBC receive location will periodically poll the configured database using the stored procedure or SQL string defined in your request schema. If you need to, begin by adding a new receive port to your BizTalk configuration. Create a new receive location and select to use the ODBC adapter and click Address. You will now be ......

Posted On Wednesday, June 9, 2010 2:25 PM

BizTalk 2009 - The Community ODBC Adapter: Schema Generation with Input Parameters
As previsouly noted in my post on Schema Generation using the Community ODBC Adapter, I ran into a problem when trying to generate a schema to represent a MySQL stored procedure that had input parameters. After a bit of investigation and a few deadends I managed to figure out a way around this issue - detailed below are both the problem and solution in case you ever run into this yourself. The Problem Imagine a stored procedure that is coded as follows in MySQL: StuTest(in DStr varchar(80)) BEGIN ......

Posted On Wednesday, June 9, 2010 3:27 PM

BizTalk 2009 - The Community ODBC Adapter: Send Port
I have previously talked about the installation of the Community ODBC adapter and also using the ODBC adapter to generate schemas and laterly the creation of a receive port using the ODBC Adapter. But what about creating a send port? Select to add a new Send Port, select the ODBC Adapter and click configure. Clicking Connection string will open the DataSource window. Choose one of your system datasources and press OK. This will now update the Transport properties. Select okay. All that remains is ......

Posted On Wednesday, June 9, 2010 2:40 PM

BizTalk 2009 - The Community ODBC Adapter: Schema Generation
Having previously detailed the installation of the Community ODBC Adapter for BizTalk 2009, the next thing I will be looking at is the generation of schemas using this ODBC adapter. Within your BizTalk 2009 project, right click the project and select Add Generated Items. In the resultant window choose Add Adapter Metadata and click Add to open the Add Adapter Wizard. Check that the BizTalk Server and Database names are correct, select the ODBC adapter and click next. You must now set the connection ......

Posted On Wednesday, June 9, 2010 1:54 PM

BizTalk 2009 - The Community ODBC Adapter: Installation
I have previsouly detailed the installation of MySQL, the configuration of MySQL and the installation of the ODBC Data Connector for MySQL. The reason I needed to install and configure these servers was to provide a test environment for a BizTalk Server 2009 solution I am working on where BizTalk will be querying and populating a MySQL database. To do this I then needed to install and add the Community ODBC adapter from Two Connect: "The Community BizTalk Adapter for ODBC is based on the code that ......

Posted On Wednesday, June 9, 2010 1:24 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 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 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 2004 - About the WSE 2.0 Adapter
In a previous post I talked about a problem I encountered with thread startvation when using the WSE 2.0 Adapter. I thought it would be a good idea if I actually put down some notes about this adapter and how it is installed. Web Service Enhancements Web Services Enhancements (WSE) is an add-on to the Microsoft .NET Framework. It includes a set of classes to implement additional WS-* Web service specifications specifically for areas such as security, reliable messaging, and sending attachments. WSE ......

Posted On Tuesday, November 17, 2009 12:22 PM

BizTalk 2004 - WSE 2.0 Adapter Issue
On a project that I completed in 2008, we had to make use of the WSE 2.0 adapter for BizTalk 2004 when calling a third party web service. This worked fine in both the Development and Test environments (both virtual servers) but when we moved to Pseudo-Live (physical server), we encountered problems with the requests we were sending out through the WSE Adapter. Looking on the BizTalk server there were no entries in the event log, and in HAT I saw that the messages in question were Active but in the ......

Posted On Monday, November 16, 2009 5:27 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