Oracle GoldenGate solutions
Oracle GoldenGate provides five data replication solutions:
High Availability
Live Standby for an immediate fail-over solution that can later re-synchronize with your primary source.
Active-Active solutions for continuous availability and transaction 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 so as not to burden the source production systems with BI users or tools.
Operational Business Intelligence (BI)
Real-time data feeds to operational data stores or data warehouses, directly or via Extract Transform and Load (ETL) tools.
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).
The following diagram shows the basic architecture for the various solutions available from GoldenGate software:
We have discovered there are many solutions where GoldenGate can be applied. Now we can dive into how GoldenGate works, the individual processes, and the data flow that is adopted for all.