Replicate data from Autonomous Transaction Processing to Amazon S3
Learn to replicate data from Autonomous Transaction Processing (ATP) to an Amazon S3 (Amazon Simple Storage Service) using OCI GoldenGate.
Before you begin
To successfully complete this quicktart, you must have the following:
- A source Autonomous Transaction Processing (ATP) instance
- Amazon S3 Service
- Amazon S3 Access Key & Secret
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 Amazon S3.
- Create a connection for the source Autonomous Transaction Processing instance.
- Create a connection to the target Amazon S3.
- (Optional) If your Big Data deployment doesn't have a public endpoint, then create a connection to GoldenGate pointing to private end point of Big Data deployment, and then assign this connection to the source Oracle deployment.
- Assign the Autonomous Transaction Processing connection to the source Oracle deployment.
- Assign the Amazon S3 connection to the target Big Data deployment.
Task 2: Create 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 Transacton information.
- Add an Extract.
Replicate data from Autonomous Transaction Processing to Amazon S3
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.