Using BizTalk with SQL Databases
What you'll learn
- BizTalk SQL Polling - Trigger BizTalk to run when data is added or flagged in SQL
- Calling BizTalk Stored Procs
- BizTalk old SQL Adapter (BizTalk 2016 and before, not available in BizTalk 2020)
- BizTalk - WCF-SQL Adapter
- Using User-Defined-Tables (UDTS) with BizTalk
- Request-Response (Two-Way) Send Ports
- BizTalk Orchestration and Maps related to SQL
- Polling Options (PollWhileDataFound, AmbientTransaction, PollingInterval)
- Multipart Message-Types (Used by Old SQL Adapter)
- Passing Complex One-to-Many Data Structures to a Stored Proc using UserDefinedTypes
Requirements
- Must have some prior knowledge of BizTalk (schemas, orchestrations, maps, send/receive ports, etc)
- Must have some prior knowledge of SQL queries, updates, inserts, and stored procedures
Description
This course is for developers with understanding of BizTalk basics. Learn how to read and write data to and from Microsoft SQL Server databases. Learn how to generated schemas, call stored procedures to retrieve and update/insert data in SQL.
Learn how BizTalk SQL Polling 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-SQL Adapter available since at least BizTalk 2010, and learn the older BizTalk SQL Adapter that can be found in older releases (but was removed in BizTalk 2020).
BizTalk orchestrations have the ability to send XML messages to Microsoft SQL server (and other databases) using the WCF-SQL Adapter. 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".
Who this course is for:
- Students who have taken my "Real World BizTalk 2020 for Developers" and want to know how to work with SQL data from BizTalk
- BizTalk developers that want to know how to work with SQL data from BizTalk
Instructor
I’m a former Microsoft Certified Trainer and went to the Train-The-Trainer Bootcamp held by Microsoft in Redmond back in about 2004.
After that I was a stand-up instructor travelling around the US and Canada teaching BizTalk for a year or so,
THEN I went into BizTalk Consulting and have been doing it ever since.
Neal has degrees in accounting, business, law and more recently a Master of Arts in Jewish Studies from Hebrew College (Boston).