SQL Server Gets BizTalk Adapter

Adapter allows users to read and write to any SQL Server database installation from BizTalk Server 2002.

Microsoft Corp. has made available for download Microsoft BizTalk Adapter for SQL Server, which allows users to read and write to any SQL Server database installation from BizTalk Server 2002.

BizTalk Server already uses SQL Server as its underlying message store. With the adapter, organizations will be able to do things like receive an electronic invoice and validate the amount of the invoice against the corresponding amount on the purchase order issued against the invoice.

To accomplish such a task, the company would establish a workflow procedure with BizTalk Server that looked up and read the value in a line of business database and compared it with the invoice amount. If the amount is equal to or less than the expected value, the document would continue down the prescribed path. Otherwise, it would be stopped and reviewed by a user.

According to Microsoft, the adapter doesnt require coding, since data, in the form of XML documents, is automatically transferred between SQL Server and BizTalk without the need to write and compile new business logic.

To download the adapter, click here.

Get the latest Microsoft news:

Search for more stories by Lisa Vaas.