Understand BizTalk Adapter for Oracle E-Business Suite
BizTalk Adapter Pack features
The BizTalk Adapter Pack enables service-oriented programmatic access in order to interact with an external system. The adapters provide the following advantages to clients:
Consistent design-time experience. The adapters provide a common and user-friendly design-time experience for browsing, searching, and retrieving metadata of LOB artifacts.
Varied programming options. The adapters provide a choice of programming model including the Windows Communication Foundation (WCF) channel model, WCF service model, ADO.NET, Web services, or BizTalk Server supported models.
Uniform experience across LOBs. The adapters standardize on using WCF and Microsoft Windows Communication Foundation (WCF) Line of Business (LOB) Adapter SDK, and hence provide a uniform experience of gaining access to any LOB system.
As mentioned, the adapters are built on top of the WCF LOB Adapter SDK. The WCF LOB Adapter SDK provides a common basis for building integration adapters that a variety of client applications such as BizTalk Server and Microsoft Office can consume. The WCF LOB Adapter SDK aligns the adapter strategy with the Microsoft Services strategy by exposing integration adapters as Windows Communication Foundation (WCF) channels. For more information about the WCF LOB Adapter SDK, see WCF LOB Adapter SDK documentation.
Overview of the Oracle EBS adapter
The Microsoft BizTalk Adapter for Oracle E-Business Suite exposes Oracle E-Business Suite as a WCF service. Adapter clients can perform operations on the Oracle E-Business Suite by exchanging SOAP messages with the adapter. The adapter consumes the SOAP message and makes appropriate ODP.NET calls to perform the operation. The adapter returns the response from Oracle E-Business Suite back to the client in the form of SOAP messages.
The Oracle E-Business adapterdisplays metadata of the Oracle E-Business Suite artifacts (PL/SQL APIs, interface tables/views, concurrent programs, and request sets) and the underlying Oracle database artifacts (such as tables, functions, and procedures) that describe the structure of a SOAP message in the form of Web Services Description Language (WSDL). The Oracle E-Business adapter uses the Add Adapter Service Reference Visual Studio Plug-in, Add Adapter Metadata Wizard, and Consume Adapter Service BizTalk Project Add-in to enable adapter clients to retrieve metadata for operations. The adapter also generates programming artifacts that can be used in your programming solution. For more information about Add Adapter Service Reference Visual Studio Plug-in, Add Adapter Metadata Wizard, and Consume Adapter Service BizTalk Project Add-in, see Connect to the Oracle E-Business Suite in Visual Studio.
The Oracle E-Business adapter uses the Oracle Data Provider for .NET (ODP.NET) 11.1.0.7 to communicate with Oracle E-Business Suite. ODP.NET 11.1.0.7 is one of the components of Oracle Data Access Components (ODAC). You can use the Oracle E-Business adapter to communicate with Oracle E-Business Suite in the following ways:
By developing BizTalk applications. For more information, see Developing BizTalk Server Applications.
By using the Windows Communication Foundation (WCF) service model. For more information, see Develop Oracle Database Applications By Using the WCF Service Model.
By using the WCF channel model. For more information, see Develop SQL Applications by Using the WCF Channel Model.
Access to Oracle E-Business Suite
To perform operations in Oracle E-Business Suite, adapter clients must have access to relevant artifacts in Oracle E-Business Suite. External applications can add or remove data in Oracle E-Business Suite interface tables and the database tables by using SQL statements. Applications can also access data in the interface tables and the database tables by using views, functions, and procedures. With Microsoft BizTalk Adapter for Oracle E-Business Suite, adapter clients can browse the artifacts in Oracle E-Business Suite as well as in the underlying database. In Oracle E-Business Suite, the adapter clients can browse interface tables, interface views, concurrent programs, and request sets while in the underlying Oracle database, the adapter clients can browse tables, views, stored procedures, functions, PL/SQL APIs, and packages. Adapter clients can select the artifacts they require for their solution and retrieve metadata for those artifacts. This enables users to access and execute the operations on the artifacts in Oracle E-Business Suite and the underlying Oracle database.
This section lists the features of the Microsoft BizTalk Adapter for Oracle E-Business Suite.