Oracle GoldenGate solutions

Oracle GoldenGate provides seven data replication solutions:

1. 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
2. Zero downtime upgrades and migrations:
   • Eliminates downtime for upgrades and migrations
3. Live reporting:
   • Feeding a reporting database to not burden the source production systems with BI users or tools
4. Operational BI:
   • Real-time data integration to operational data stores or data warehouses directly or via Extract, Load, and Transform (E-LT) tools
   • Trickle fed data warehouses that eliminate batch or Extract, Load, and Transform processes
5. Transactional Data Integration:
   • Real-time data feeds to messaging systems for business activity monitoring, business process monitoring, and complex event processing
   • Uses event-driven architecture and service-oriented architecture (SOA)
6. Cloud and On-Premises:
   • Real-time bidirectional data feeds between On-Premises and public Clouds that are both secure and reliable
7. 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 pe into how GoldenGate works, the inpidual components, processes, and the data flow that is adopted for all.