Mark Wilson I am the creator of TopXML. I am available for international and local (Australia) contracts. I am a Solution Architect/Business Analyst. I have worked in IT in several countries (NZ, Australia, South Africa, UK) building and training teams for government and very large non-governmental organizations. I am ex-Microsoft Consulting Services. I wrote the first book on Microsoft XML published in 2000 called XML Programming with VB and ASP. Most recently I have been building tools for the SEO industry. Ask me for a 37 point SEO health-checkup for your website.
First posted :
03/24/2008
Times viewed :
259
BizTalk and SQLXML Templates
SQL Server offers
data access via query statements that can be stored in templates that exist as
XML documents. These can be accessed and executed via the SQLXML data provider. BizTalk
Utilities establishes a bridge between BizTalk Server and this part of
the SQL Server environment.
How it Works
BizTalk
Utilities
Adapter for Databases provides the ability for BizTalk Server to issue messages
that are translated into SQLXML-compliant commands and then forwarded to SQL
Server.
The adapter
accomplishes this by positioning an Application Integration Component called
“SQLTemplateAIC” between BizTalk Messaging and SQL Server. This component
receives messages from BizTalk Server and relays them via the SQLXML data
provider so that they can launch template files. The AIC is easily configured
using the SQL Template Wizard. Sample screen shots demonstrating the few simple
steps required to set up SQLTemplate AIC are shown below.
Summary
Much like stored
procedures, template files provide a convenient way to keep data access logic
part of the SQL Server environment. Being able to execute this logic from
BizTalk is now a simple matter using a single BizTalk
Utilities component that
can be deployed and configured in a few easy steps.
To learn more about these and other features, download an evaluation copy of BizTalk
Utilities
Email TopXML