How to use IBM App Connect with Oracle Database

Connecting to Oracle Database

Complete the connection fields that you see in the App Connect Designer Connect > Applications and APIs page (previously the Catalog page) or flow editor. If necessary, work with your Oracle Database administrator to obtain these values.

Database hostname

Specify the fully qualified hostname or the IP address of the Oracle Database server. For example, myserver.abc.com or 192.0.2.24.

Database port

Specify the port on which the Oracle Database server listens for incoming client connections.

Database name

Specify the name of the database that you want to connect to.

Username

Specify a username that is authorized to access the database.

Password

Specify the password for the database user.

Schema

Specify the schema qualifier for the database objects to be accessed. If you leave this field blank, the schema defaults to the username.

Maximum pool size

Specify the maximum number of database connections that are allowed within a single connection pool. If unspecified, the value defaults to 0 (zero).

Additional parameters

Specify extra parameters to control how to connect to the database. Use name-value pairs (with a semicolon separator) in the following format: name1=value1;name2=value2.

Example: autoCommit=true;maxActive=20

If you're using Oracle Real Application Clusters (RAC), the following additional parameter is needed to define the Oracle RAC service name.

ServiceName=oracleRACserviceName

Private network connection

Select the name of a private network agent that App Connect uses to connect to your private network. This list is populated with the names of private network agents that are created on the Private networks page. For more information, see Connecting to a private network.

To connect to a Oracle Database endpoint from the App Connect Designer Applications and APIs page for the first time, expand Oracle Database, then click Connect. For more information, see Managing accounts.

General considerations

Before you use App Connect Designer with Oracle Database, take note of the following considerations:

• (General consideration) You can see lists of the trigger events and actions that are available on the Applications and APIs page of the App Connect Designer.

  For some applications, the events and actions depend on the environment and whether the connector supports configurable events and dynamic discovery of actions. If the application supports configurable events, you see a Show more configurable events link under the events list. If the application supports dynamic discovery of actions, you see a Show more link under the actions list.

• (General consideration) If you are using multiple accounts for an application, the set of fields that is displayed when you select an action for that application can vary for different accounts. In the flow editor, some applications always provide a curated set of static fields for an action. Other applications use dynamic discovery to retrieve the set of fields that are configured on the instance that you are connected to. For example, if you have two accounts for two instances of an application, the first account might use settings that are ready for immediate use. However, the second account might be configured with extra custom fields.

Events and actions

Oracle Database events

These events are for changes in this application that trigger a flow to start completing the actions in the flow.

Show more configurable events: Events that are shown by default are pre-configured by using optimized connectivity. More items are available after you configure events that can trigger a flow by polling this application for new or updated objects.

Oracle Database actions

Your flow completes these actions on this application.

Available items are listed when you have connected App Connect to Oracle Database.