BizTalk Adapter Pack 2.0: SQL Adapter

Posted: July 13, 2009  |  Categories: BizTalk Adapter Pack 2.0 BizTalk Server 2009 Uncategorized

BizTalk Adapter Pack 2.0 Eval has been released a while ago. This adapter enables you to send and receive messages to and from a line-of-business (LOB) system. The primary design goal of adapters is to facilitate the exchange of business documents between trading partners or systems inside your enterprise. The adapters provide the following advantages to clients:

  • Consistent design-time experience. The adapters provide a common and user-friendly design time experience for browsing, searching, and retrieving metadata of LOB artifacts.
  • Varied programming options. The adapters provide a choice of programming model including Windows Communication Foundation (WCF) Channel Model, WCF Service Model, ADO.NET or through BizTalk orchestrations.
  • Uniform experience across LOBs. The adapters standardize on using the WCF and Microsoft Windows Communication Foundation (WCF) Line of Business (LOB) Adapter SDK and hence provide a uniform experience of gaining access to any LOB system.

Supported Operating Systems:

  • Windows Server 2003 R2 Enterprise Edition (32-Bit x86)
  • Windows Server 2003 R2 Enterprise x64 Edition
  • Windows Server 2003 Service Pack 2
  • Windows Server 2008 (SP2!!)
  • Windows Vista
  • Windows XP Service Pack 3

I have a new VM-machine using VMWare worksation on my new Pavalion QuadCore Desktop PC (x64) at home with 8Gb RAM. My VM Machine has 2 Gb Ram and 2 CPU assigned to it. On Machine there is Windows Server 2008 Standard Edition SP2, SQL Server 2008 Developer Edition, VS 2008 Team Edition SP1 and BizTalk Server 2009. I wanted to try out this adapter pack, after having a discussion with Richard a while ago. Do not forget to download and install WCF SDK SP2 first.  Procedure I created is shown below:

Next thing I did was creating a Windows application with Visual Studio. I created a form with one textbox for NationalIDNumber. It looks like this:


To make it work with data from SQL Server I opened up add adapter service reference and selected necessary binding and configuration data.


Click Connect.


Finally I selected the stored-procedure I created.


Click Ok and SqlAdapterBindingClient.cs is created. When click test on my Test client the code below is executed.

Result of execution is a xml data of employee with NationalIDNumber 20269531:


Sample I showed here is derived from Microsoft website with a lot examples for this adapter pack.


I downloaded this sample. I had fun trying it out my code and looking at the sample. I am going to try to do an example for Oracle on VM later on or after my holiday. At a customer I am doing a project now has an Oracle/Oracle eBusiness Suite present (11g), but not a suitable development unfortunately to have go with adapter pack 2.0. I therefore had to try it in my own lab.


Author: Steef-Jan Wiggers

Steef-Jan Wiggers is all in on Microsoft Azure, Integration, and Data Science. He has over 15 years’ experience in a wide variety of scenarios such as custom .NET solution development, overseeing large enterprise integrations, building web services, managing projects, designing web services, experimenting with data, SQL Server database administration, and consulting. Steef-Jan loves challenges in the Microsoft playing field combining it with his domain knowledge in energy, utility, banking, insurance, healthcare, agriculture, (local) government, bio-sciences, retail, travel, and logistics. He is very active in the community as a blogger, TechNet Wiki author, book author, and global public speaker. For these efforts, Microsoft has recognized him a Microsoft MVP for the past 8 years.


Back to Top