Udemyintermediateen

Using BizTalk with SQL Databases

Master BizTalk integration with WCF and SQL. Learn to build robust solutions using the latest and older SQL Adapters. Boost your integration skills!

4.5(31)
320students
8h 3m
Certificate
Neal Walters
Neal WaltersBizTalk Consultant

Course Content

Using BizTalk with SQL Databases is an intermediate-level Udemy course taught by Neal Walters. It runs 8h 3m, is taught in English, and includes a certificate of completion. Learners rate it 4.5 out of 5 from 31 reviews, with 320 students enrolled. It is a paid course, last updated August 2022.

Mastering SQL Integration with Microsoft BizTalk

This course is designed for developers already familiar with BizTalk fundamentals. Deepen your skills in connecting Microsoft BizTalk Server to Microsoft SQL Server databases. You'll gain practical expertise in reading and writing data, enabling seamless data exchange between your BizTalk solutions and SQL Server.

Key Topics Covered:

  • Schema Generation: Learn how to automatically generate schemas from SQL Server, streamlining your development process.
  • Stored Procedure Integration: Discover how to call stored procedures within BizTalk orchestrations to efficiently retrieve and update/insert data.
  • BizTalk SQL Polling: Understand the power of BizTalk SQL Polling – a mechanism that triggers orchestrations when new data arrives in your database. Learn to tune polling parameters for optimal performance based on your specific business needs.
  • WCF-SQL Adapter (BizTalk 2010+): Explore the modern WCF-SQL adapter, available in BizTalk Server 2010 and later. This adapter enables powerful XML message exchange with SQL Server.
  • Legacy BizTalk SQL Adapter (Older Releases): Gain insight into the older BizTalk SQL adapter, found in earlier BizTalk Server releases (but deprecated since BizTalk 2020). This knowledge is valuable for maintaining or upgrading existing systems. The course covers both stored procedures and "UpdateGrams" used with this adapter.
  • Two-Way Communication: Utilize a two-way send port to send requests to SQL Server and receive responses, facilitating bidirectional data flow.
  • User Defined Tables: Learn to leverage User Defined Tables for efficient bulk data transactions, enabling the sending of multiple rows to and from stored procedures.
  • WCF-SQL Architecture: Understand the underlying architecture of the WCF-SQL adapter.
  • Receive Locations & Polling: Master configuring Receive Locations for polling SQL data.
  • XSD Schema Creation: Learn how to automatically create an XSD schema directly from a stored procedure definition.
  • BizTalk Tracking: Utilize BizTalk tracking to monitor and troubleshoot your SQL integration processes.

This course provides a comprehensive understanding of integrating BizTalk Server with SQL Server, empowering you to build robust and efficient data-driven applications.

$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.