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 :
346
BizTalk and Oracle
The BizTalk
Utilities Database Adapter provides an extensive set of features enabling
two-way data exchange between BizTalk Server and Oracle data sources.
How it Works
Separate
integration channels can be established allowing for a variety of integration
configurations. Data access to both Oracle databases and Oracle Pipes is
supported.
The adapter accomplishes this by introducing five specialized components. The first
three allow for data exchange with Oracle databases, while the remaining two
components are specifically designed to integrate with Oracle Pipes.
1.
The
Application Integration Component referred to as the “OracleAIC” uses the Oracle. NET
provider to support standard data access tasks (Insert, Update,
Delete), as well as the execution of stored procedures. Commands are received
in the format of XML documents from BizTalk Server, and then transformed into
Oracle-compliant statements. The AIC is set up using a properties Wizard, and
XML documents are mapped to destination data sources via the BizTalk Mapper.
Some sample screen shots are provided below.
2.
The
“OracleCommandAIC” AIC supports launching stored procedures and the issuance of
Insert, Update and Delete statements as well. However, this component also
provides the ability to execute query statements. Results from queries can be
returned to BizTalk Server or an MSMQ. Below are sample configuration dialog
boxes.
3.
A Receive
Function designed to poll Oracle data sources is also supplied. As shown in the
sample forms below, the Oracle Receive Function can be configured to issue
queries at predefined intervals.
4.
As part of
the component set for integration with Oracle Pipes, BizTalk
Utilities provides
a separate AIC, called “OraclePipe AIC”. As shown in the sample configuration
Wizard form below, this AIC can be configured to submit messages directly to an
Oracle Pipe destination.
5.
Finally,
a Receive Function designed to retrieve messages from Oracle Pipes completes
the set of BizTalk
Utilities Oracle components. As with other Receive
Functions, the Oracle Pipe Receive Function can be configured to periodically
poll Oracle Pipe data sources. Below is a sample screen shot.
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
Through a
comprehensive family of specialized components, the BizTalk
Utilities database
adapter provides enterprise-level support for Oracle integration. This allows
you to fully leverage opportunities to interoperate with Oracle data sources.
To learn more about these and other features, download an evaluation copy of BizTalk
Utilities.
Email TopXML