Poll SQL Server using the SQL Adapter with BizTalk Server
You can configure the SQL adapter to receive polling-based data-changed messages from SQL Server. You can specify a polling statement that the adapter executes to poll the database. The polling statement can be a SELECT statement or a stored procedure that returns a result set. Based on the type of polling message received, the adapter exposes three different ways of polling:
Polling. This operation returns a data set as part of the polling message. At design time, the schema of the database object being polled is not available. Instead, the schema is available as part of the polling message during run time.
TypedPolling. This operation returns a strongly-typed polling message. At design time, the schema of the database object is also available. You must use this operation for polling if you want to map certain elements from the polling message to another schema, which could be for another operation.
XmlPolling. This operation returns the polling message as an XML message. You must use this operation if you want to use SELECT statements or stored procedures that use the FOR XML clause to return data as XML messages. For more information about the FOR XML clause, see FOR XML (SQL Server).
For more information about these polling operations, see Support for Polling.
The SQL adapter enables adapter clients to have a single BizTalk application with more than one Polling or TypedPolling operations for the same database or table. To support such a scenario, the adapter includes a unique ID— InboundID—in the connection URI. This ID, when added to the connection URI, makes it unique, thereby enabling multiple polling operations in a single BizTalk application.
The topics in this section provide instructions on how to use Polling, TypedPolling, and XmlPolling in a BizTalk application. This section also provides information about how to use the InboundID connection property.