My Oracle Support Banner

How To Replicate Data from Oracle to Postgres Using GoldenGate (Doc ID 1544137.1)

Last updated on MAY 11, 2022

Applies to:

Oracle GoldenGate - Version and later
Information in this document applies to any platform.


 Starting with Oracle GoldenGate data can now be replicated between Oracle and Postgres. This note contains a basic setup how to replicate data between Oracle and Postgres which can be easily modified to fit your needs.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 0. Installing and setting up Oracle GoldenGate connecting to an Oracle database
 1. Installing and setting up Oracle GoldenGate on the Postgres machine
 2. Demo table in Oracle and Postgres
 3. Verify Oracle DB connection
 4. Verify Postgres ODBC connection
 5. GoldenGate extract process
 6. Create DEFINITIONS File
 7. Copy DEFGEN File
 8. Postgres replicat
 9. Testing the configuration

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.