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 :
265
BizTalk and OLEDB
OLEDB data
providers represent some of the most important contemporary repository
platforms. Being able to incorporate these data sources is key to evolving a
BizTalk solution within the enterprise. Fortunately, BizTalk
Utilities provides
a database adapter designed specifically to connect BizTalk Server to
OLEDB-compliant databases.
How it Works
This part of the BizTalk
Utilities Adapter for Databases establishes a connection with an OLEDB
data source on behalf of BizTalk Server, by using the OLEDB .NET Data Provider
from Microsoft.
The adapter
accomplishes this by introducing three specialized components:
1.
The OLEDBAIC
Application Integration Component which can execute stored procedures, as well
as standard Insert, Update, and Delete statements. It receives an XML document
from BizTalk Server containing the details of each action, and translates this
into Transact SQL syntax. This AIC is configured using a separate Wizard
utility. Additionally, XML documents are mapped to data sources using the
BizTalk Mapper. See the sample dialog screens below.
2.
A separate
Command AIC (“OLEDB CommandAIC”) is also provided, allowing for single SQL
statements to be executed, including database queries. Results from queries can
be returned to BizTalk Server or an MSMQ. Below is a sample screen shot from
the configuration Wizard used to set up the AIC.
3.
Finally, the
OLEDB Receive Function gives you the option of querying the OLEDB data source
at preset intervals. The Receive Function configuration Wizard supports the
creation of both Interval Receive Functions (for interval periods of up to 21
days) and Standalone Receive Functions (for longer intervals). Examples of the
dialog forms used by the Wizard are displayed below.
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
BizTalk
Utilities supplies a key adapter technology that is easily set up and instantly provides
access to OLEDB data sources. This not only increases the range of integration
opportunities within your BizTalk solution, it also dramatically reduces the
amount of custom development you would normally be required to perform in order
to accomplish this level of interoperability.
To learn more about these and other features, download an evaluation copy of BizTalk
Utilities
Email TopXML