Key features in BizTalk adapter for Oracle E-Business Suite

This section lists the key features in Microsoft BizTalk Adapter for Oracle E-Business Suite.

Feature Comment
Use of Windows Communication Foundation (WCF) The Oracle E-Business adapter is built on top of the Microsoft Windows Communication Foundation (WCF) Line of Business (LOB) Adapter SDK (WCF LOB Adapter SDK). In turn, the WCF LOB Adapter SDK is built on top of WCF. The adapters are exposed as WCF channels to adapter clients. This enables connectivity, metadata exchange, and business data exchange with external systems.
Support for the WCF channel model and the WCF service models In the WCF channel model, adapter clients can consume the Oracle E-Business adapter by directly sending and receiving XML messages.

In the WCF service model, adapter clients can generate a .NET proxy class from the Web Services Description Language (WSDL) obtained using Oracle E-Business adapter.
Use of ODP.NET The Oracle E-Business adapter uses the Oracle Data Provider for .NET (ODP.NET) to interface with Oracle E-Business Suite.
Two ways of connecting to Oracle E-Business Suite The adapter clients can connect to Oracle E-Business Suite by either using the net service name in the tnsnames.ora file or by directly specifying the connection parameters, and thus eliminating the need to use a net service name or the tnsnames.ora file. Not requiring the tnsnames.ora file to connect to Oracle E-Business Suite saves you from the hassle of manually updating the connection parameters (net service name) in the tnsnames.ora file on every client computer when you add or update Oracle servers in your environment. For more information, see Configure Connection to the Oracle E-Business Suite.
Support for Windows Authentication The adapter clients can use Windows Authentication to connect to Oracle E-Business Suite. Windows Authentication enables you to determine the user’s identity based on the Windows logon credentials, and thus helps you to leverage the built-in security of the Windows environment. For more information about Windows Authentication in the Oracle E-Business adapter, see Connect to Oracle E-Business Suite Using Windows Authentication.
Support for using the Oracle E-Business adapter with Microsoft Office SharePoint Server (MOSS) You can use the adapters to present data from the Oracle E-Business Suite onto a MOSS portal. For more information, see Using the Oracle E-Business Adapter with Microsoft Office SharePoint Server.
Feature Comment
Batch retrieval of metadata Adapter clients can browse and search metadata for all the artifacts exposed by Oracle E-Business Suite and the underlying database. The artifacts are displayed based on the connected user credentials, and are:

- Grouped by each application for the Oracle E-Business Suite artifacts.
- Grouped by each artifact in Oracle E-Business Suite and the underlying database.
- Grouped by each schema for the underlying database artifacts.
Feature Comment
Connection pooling The Oracle E-Business adapter enables clients to use the ODP.NET connection pooling by configuring the UseOracleConnectionPool binding property. For more information about this binding property, see Read about the BizTalk Adapter for Oracle E-Business Suite Binding Properties.
Cache management The Oracle E-Business adapter enables clients to use the ODP.NET cache management by configuring the StatementCachePurge and StatementCacheSize binding properties. For more information about this binding property, see Read about the BizTalk Adapter for Oracle E-Business Suite Binding Properties.
Support for performance counters The Oracle E-Business adapter supports WCF-based performance counters for use by adapter clients. For more information about performance counters, see Use Performance Counters with the SQL adapter.
Feature Comment
Support for operations on interface tables and interface views Adapter clients can perform basic Insert, Update, Delete, and Select operations on Oracle E-Business Suite interface tables. Only select operation can be performed on the Oracle E-Business Suite interface views.
Support for executing PL/SQL APIs Adapter clients can execute PL/SQL APIs in Oracle E-Business Suite. PL/SQL APIs contain stored procedures and functions within a package.
Support for executing concurrent programs Adapter clients can execute concurrent programs in Oracle E-Business Suite.
Support for executing request sets Adapter clients can execute request sets in Oracle E-Business Suite. A request set is a set of concurrent programs, and can be used to run several concurrent programs with predefined parameters. Request sets are executed in stages. For more information about request sets, see https://go.microsoft.com/fwlink/?LinkId=129539.
Support for specifying inline values in the Insert operation You can use the InlineValue attribute in the Insert operation to insert computed values into interface tables and database tables in Oracle. This is an optional attribute and is available for all simple data records in an Insert operation. If you specify a value for this attribute, it overrides the specified value of a record. For more information about the InlineValue attribute, see Operations on Interface Tables and Interface Views.
Support for inbound calls using polling The Oracle E-Business adapter supports receiving "polling-based" data-changed messages wherein the adapter executes a specified SQL statement, stored procedure, function, or procedure within a package, retrieves the data, and provides the result to the client.
Support for invoking functions and procedures Adapter clients can invoke functions and procedures in the underlying Oracle database. The Oracle E-Business adapter surfaces functions and procedures as operations that can be performed on the underlying Oracle database.
Support for composite operations The Oracle E-Business adapter enables adapter clients to perform composite operations in Oracle E-Business Suite. A composite operation can include any number of the following operations, and in any order:

- Operations on interface tables, interface views, tables, and views.
- Stored procedures, functions, and procedures within packages that are surfaced as operations in the adapter.
Support for executing arbitrary SQL statements and PL/SQL blocks The Oracle E-Business adapter enables adapter clients to execute arbitrary SQL statements or PL/SQL blocks using the ExecuteReader, ExecuteScalar, and ExecuteNonQuery operations. For more information about these operations, see Support for ExecuteNonQuery, ExecuteReader, and ExecuteScalar Operations.
Support for User-Defined Types (UDTs), boolean parameters, and PL/SQL table types Adapter clients can support operations in artifacts that contain UDTs, and operations in stored procedures and functions that contain boolean parameters and PL/SQL table type. For information about UDT support, see Support for Oracle User-Defined Types.
Support for input and output REF CURSORS Adapter clients can operate with input and output REF CURSORS on procedures and functions.
Support for PL/SQL RECORD data types Adapter clients can operate with RECORD and nested RECORD types in stored procedures and functions.
Support for overloaded functions and procedures in PL/SQL API Adapter clients can invoke overloaded functions and procedures in PL/SQL APIs. However, the Oracle E-Business adapter does not support the use of overloaded procedures using strongly-typed and weakly-typed REF CURSORS. Internally, the adapter treats both the strongly-typed and weakly-typed REF CURSORS as just REF CURSORS.
Support for database change notifications Adapter clients can receive database change notifications from Oracle database based on a triggering SELECT statement. The notification is sent by Oracle database to the adapter clients as and when the result set for the SELECT statement changes. For more information about database change notifications, see Consideration for Receiving Database Change Notifications using the ORacle Database adapter.
Support for synonyms Adapter clients can perform operations on synonyms created for tables, views, stored procedures, functions and packages. For more information about synonyms, and how you can use the Oracle E-Business adapter to perform operations on synonyms, see Operations on Synonyms.

Other Features

Feature Comment
Multi-Language Support (MLS) Adapter clients can use the Oracle E-Business adapter to perform operations in Oracle E-Business Suite and the underlying database having multiple language packs installed. This implies that the adapter clients can perform operations on the data in multiple languages. For example, you can view localized (non-English) data in an interface view, or insert localized data in a table. The Oracle E-Business adapter supports as many languages as those supported by the underlying Oracle E-Business Suite installation.

The Oracle E-Business adapter exposes the MlsSettings binding property to configure the multiple language support feature. For more information about the binding property, see Read about the BizTalk Adapter for Oracle E-Business Suite Binding Properties.

See Also

Understand BizTalk Adapter for Oracle E-Business Suite