Welcome Sign in
BizTalk Server Developer Center
Click to Rate and Give Feedback
MSDN
MSDN Library
BizTalk Server
Operations
Using Adapters
SQL Adapter
SQL Adapter

This topic was last updated on: December 5, 2007

The SQL adapter exchanges data between Microsoft BizTalk Server and a SQL Server database. You can use the SQL adapter to poll data from one or more data tables and transmit the data as one or more XML messages to BizTalk Server. You can also use the SQL adapter to move large amounts of data to or from the SQL Server database as part of a BizTalk Server messaging or orchestration solution. In addition, you can use the SQL adapter to insert, update, and delete data in SQL Server tables by using SQL updategrams or by invoking stored procedures.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
See Also: Best Practices for the SQL Adapter      Eric Battalio - MSFT ... Stanley Roark   |   Edit   |  
Dwaine Gilmer, John Taylor and Matthew Yipp wrote a whitepaper filled with best practices for working with the SQL Adapter. For the best performance, the white paper says you must:
  • Design the mapping of data in the tables of the database to message in BizTalk Server.
  • Define how the mapping of the data to a BizTalk message takes place.
  • Determine the message size and the level of concurrency when accessing the stored data.
  • Carefully design, craft, and implement the SQL statements that provide and consume data.

Issues and solutions around these performance issues are addressed in the paper. Download it at http://download.microsoft.com/download/5/0/f/50f397a7-13c7-4807-bd51-66db5f5b0908/best%20practices%20for%20the%20sql%20adapter.doc.

Tags What's this?: sql (x) Add a tag
Flag as ContentBug
Processing
© 2008 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker