Developing BizTalk Applications

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. For more information about CBR, see

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. For more information about BizTalk orchestrations, see

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 Specifying Binding Properties.

Unlike the earlier version of the adapters shipped with BizTalk Server, the Oracle Database adapter shipped with BizTalk Adapter Pack does not show up in the list of adapters in the BizTalk Server Administration console. This is because the latest Oracle Database adapter is a WCF custom binding. So, while the BizTalk Server Administration console displays the WCF-Custom adapter, it does not display the WCF custom bindings and hence, does not display the WCF based Oracle Database adapter.
Also, to generate metadata you must use the Consume Adapter Service BizTalk Project Add-in and not the Add Adapter Metadata Wizard, as used for the previous version of the adapter. For instructions on using the Consume Adapter Service Add-in, see Retrieving Metadata for Oracle Operations in Visual Studio. For more such differences between the adapter versions, see Migrating BizTalk Projects Created Using the BizTalk ODBC Adapter for Oracle Database.