The uses of GoldenGate

Introduction:

Oracle GoldenGate enables the exchange and manipulation of data at the transaction level among multiple, heterogeneous platforms across the enterprise. Its modular architecture gives you the flexibility to extract and replicate selected data records, transactional changes, and changes to DDL (data definition language) across a variety of topologies.

With this flexibility, and the filtering, transformation, and custom processing features of Oracle GoldenGate, you can support numerous business requirements:

• Business continuance and high availability.
• Initial load and database migration.
• Data integration.
• Decision support and data warehousing.

 

GoldenGate supports the above topologies

GoldenGate 11G currently supports the above configurations.

live reporting

The most basic Oracle GoldenGate configuration is a one-to-one configuration that replicates in one direction: from a source database to a target database that is used only for data  retrieval purposes such as reporting and analysis. Oracle GoldenGate supports like-to-like or heterogeneous transfer of data, with capabilities for filtering and conversion on either  system in the configuration (support varies by database platform).

real time data distribution

A data distribution configuration is a one-to-many configuration. Oracle GoldenGate supports synchronization of a source database to any number of target systems. Oracle GoldenGate  supports like-to-like or heterogeneous transfer of data, with capabilities for filtering and  conversion on any system in the configuration (support varies by database platform).

real-time data warehousing

A data warehousing configuration is a many-to-one configuration. Multiple source databases send data to one target warehouse database. Oracle GoldenGate supports like-to-like or heterogeneous transfer of data, with capabilities for filtering and conversion on any system in the configuration (support varies by database platform).

 

maintain a live standby database

Oracle GoldenGate supports an active-passive bi-directional configuration, where Oracle GoldenGate replicates data from an active primary database to a full replica database on a live standby system that is ready for failover during planned and unplanned outages.

active-active high availability

Oracle GoldenGate supports an active-active bi-directional configuration, where there are two systems with identical sets of data that can be changed by application users on either  system. Oracle GoldenGate replicates transactional data changes from each database to  the other to keep both sets of data current.