Replicate data from HeatWave to Amazon Kinesis
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.
- 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 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 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.
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.