BizTalk Adapter Pack 2.0: SQL Adapter

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:

image

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

image

Click Connect.

image

Finally I selected the stored-procedure I created.

image

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

private void buttonTest_Click(object sender, EventArgs e)
{
//////////////////////////////////////////////////////////////////////
// CREATING THE CLIENT
///////////////////////////////////////////////////////////////////////
Procedures_dboClient client = new Procedures_dboClient("SqlAdapterBinding_Procedures_dbo");
//Windows Authentication
///////////////////////////////////////////////////////////////////////
// OPENING THE CLIENT
///////////////////////////////////////////////////////////////////////
try
{
Console.WriteLine("Opening Client...");
client.Open();
}
catch (Exception ex)
{
Console.WriteLine("Exception: " + ex.Message);
throw;
}
///////////////////////////////////////////////////////////////////////
// EXECUTING THE GET_EMP_DETAILS STORED PROCEDURE
///////////////////////////////////////////////////////////////////////
DataSet[] dataArray;
int returnCode;
try
{
Console.WriteLine("Calling a stored procedure...");
dataArray = client.uspGetEmployeeDetail(textBoxNationalIDNumber.Text, out returnCode);
}
catch (Exception ex)
{
Console.WriteLine("Exception: " + ex.Message);
throw;
}
Console.WriteLine("The details for the employee with NationalIDNumber are: {0}", textBoxNationalIDNumber.Text);
Console.WriteLine("*************************************************");
textBoxResult.Text = dataArray[0].Any1.FirstChild.InnerXml;
/////////////////////////////////////////////////////////////////////////
// CLOSING THE CLIENT
/////////////////////////////////////////////////////////////////////////
client.Close();
Console.WriteLine("Press any key to exit...");
Console.ReadLine();
}
view raw SQL Adapter hosted with ❤ by GitHub

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

image

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

image

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.


Technorati:

Comments

Post a Comment

Popular posts from this blog

DTAP Strategy: Pricing and Licensing

Image
To implement BizTalk solutions it is a good practice to have an DTAP environment in place. DTAP stands for Development, Test, Acceptance and Production. Development and test environments are equal (mirrored) and same account for acceptance and production. Deploying DTAP environments is easy, because there are many factors influencing outcome of DTAP. One factor is pricing and licensing costs. BizTalk is available in different editions and since BizTalk depends on operating system and database there are some configuration options to. Here is an overview of possible configurations for DTAP environments, hence there is a nice BizTalk Feature Dependency Matrix. Besides features, there are non-functional requirements to reckon with like fail-over, availability and scalability. On Microsoft Pricing and Licensing FAQ section of BizTalk I found this on non functional side. In a large BizTalk Server 2006 R2 deployment, two key considerations ensure redundancy in all areas of the architect...
Read more

BizTalk CAT Instrumentation Framework Controller: My First Experience

Image
In past I have used log4net or System.Diagnostics.Trace component of .NET for logging and tracing. Until a few months ago the post Best Practices for Instrumenting High Performance BizTalk Solutions got my attention. I read it, but did not start using it directly as I wasn’t doing any development. These days I sometimes am involved in development of BizTalk solutions, so moment was there. Recently BizTalk CAT Instrumentation Framework Controller was released on CodePlex . The BizTalk CAT Instrumentation Framework is a high performance tracing/logging framework for BizTalk that builds upon the Event Tracing for Windows (ETW) infrastructure. It was created by Microsoft's BizTalk Customer Advisory Team (CAT). The Controller is an easy-to-use GUI for the BizTalk CAT Instrumentation Framework. My thinking was why don’t I try this UI out in combination with Microsoft AppFabric CAT Best Practices Samples . The BizTalk Instrumentation Best Practices Samples solution provides a reus...
Read more

BizTalk Server 2010 Exam : How to prepare?

Image
In previous post I yesterday I wrote that new BizTalk 2010 exam is out. And you may figure how to prepare as in preparation material nothing is mentioned.Let’s look at what skills are measured. In a nutshell these topics are: Configuring messaging architecture (setup, manage ports, configure adapters, implement messaging solutions); Developing BizTalk Artefacts (building orchestrations, create schema’s, maps and pipelines); Debugging and Exception Handling (debug orchestrations, validate and test artefacts like schema’s, maps, pipelines); Integrating Web Services and Windows Communication Foundation (WCF) Services (WCF Adapters); Implementing Extended Capabilities (this is the BAM, BRE, RFID and EDI part); Deploying, Tracking, and Supporting a BizTalk Solution (Installation in different kinds of scenario’s, deployment of applications, bindings). You can find a lot of resources that can help in preparation through BizTalk Development Center like the BizTalk tutorials for EA...
Read more