Replicate Data from HeatWave on OCI to Amazon Kinesis
Learn how to use OCI GoldenGate to replicate data from HeatWave on OCI to Amazon Kinesis.
Before you begin
To successfully complete this quicktart, you must have:
- OCI Bastion, to connect to HeatWave on OCI, load the sample database, and perform inserts.
- A HeatWave on OCI database to serve as the source database.
- Amazon S3 Access Key & Secret
- IAM Policies for Amazon Kinesis
Task 1: Create the OCI GoldenGate resources
- Create a MySQL deployment for the source HeatWave on OCI database.
- Create a Big Data deployment for Amazon Kinesis target.
- Create a connection to the source Heatwave Database.
- Connect to Amazon Kinesis.
- 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 Big Data deployment.
Task 3: Create the Distribution Path to target Big Data deployment
- If using IAM credential store, proceed Step 3. If using GoldenGate credential
store, create a user with which the source GoldenGate uses to connect to the
target GoldenGate.
- In the source MySQL deployment console, create a Path
Connection for the user created in the previous step.
- In the source MySQL deployment consolek add a Distribution
Path with the following values:
- In the target OCI GoldenGate Big Data deployment console, review the Receiver path created as a result of the Distribution Path:
- Click Receiver Service.
- Review the Receiver path details.