SQL Server Gets BizTalk Adapter

By Lisa Vaas  |  Posted 2003-02-28 Print this article Print

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.
Lisa Vaas is News Editor/Operations for eWEEK.com and also serves as editor of the Database topic center. Since 1995, she has also been a Webcast news show anchorperson and a reporter covering the IT industry. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on eWEEK.com, and in the startup IT magazine PC Connection. Prior to becoming a journalist, Vaas experienced an array of eye-opening careers, including driving a cab in Boston, photographing cranky babies in shopping malls, selling cameras, typography and computer training. She stopped a hair short of finishing an M.A. in English at the University of Massachusetts in Boston. She earned a B.S. in Communications from Emerson College. She runs two open-mic reading series in Boston and currently keeps bees in her home in Mashpee, Mass.

Submit a Comment

Loading Comments...
Manage your Newsletters: Login   Register My Newsletters

Rocket Fuel