GoldenGate Data Synchronization Platform

The Capture module is configured on the source database system.  It retrieves the insert, update and delete transactions and outputs the information to the platform queues. Queued records are stored in GoldenGates’s universal data format. Queued records are usually written to binary flat files on the target system.

The Delivery module, an independent operating system level process on the destination system, performs the function of applying changes to the designated tables of the destination database system. As soon as the data is available in queue records or flat files, the Delivery process reads transaction details and posts them to the designated destination database objects. Changes are applied in the same order as they are committed at the source database system to ensure data and referential integrity.

The Manager component is the main interface that is used to manage the whole replication platform.  Manager tracks the growth queue records, starts and restarts the processes, and also monitors.

The GoldenGate solution is a non-Oracle and multi-process system and consequently, it is not affected by resource levels within the database.  At the same time, since GoldenGate processes are outside the database system, it does not create any overhead in the primary database system.  Details on GoldenGate solutions are available at www.goldengate.com.