Overview of BizTalk Adapter for Oracle Database

The Microsoft BizTalk Adapter for Oracle Database exposes the Oracle database as a WCF service. Adapter clients can perform operations on the Oracle database by exchanging SOAP messages with the adapter. The adapter consumes the WCF message and makes appropriate ODP.NET calls to perform the operation. The adapter returns the response from the Oracle database back to the client in the form of SOAP messages.

The Oracle Database adapter surfaces metadata of Oracle database artifacts (tables, functions, procedures, etc.) that describes the structure of a SOAP message in the form of WSDL. The Oracle Database adapter uses Add Adapter Service Reference Visual Studio Plug-in, Consume Adapter Service BizTalk Project Add-in, and Add Adapter Metadata Wizard to enable adapter clients to retrieve metadata for operations and generates programming artifacts that can be used in your programming solution.

The Oracle Database adapter uses the Oracle Data Provider for .NET (ODP.NET) to communicate with the Oracle database. You can use the Oracle Database adapter to communicate with the Oracle database in the following ways:

• By developing BizTalk applications. See Develop your BizTalk applications for more information.

• By using the Windows Communication Foundation (WCF) service model. See Develop Oracle Database applications using the WCF Service model for more information.

• By using the WCF channel model. See Develop Oracle Database applications using the WCF Channel Model for more information.

In This Section

• How Does the Adapter Connect to an Oracle Database?

• How Does the Adapter Surface Oracle Metadata?

• What Operations Can be Performed Using the Adapter?

• How does the Adapter Handle Transactions?

• Streaming Support for LOB Data Types in Oracle Database

• What operations are supported by the Oracle Database adapter

See Also

Understanding the Biztalk Adapter for Oracle Database