How to use 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.

BASIC authentication connection fields

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 don't complete this field, 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 (for example, autoCommit=true;maxActive=20).

If you're using Oracle Real Application Clusters (RAC), the following extra 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.

SSL authentication connection fields (available only on IBM® App Connect Enterprise Designer running on-premises)

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 don't complete this field, the schema defaults to the username.

Database server CA certificate: Specify the CA or server certificate in PEM format only when the server uses a self‑signed certificate, or if the certificate is not already trusted (private CA).

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 (for example, autoCommit=true;maxActive=20).

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

To connect to an 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.

Your flow completes these actions on this application.

Available items are listed after you connect App Connect to Oracle Database.