Golden Gate Basics

Oracle GoldenGate enables the exchange and manipulation of data at the transaction level among multiple, heterogeneous platforms across the enterprise1. Its modular architecture gives you the flexibility to extract and replicate selected data records, transactional changes, and changes to DDL (data definition language2) across a variety of topologies.

With this flexibility, and the filtering, transformation, and custom processing features of Oracle GoldenGate, you can support numerous business requirements:

·         Business continuance and high availability.

·         Initial load and database migration.

·         Data integration.

·         Decision support and data warehousing.

·         Support for replication across different database types and topology varies by database type.

·         DDL is not supported for all databases