Oracle GoldenGate provides seven data replication solutions:
High availability:
Live standby for an immediate failover solution that can later resynchronize with its primary source
Active solutions for continuous availability and transactional load distribution between two or more active systems
Zero downtime upgrades and migrations:
Eliminates downtime for upgrades and migrations
Live reporting:
Feeding a reporting database to not burden the source production systems with BI users or tools
Operational BI:
Transactional Data Integration:
Cloud and On-Premises:
Real-time bidirectional data feeds between On-Premises and public Clouds that are both secure and reliable
Support for Big Data:
Real-time, noninvasive data consolidation into Big Data targets
Interfaces with industry standard software components to offer access to semi-structured data
The following diagram shows the simplified architecture for the various solutions available from GoldenGate software:
We have discovered that there are many solutions where GoldenGate can be applied. Now, we can dive into how GoldenGate works, the individual components, processes, and the data flow that is adopted for all.