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 :
277
BizTalk and ODBC
BizTalk
Utilities enables direct integration between BizTalk Server and ODBC-compliant
repositories, opening your BizTalk solution up to new potential data sources.
How it Works
The BizTalk
Utilities Adapter for Databases leverages the .NET development platform by
utilizing the .NET ODBC provider API (also known as ODBC.NET). Adapter
components then establish two way communication, supporting a series of common
data access functions.
The adapter
accomplishes this by introducing three specialized components:
1.
A custom
Application Integration Component (“Legacy DBAIC”) capable of performing Insert,
Update, and Delete SQL statements, as well as executing stored procedures.
Using a Mapper Configuration utility, SQL statements can be mapped to source
documents, as shown below.
2.
A
corresponding SQL Command AIC (“Legacy DBCommandAIC”) designed specifically for
the execution of single SQL statements. This component can launch stored
procedures and perform the standard Insert, Update, and Delete tasks, but is
also able to query repositories. It can therefore return results back to
BizTalk Server in XML format. Additionally, BizTalk
Utilities provides the
ability for the Command AIC to auto-generate input and output schemas from SQL
commands. Sample screenshots from the Legacy AIC configuration Wizard are
displayed below.
3. A Receive
Function that can be used to poll the database periodically at predefined
intervals. This intelligent Receive Function auto-generates a schema for the
XML data that is returned to the BizTalk Server, and even breaks up larger data
sets into multiple documents. Setting up the Receive Function is a straight
forward process, using the Receive Function configuration Wizard, as shown in
the following dialog boxes.
The adapter is further supplemented with Import and Output
Configuration Wizards that allow for configuration settings to be stored and
retrieved from XML documents.
Summary
For many
enterprise environments, database integration at the middleware level is a
critical requirement. BizTalk
Utilities Database Adapter not only bridges this
important gap, it does so with a set of reliable data management components
that are both easy to install and configure.
To learn more about these and other features, download an evaluation copy of BizTalk
Utilities
Email TopXML