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 the Oracle installation. Also, since Goldengate is the primarily tool that is used, we will cover the Goldengate installation for both Oracle and PostgreSQL.
To install the Oracle 11g software on the Linux platform, you may refer to either of the following web links: http://oracle-base.com/articles/11g/oracle-db-11gr2-installation-on-oracle-linux-5.php and http://dbaora.com/install-oracle-11g-release-2-11-2-on-centos-linux-7/ ...
Get PostgreSQL High Performance Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
