Replicate data from MySQL Heatwave to Amazon Kinesis
Before you begin
To successfully complete this quicktart, you must have the following:
- OCI Bastion, to connect to MySQL Heatwave Database, load the sample database, and perform inserts.
- A MySQL Heatwave 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 MySQL Heatwave database.
- Create a Big Data deployment for Amazon Kinesis target.
- Create a connection to the source MySQL 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 4: Add a Replicat for Amazon Kinesis
- Add a Replicat:
- In Big Data deployment click Administrator Service, and then click Add Replicat (plus icon).
- Select Classic Replicat and then click Next.
- On the Replicat Options page, complete the following fields, and then click
Next:
- For Process Name, enter a name.
- For Trail Name, enter the name of the Trail from Task 2.
- For Target, select Amazon Kinesis.
- For Alias, select the Amazon Kinesis connection created in Task 1.
- On the Replicat Parameters page, leave the default, and then click Next.
- On the Properties page, edit the fields marked
#TODO
.gg.handler.kinesis.region
: provide the Amazon Web Services (AWS) region for the target Kinesis stream.gg.handler.kinesis.streamMappingTemplate
: by default, it is set to${tableName}
which will map the streams based on source table name. If you want to map to an existing data stream, you can provide static stream names or you can use Template Keywords to assign stream names dynamically.
- Click Create and Run.
Replicate data from MySQL Heatwave to Amazon Kinesis
Copyright ©2023,2024,
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 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.