Replicate data from Autonomous Transaction Processing to OCI Object Storage
This quickstart example demonstrates how to replicate data from Autonomous Transaction Processing to OCI Object Storage using OCI GoldenGate.
This quickstart is also available as a LiveLab workshop. View the workshop.
Before you begin
To successfully complete this quickstart, you must have the following:
- An API key created and downloaded from the user details page
- A source Autonomous Transaction Processing instance
- Your compartment OCID
Environment set up: Autonomous Transaction Processing
To set up the source Autonomous Database:
- Download and unzip the sample database schema.
- In the Oracle Cloud console, select your Autonomous Transaction Processing (ATP) instance from the Autonomous Databases page to view its details and access Database Actions.
- Unlock the GGADMIN user:
- Click Database actions, then click Database Users.
- Locate GGADMIN and then click its ellipsis menu (three dots) and select Edit.
- In the Edit User panel, enter the GGADMIN password, confirm the password, and then deselect Account is Locked.
- Click Apply Changes.
- Load the source sample schema and data:
- Enable supplemental logging:
Task 1: Create the OCI GoldenGate resources
- Create an Oracle deployment for the source Autonomous Transaction Processing instance.
- Create a Big Data deployment for the target OCI Object Storage bucket.
- Create a connection for the source Autonomous Transaction Processing instance.
- Create connection for the target OCI Object Storage.
- (Optional) If your Big Data deployment doesn't have a public endpoint, then create a connection to GoldenGate, and then assign this connection to the source Oracle deployment.
- Assign the Autonomous Transaction Processing connection to the source Oracle deployment.
- Assign the OCI Object Storage connection to the target Big Data deployment.
Task 2: Add the Extract
- On the Deployments page, select the source Autonomous Transaction Processing deployment.
- On the deployment details page, click Launch Console.
- Log in with the source deployment's administrator username and password.
- Add transaction information.
- Add an Extract
Replicate data from Autonomous Transaction Processing to OCI Object Storage
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.