GoldenGate Replication Overview

GoldenGate Replication provides the ability to establish one-way, initial, and ongoing change-based (Change Data Capture) replication of data from an Oracle Energy and Water Software-as-a-Service (SaaS) cloud service environment (for example, a Customer Cloud Service Production environment) to an OCI hosted Autonomous Database Autonomous Transaction Processing (ATP) target environment (owned and managed by the customer) via a Named Distribution Path.

This provides you with full and direct access to all SaaS data replicated to the target Autonomous Database ATP database instance, and enables you to query, report on, and develop data-driven integrations based on your cloud service data in the target database. It also allows for retention of data that is useful for reporting and integration purposes, even if the data is removed from the source cloud service database via ILM processes such as partition drops.

Refer to the Oracle Cloud Infrastructure GoldenGate and Oracle GoldenGate documentation for more information.

Refer to the GoldenGate Replication chapter of the Oracle Utilities Cloud Services Administration Guide for more information, including requirements, prerequisites, and instructions for administration tasks used with GoldenGate Replication.