1. Using the Oracle Database Adapter with Oracle Integration 3
  2. Create an Oracle Database Adapter Connection
  3. Prerequisites for Creating a Connection

Prerequisites for Creating a Connection

You must satisfy the following prerequisites for creating a connection with Oracle Integration.

  1. Ensure that you have write permissions to the database.
  2. Ensure that you have the required permissions to run stored procedures and SQL statements.
  3. Know the database URL, including the hostname or IP address and the port number.
  4. Know the database system ID and service name.
  5. Know the username and password for connecting to the database.
  6. Oracle Integration can connect to Oracle Real Application Clusters (RAC) databases with the on-premises connectivity agent using Single Client Access Name (SCAN) as the hostname while configuring the connection. SCAN provides a single name for clients to access any Oracle Database running in a cluster.