How to use IBM App Connect with Oracle Database
Oracle Database is an object-relational database management system.
Cloud-managed connector
Connecting to Oracle Database
Complete the connection fields that you see in the App Connect Designer Catalog page or flow editor. If necessary, work with your Oracle Database administrator to obtain these values.
Oracle Database connection fields:
- Oracle host name and port
- Oracle database host name and port in the format <hostname>:<port>
- Required: True
- Default value: localhost:1521
- Oracle Database service name
- Oracle Database service name
- Required: True
- User name
- Oracle Database user name
- Required: True
- Password
- Password for the Oracle Database user
- Required: True
- Schema
- Schema qualifier for the database objects to be accessed. Schema will default to user name if
not specified.
- Required: False
- Network name:
- Specifies the name of the network that IBM® App Connect on IBM Cloud will use to access
your system. Required only if connecting to a system in a private network.
If you have already configured a network in IBM App Connect on IBM Cloud with access to the private network, you can select that network. Otherwise, you need to configure a network (download and configure a Secure Gateway) for use with a private network. For more information about how to configure a network, see Configuring a private network for IBM App Connect on IBM Cloud®.
Important: Ensure that the Secure Gateway Client has been started. If you need to, you can start the Secure Gateway Client as described in Configuring a private network for IBM App Connect: Finally, start and configure the Secure Gateway Client.- Required: False
To connect to a Oracle Database endpoint from the App Connect Designer Catalog page for the first time, expand Oracle Database, then click Connect. For more information about ways to connect to Oracle Database, see Managing accounts in App Connect.
Before you use the account that is created in App Connect in a flow, rename the account to something meaningful that helps you to identify it. To rename the account on the Catalog page, select the account, open its options menu (⋮), then click Rename Account.
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 Catalog page of the App Connect Designer.
For some applications, the events and actions in the catalog depend on the environment (IBM Cloud Pak for Integration or App Connect on IBM Cloud) 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 performing the actions in the flow.
Oracle Database actions
These are actions on this application that you want a flow to complete.
- Devices
-
- Create device
- Retrieve devices
- Update device
- Delete device
- Entries
-
- Create entry
- Retrieve entries
- Update entry
- Delete entry
- Modify distinguished name
- InetOrgPerson objects
-
- Create inetOrgPerson object
- Retrieve inetOrgPerson objects
- Update inetOrgPerson object
- Delete inetOrgPerson object
- Organizational persons
-
- Create organizational person
- Retrieve organizational persons
- Update organizational person
- Delete organizational person
- Organizational units
-
- Create organizational unit
- Retrieve organizational units
- Update organizational unit
- Delete organizational unit
- Persons
-
- Create person
- Retrieve persons
- Update person
- Delete person
- Rooms
-
- Create room
- Retrieve rooms
- Update room
- Delete room
More items are available when you have connected App Connect to Oracle Database.
Examples

Creating an event-driven flow
Learn how to use IBM App Connect Designer to configure an event-driven flow that creates a contact in an Oracle Database table for each Salesforce lead.