Stage and merge data into Autonomous Data Warehouse using OCI GoldenGate
This quickstart guides you on how to stage and merge data from Autonomous Transaction Processing to Autonomous Data Warehouse using an OCI GoldenGate Big Data deployment.
Before you begin
You must have the following in order to proceed:
- An existing source database.
- An existing target Autonomous Database.
- An existing OCI Object Storage Bucket which will be used as a temporary staging area.
- Before configuring ADW Stage & Merge replication, target schemas and tables should be created in the target ADW instance.
- You can download Archive.zip and follow Task 0 to set up source and target databases using Autonomous Database.
Task 0: Set up the source & target Autonomous Databases
- Download and unzip the sample database schema.
- Set up the source Autonomous Database:
- Set up the target Autonomous Data Warehouse:
- In the Oracle Cloud console, select your ADW instance from the Autonomous Databases page to view its details and access DB tools.
- Click Database Actions.
- In the Database Actions menu, under Development, select SQL.
- Copy and paste the script from previously downloaded
OCIGGLL_OCIGGS_SETUP_USERS_ADW.sql
into the SQL worksheet. - Click Run Script. The Script Output tab displays confirmation messages.
- Clear the SQL worksheet and then copy and paste the SQL script from
OCIGGLL_OCIGGS_SRC_MIRROR_USER_SEED_DATA.sql
- Click Run Script.
Task 1: Create OCI GoldenGate resources
- Create an Oracle deployment for the source Autonomous Transaction Processing instance.
- Create a Big Data deployment for the target Autonomous Data Warehouse.
- Create a connection for the source Autonomous Transaction Processing instance.
- Create a connection for the target Autonomous Data Warehouse instance.
- Create connection for 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 ATP connection to the source Oracle deployment.
- Assign the ADW connection the target Big Data 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.
Stage and merge data into Autonomous Data Warehouse using OCI GoldenGate
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.