BizTalk Server Tutorial

BizTalk Server Concepts and Common Errors

An alternative to SQL Receive Adapter

Details about SQL Receive Adapter can be found here.

It simply Polls SQL Server DB for data.

Though this is an useful adapter, at times, it increases load on SQL Server with unnecessary calls.

This adapter is not worth using in scenarios where you are not sure of getting data all the times.

In such cases you can go for alternative design, wherein you can get notification to BizTalk Server, whenever new data is available in SQL Server.

This design can be done as follows.

NewData Comes to SQL Server -> Write a trigger that fires upon new data arrives -> Call a .NET function from the trigger -> From the .NET Function, notify BizTalk Server that new data has arrived (Say for eg: Save a dummy file in a folder and let BizTalk be notified on the new data or Call a BizTalk Orchestration Exposed as  a Service etc) -> Have your Logic to Fetch the new Data using an Stored Proc.

Rather than going with the standard polling approach, this new design will help us to use the features available with SQL Server and reduce unnecessay calls to SQL Server.

Hope its helpful.

-Shiv

February 20, 2011 - Posted by | Adapters | ,

2 Comments »

  1. as if!

    Comment by kathy | February 21, 2011 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: