GoldenGate Replication Overview
GoldenGate Replication provides the ability to establish one-way, initial, and ongoing change-based (CDC) 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 Oracle Cloud Infrastructure GoldenGate for more information about Oracle GoldenGate.
Customers must supply the following information to use GoldenGate Replication:
- A source application environment. This is your Oracle Utilities cloud service.
- A Target Tenancy OCID. See Obtaining Tenancy Information for more information.
- A Target Compartment OCID. See Setting Up Compartments and Security Policies for more information.
- A Target VCN OCID. See Setting up Virtual Cloud Networks and Subnetsfor more information.
- A Target Subnet OCID. See Setting up Virtual Cloud Networks and Subnets for more information.
In addition, the customer must also
- Confirm that Identity and Access Management (IAM) policies exist which allow Oracle access to the compartment to create a Private Endpoint (PE).
- Confirm that an Ingress Security Rule to allow Trail Files to enter customer tenancy has been set up. See Setting up Virtual Cloud Networks and Subnets for more information.
- Confirm that the Source environment will not be used for any additional data conversion, factory reset, or clone/data copy (such as where data is copied/ cloned into the Source environment) activities while GoldenGate Replication is active.