Oracle GoldenGate Remote Capture and Delivery Support Overview

Oracle GoldenGate can run on a machine separate from the source or target database server. This setup is called Oracle GoldenGate remote capture and delivery.  This blog summarizes what is supported by Oracle GoldenGate and how to use it. 
​
1. What's Supported 
As of 12.1.2.+ version, the following Oracle GoldenGate packages support remote capture and delivery:

• Oracle GoldenGate for Oracle DB (capture/delivery) 
• Oracle GoldenGate for MySQL (delivery) 
• Oracle GoldenGate for DB2 LUW (capture/delivery)
• Oracle GoldenGate for Informix (capture/delivery) 
• Oracle GoldenGate for Big Data (delivery) 
• Oracle GoldenGate for Teradata (delivery) 
• Oracle GoldenGate for iSeries (delivery) 
• Oracle GoldenGate for SQL Server (delivery) 
• Oracle GoldenGate for JMS (capture/delivery)

Oracle GoldenGate for DB2 z/OS, Non-Stop, DB2 iSeries, and SQL Server do not support remote capture.

Oracle GoldenGate for DB2 iSeries Allows Capturing from Remote Journals

Oracle GoldenGate for DB2 iSeries supports remote journals. This feature allows GoldenGate extract running on a remote IBM i system to read journal data generated from the primary IBM i system. This eliminates most of the interactions of Oracle GoldenGate extract with the primary system, but Oracle GoldenGate for DB2 iSeries still needs the connection to the primary system for the metadata retrieval.

2. How to Use Remote Capture and Delivery
To run remote capture/delivery, different databases use different approaches. 

• Oracle GoldenGate for Oracle DB 
  You can perform remote capture with the following two methods: (1) Integrated Capture with  SQL*Net connection (2) Downstream capture in either real-time or archive log mode [2]​ For downstream data capture mode, you need to setup Oracle Data Guard to ship the redo log files to the downstream database continuously as "standby redo log". It's required the source database to be 10.2.0.4+ and the downstream database to be 11.2.0.3.0+. 
• Oracle GoldenGate for DB2 LUW
  With DB2 connect, user can setup the remote DB2 as if they are an local database instance. Oracle GoldenGate then can capture from the remote DB2 database via the local accessing point setup by the DB2 connect. 
• Oracle GoldenGate for Informix 
  You can setup the ODBC connection to access the informix database on the remote server Oracle GoldenGate machine for access. The followings requirements need to be met: Endian order of both the systems should be same and the second is the bit width (32bit or 64bit) has to be same. For example from Linux to Linux, Windows to Windows, Solaris to Solaris but not across.
• Oracle GoldenGate for MySQL 
  For Oracle GoldenGate to delivery to MySQL database remotely, you just need to use the TARGETDB to specify the target database connection with the username and password. The MySQL user should have the remote access privileges. 

Can a Oracle downstream database have multiple sources?

Answer: Yes [2]

​References 

1. Configure GoldenGate Extract to read from remote logs
2. Oracle GoldenGate Best Practices: Configuring Downstream Integrated Extract (Doc ID 1485620.1)

Created 5/23/2016, Last Updated 6/6/2017