Oracle GoldenGate solutions
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:
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
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)
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.