My Oracle Support Banner

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

Last updated on MARCH 27, 2024

Applies to:

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

Goal

 Starting with Oracle GoldenGate 11.2.1.0.2 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.

 

Solution

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
Goal
Solution
 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
References

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