Creating or editing an endpoint for an Oracle E-Business Suite activity

Endpoints provide the configuration information that Studio and the Integration Appliance use to connect to an Oracle database.  

Selecting or editing an Oracle E-Business Suite endpoint

  1. In the Create Endpoint or Edit Endpoint pane, configure the Oracle database as described in the following table. In addition to these fields, the endpoint pane contains Connection pool options and Remote Endpoint Configuration.
    Note: Changing the configuration properties of an endpoint affects all orchestrations that use that endpoint in the project. The edits are global, not local.
  2. Click Test Connection to confirm that the connection details are valid and you are able to connect to the Oracle database successfully.
  3. Click OK.
Table 1. Connection properties
Field Name Description
Oracle E-Business Suite connector - Connection Information
Interface Specifies the interface used to communicate with Oracle E-Business Suite. Currently, only database is supported, which uses JDBC API to communicate with Oracle E-Business Suite.
Host Name Specifies the host name or IP address of the machine on which the Oracle database is running.
Port Number Specifies the Oracle Internet port that allows Java™ applets or applications to access the database.
System ID Specifies the system ID (SID) to connect to the Oracle database.
User Name Specifies the user name to connect to the Oracle database.
Password Specifies the password associated with the user name to connect to the Oracle database.
Additional Properties Specifies the additional properties to be set when connecting to the database using the JDBC driver.
Connection Pool options
Minimum Connections Specifies the lowest number of Oracle database connections that the Integration Appliance keeps open in the connection pool. Entering 0 (zero) is supported. The default value is 5.
Maximum Connections Specifies the maximum number of Oracle database connections that the Integration Appliance can keep open in the connection pool. Entering 0 (zero) means the maximum number of connections is unbounded. The default value is 25.
Maximum Idle Time Specifies the amount of time in minutes that a Oracle database connection can be open in an idle state before being closed by the Integration Appliance. Entering 0 (zero) means that the connections are closed when they are returned to the pool —no idle time. The default value is 120 minutes.
Maximum Wait Specifies the amount of time in seconds that the Integration Appliance waits for a connection when all the connections in the pool are exhausted. If no connection is obtained after the wait time, an exception is thrown. The default value is 300 seconds.
Reclaim Connections Specifies the interval at which the connector checks for idle connections. Idle connections are reclaimed until the minimum number of connections is reached, as specified in the Minimum Connections parameter. The default value is 5 minutes.
Note: The Connection pool properties need to be configured as per the load (number of concurrent requests) on the endpoint.
Remote Endpoint Configuration
Endpoint Runs Behind Firewall Enables the secure connector name property so that secure connector can be used if the Oracle database is installed behind a firewall.
Secure Connector Name Specifies the name of the secure connector that is used to connect to the Oracle database is installed behind a firewall.



Feedback | Notices


Timestamp icon Last updated: Wednesday, 15 June 2016


http://pic.dhe.ibm.com/infocenter/wci/v7r0m0/topic/com.ibm.wci.doc/OracleEBS_creating_an_endpoint.html