An alternative to SQL Receive Adapter

Posted: February 20, 2011  |  Categories: Adapters Uncategorized

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

BizTalk360
BizTalk Server

Over 500+ customers across
30+ countries depend on BizTalk360

Learn More
Serverless360
Azure

Manage and monitor serverless
components effortlessly

Learn More
Atomicscope
Business Users

Monitor your Business Activity in iPaaS
or Hybrid integration solutions

Learn More

Back to Top