Develop BizTalk applications using the Oracle Database adapter

Developing BizTalk applications involves creating a BizTalk project in Visual Studio and using the Consume Adapter Service BizTalk Project Add-in to generate XML schema. Once you have generated the schema, you can either use Content-Based Routing (CBR) or create BizTalk orchestrations to send and receive messages that conform to the generated schema.

CBR can be used in scenarios where the messages being sent to the Oracle database do not require any intensive processing. For example, if you know that the receive port will be receiving messages only of a certain type, you can add a filter to the send port to route the messages matching the filter expression to the send port.

In BizTalk orchestrations, you create send and receive ports to send and receive messages to and from the WCF-Custom adapter, which in turn sends the messages to BizTalk Server. This section provides information about using BizTalk orchestrations to perform operations on the Oracle database using the Oracle Database adapter. The Oracle Database adapter in turn uses the WCF-Custom adapter, which can interact with a WCF binding.


To use the Oracle Database adapter with Microsoft BizTalk Server, you must always set the EnableBizTalkCompatibilityMode binding property to True. For instructions about how to set the binding properties, see Configure the binding properties for Oracle Database.


The Oracle Database adapter included with BizTalk Adapter Pack is not listed in the BizTalk Server Administration console. The adapters in the BizTalk Adapter Pack are WCF-based, and use a WCF custom binding. The BizTalk Server Administration console displays the WCF-Custom adapter. It does not automatically display the WCF custom bindings and therefore does not display the WCF based Oracle Database adapter.

Also, to generate metadata, use the Consume Adapter Service BizTalk Project Add-in. Do not use the Add Adapter Metadata Wizard. For instructions on using the Consume Adapter Service Add-in, see Get metadata for Oracle Database operations in Visual Studio.

For other differences between the adapter versions, see Migrating BizTalk Projects Created Using the BizTalk ODBC Adapter for Oracle Database.

See Also

Develop your Oracle Database applications