Edit

Share via

Create a connection to Oracle E-Business Suite

  • Article

The Microsoft BizTalk Adapter for Oracle E-Business Suite is a Windows Communication Foundation (WCF) custom binding. As such, it enables communication to Oracle E-Business Suite through a WCF endpoint address. In WCF the endpoint address identifies the network location of a service and is typically expressed as a Uniform Resource Identifier (URI). The Oracle E-Business adapter expresses this location as a connection URI, which contains properties that the Oracle E-Business adapter uses to establish a connection to Oracle E-Business Suite. You must specify a connection URI when you:

  • Create a channel factory or a channel listener using the WCF channel model or when you create a WCF client or service host using the WCF service model.

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

  • Use the Add Adapter Service Reference Visual Studio Plug-in to generate a WCF client class or WCF service interface for a WCF service model solution.

  • Use the Consume Adapter Service BizTalk Project Add-in to retrieve message schemas from the Oracle E-Business adapter for a BizTalk Server solution.

  • Use the ServiceModel Metadata Utility tool (svcutil.exe) to generate a WCF client class or WCF service interface for a WCF service model solution.

Ways to connect to Oracle

The Oracle E-Business adapter supports two ways of establishing a connection to the underlying Oracle database:

  • Using tnsnames.ora. In this approach, the connection URI provided by the adapter client contains only the net service name entered in the tnsnames.ora file. The adapter extracts the connection parameters, such as server name, service name, port number, and so on, from the net service name entry in the file. To use this approach, the computer running the Oracle client must be configured to include the net service name for the Oracle database in the tnsnames.ora file.

    Important

    Due to an Oracle Client limitation, the DataSourceName parameter (net service name) in the Create the Oracle E-Business Suite connection URI cannot contain more than 39 characters if you are performing operations in a transaction. Therefore, if you are performing operations in a transaction, make sure that the DataSourceName parameter value is less than or equal to 39 characters.

  • Without using tnsnames.ora. In this approach, the adapter clients enter the connection parameters directly in the connection URI. This does not require the net service name to be present in the tnsnames.ora file on the client computer. This approach does not even require the tnsnames.ora file to be present on the client computer.

    Important

    This mode of connectivity is not supported if you are performing operations in a transaction. This is due to a limitation of Oracle Client.

In this section

The following topics describe how to establish a connection between the Oracle E-Business adapter and Oracle E-Business Suite: