Simply put, Oracle GoldenGate allows data exchange and manipulation between heterogeneous data sources such as Oracle, Sybase, SQL Server, and DB2 at a transaction level. Oracle GoldenGate facilitates replication of transactional data, changes to table/index definitions through DDL (Data Definition Language) across many databases by providing a low-latency high-performance modular solution.
Typical business requirements supported by Oracle GoldenGate, including data integration, are:
High availability solution for databases
Initial data load and migration between different databases
ETL functionality in a data warehousing/reporting environment
Oracle GoldenGate supports many deployment topologies such as peer-to-peer, unidirectional, bidirectional, broadcast, cascading, and so on. A graphical image of the supported topologies by Oracle GoldenGate is shown in the following screenshot:
Oracle GoldenGate is comprised of seven modular, lightweight, loosely coupled components...