Replicate data from HeatWave to Autonomous Data Warehouse
Before you begin
To successfully complete this quicktart, you must have the following:
- OCI Bastion, to connect to HeatWave, load the sample database, and perform inserts
- A HeatWave to serve as the source database
- An Autonomous Data Warehouse instance to serve as the target database
Task 1: Create the OCI GoldenGate resources
This quickstart example requires deployments and connections for both
the source and target.
- Create a deployment for the source HeatWave database.
- Create a deployment for the target Autonomous Data Warehouse.
- Create a connection to the source MySQL Heatwave database.
- Create connection for the target Autonomous Data Warehouse.
- (Optional) If your Oracle deployment doesn't have a public endpoint, then create a connection to GoldenGate, and then assign this connection to the source MySQL deployment.
- Assign the source connection to the source MySQL deployment.
- Assign the target connection to the target Oracle deployment.
Task 5: Verify the initial load
The output should return the data that was loaded into the target database tables as
a result of the Initial Load.
Task 6: Create a Distribution Path for Change Data Capture
- In the source MySQL deployment console, click Distribution Service.
- Click Add Path.
- Complete the following fields, and then click Create and
Run:
- For Path Name, enter a name.
- For Source Extract, select the Change Data
Capture Extract (
CDCEXT)
. - For Trail Name, select the Change Data Capture
Extract trail file (
C1
) - For Target Authentication Method, select UserID Alias.
- For Target, select wss.
- For Target Host, enter the target OCI GoldenGate deployment console URL, without the https:// or any trailing slashes.
- For Port Number, enter
443
. - For Trail Name, enter C1.
- For Domain, enter the domain name created in task 3.
- For Alias, enter the alias created in task 3.
- In the target OCI GoldenGate deployment console, click Receiver Service, and then review the Receiver path created.
Task 7: Add a Replicat for Change Data Capture
- Add a Replicat.
- On the Administration Service Overview page, select the Replicat for Initial Load (RIL) and view its Details.
- Click Statistics and review the number of Inserts.
Refresh the page.
- If the number of Inserts doesn't change, then all the records from the Initial Load have been loaded and you can stop the Replicat (RIL)
- If the number of Inserts continues to increase, then keep refreshing the page until the Initial Load records are all loaded before continuing.
- Return to the Administration Service Overview page and then start the Replicat for Change Data Capture (RCDC).
- After starting the Replicat for Change Data Capture, review its Details and Statistics to view the number of Inserts.
Replicate data from HeatWave to Autonomous Data Warehouse
Copyright ©2022,
Oracle and/or its affiliates.
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 customer access to and use of Oracle support services will be pursuant to the terms and conditions specified in their Oracle order for the applicable services.