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

Prerequisites for Creating a Connection

You must satisfy the following prerequisites to create a connection with the PostgreSQL Adapter:

PostgreSQL Database Prerequisites

  • Ensure that you have write permissions on the database.

  • Ensure that you have the required permissions to run stored procedures and packages against the PostgreSQL database.

  • Know the database hostname or IP address and the port number.

  • Know the database name.

  • Know the user name and password for connecting to the database.

  • Ensure that the same database name, which you configured on the Connections page, is selected on the Invoke a Stored Procedure page in Oracle Integration. See No Package/Procedure Found.

  • The connectivity agent is required to connect Oracle Integration with a PostgreSQL on-premises database. See Configure an Agent Group.

  • Allowlist Oracle Integration instance public IP addresses in the security group of the PostgreSQL cloud instance.

Bulk Data Import Operation Prerequisites

Before using the bulk data import operation, ensure that file header names match with target table fields and the order of fields is the same.

SSL Prerequisites

Before connecting Oracle Integration with a PostgreSQL cloud/on-premises database over Secure Sockets Layer (SSL), ensure that a connectivity agent is configured. See Configure the Endpoint Access Type.

OCI Managed Database Prerequisites

  1. Install the connectivity agent within the same Virtual Cloud Network (VCN) as the PostgreSQL OCI instance.
  2. Establish a connection to the PostgreSQL OCI instance using its private IP address from Oracle Integration through the configured connectivity agent.