SQL Server Gets BizTalk Adapter

SQL Server Gets BizTalk Adapter

Written By
Lisa Vaas
Lisa Vaas
Feb 28, 2003
1 minute read
eWeek content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More

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.

eWeek Logo

eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site's focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

Property of TechnologyAdvice. © 2026 TechnologyAdvice. All Rights Reserved

Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.