This course is for developers with understanding of BizTalk basics. Learn how to read and write data to and from Microsoft SQLServer databases. Learn how to generated schemas, call stored procedures to retrieve and update/insert data in SQL.

Learn how BizTalk SQLPolling works, and how to tune the polling parameters for you business needs. Polling allows BizTalk to start an orchestration when certain data appears in the database.

Learn the WCF-SQLAdapter available since at least BizTalk 2010, and learn the older BizTalk SQLAdapter that can be found in older releases (but was removed inBizTalk 2020).

BizTalk orchestrations have the ability to send XML messages to Microsoft SQL server (and other databases) using the WCF-SQLAdapter. A two-way send port is used, basically sending a request and receiving a response.

This course also shows how to use User Defined Tables to send multiple rows of data to and from stored procedures, allow more efficient bulk transactions when needed.

WCF-SQL Architecture, Polling SQL via Receive Locations, how to create an XSD schema from a stored procedure, using tracking.

The course also covers the old BizTalk SQL adapter which is deprecated, just in case you are called upon to upgrade an older system. This section includes both stored procedures and something called "UpdateGrams".