O'Reilly logo

PostgreSQL Cookbook by Chitij Chauhan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Replicating data from other databases to PostgreSQL using GoldenGate

In this recipe, we are going to cover heterogeneous replication using the Oracle GoldenGate software. We are going to migrate table data from Oracle to PostgreSQL.

Getting ready

Since this recipe talks about replicating data from Oracle to PostgreSQL, it is important to cover Oracle installation. Also, since GoldenGate is the primary tool used, we will also cover the GoldenGate installation for both Oracle and PostgreSQL.

To install the Oracle 11g software on the Linux platform, you may refer to any of the following web links:

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required