Edit

Develop your Oracle E-Business Suite applications

  • Article

Overview

The Microsoft BizTalk Adapter for Oracle E-Business Suite is a Windows Communication Foundation (WCF) binding. Client applications can consume the Oracle E-Business adapter to invoke operations on Oracle E-Business Suite artifacts. The Oracle E-Business adapter can be consumed:

  • Through a physical port binding in a BizTalk Server solution.

  • By invoking methods on an instance of a client proxy.

  • By sending SOAP messages over a channel instance in code that uses the WCF channel model.

BizTalk vs WCF service vs WCF channel

The following table:

  • Lists the different operations that can be performed on Oracle E-Business Suite using the Oracle E-Business adapter.

  • Provides links to the topics containing information about performing the task using the chosen approach (BizTalk Server, WCF service model or WCF channel model).

Operation BizTalk Server WCF Service Model WCF Channel Model
Performing operations on interface tables and views Insert, update, delete, or select on interface tables and interface views with Oracle E-Business Suite Insert, update, delete, or select operations on interface tables and views using the WCF service model Run an insert operation on an interface table in Oracle E-Business Suite using the WCF channel model
Performing operations on tables and views with large data types Complete operations on tables with large data types in Oracle E-Business Suite using the WCF service model Complete operations on tables with large data types in Oracle E-Business Suite using the WCF service model
Performing composite operations on Oracle database Complete composite operations on Oracle E-Business Suite
Invoking concurrent programs in Oracle E-Business Suite Invoke concurrent programs in Oracle E-Business Suite Invoke concurrent programs in Oracle E-Business Suite using the WCF service model
Invoking request sets in Oracle E-Business Suite Invoke request sets in Oracle E-Business Suite Invoke request sets in Oracle E-Business Suite using the WCF service model
Performing ExecuteReader, ExecuteScalar, or ExecuteNonQuery operations ExecuteReader, ExecuteScalar, or ExecuteNonQuery operations in Oracle E-Business Suite ExecuteReader, ExecuteScalar, or ExecuteNonQuery operations in Oracle E-Business Suite using the WCF service model
Polling Oracle database Using BizTalk Server Poll Oracle E-Business Suite using BizTalk Server Poll Oracle E-Business Suite using the WCF service model
Receiving database change notifications from Oracle E-Business Suite Receive Oracle Database Change Notifications Using BizTalk Server Receive Oracle E-Business Suite database change notifications using the WCF service model Poll Oracle E-Business Suite using SELECT statement with the WCF channel model

Next steps

The topics in this section provide information, procedures, and examples to help you develop applications that consume the Oracle E-Business adapter in both BizTalk Server and .NET programming solutions.