Oracle Golden Gate is Oracle's strategic solution for real time data integration. Golden Gate software enables mission critical systems to have continuous availability and access to real-time data. It offers a fast and robust solution for replicating transactional data between operational and analytical systems. Oracle Golden Gate captures, filters, routes, verifies, transforms, and delivers transactional data in real-time, across Oracle and heterogeneous environments with very low impact and preserved transaction integrity.
Oracle Golden Gate 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).