1. Oracle GoldenGate Classic Documentation
  2. Prepare
  3. Prepare Your Database for Oracle GoldenGate Classic Architecture
  4. PostgreSQL
  5. Preparing the Database for Oracle GoldenGate
  6. Prepare a Database Connection

Prepare a Database Connection

Oracle GoldenGate connects to a PostgreSQL database through an ODBC (Open Database Connectivity) driver and requires a system Data Source Name (DSN) be created with the correct database connection details for each source and target PostgreSQL database.

Ensure that you have installed and configured the driver prior to creating a DSN, by following the instruction in Configure a Database Connection in Linux.

Note:

Do not use PgBouncer setup for Extract connections to the PostgreSQL database because PgBouncer does not understand the replication protocol, because of which the Extract connection is not identified as replication connection.

Note:

Oracle GoldenGate does not support connections to PostgreSQL that use Pgpool.

This section contains instructions for setting up the DSN connections that Extract and Replicat will use.