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.