Replicate data to Stream analytics
Learn to replicate data from OCI GoldenGate into Stream Analytics.
GoldenGate Stream Analytics began as a Complex Event Processing engine that evolved to run atop of runtime frameworks with Apache Spark and Apache Kafka. Stream Analytics can ingest a stream of data from any source such as a database, GoldenGate, Kafka, JMS, REST, or even a file system file. After the data is ingested, you can run analytics on live data.
Before you begin
To successfully complete this quickstart you need:
- A source Autonomous Database with sample data loaded, and supplemental
logging enabled.
Tip:
You can download the OCI GoldenGate sample data, if you need sample data to work with.- First, edit
SETUP_USERS_ATP.sql
and modify theSRC_OCIGGLL
user's password to remove the special characters. - Use the Autonomous Database's Database actions SQL tool to run the two scripts to create the user schema and tables.
- Use the SQL tool to enable supplemental logging.
- First, edit
- Unlock the GGADMIN user on the source Autonomous Database instance
- On the Autonomous Database Details page, select
Database Users from the
Database actions menu.
Tip:
Use the Autonomous Database administrator credentials provided when you created the instance to log in, if prompted. - Locate the GGADMIN user, and then select Edit from its ellipsis (three dots) menu.
- In the Edit User panel, enter a password, confirm that password, and then deselect Account is Locked.
- Click Apply Changes.
- On the Autonomous Database Details page, select
Database Users from the
Database actions menu.
Task 1: Create the OCI GoldenGate resources
- Create the OCI GoldenGate deployment for Data replication.
- Create a connection for the source database.
- Assign the connection to the deployment.
- Create and run an Extract.
Task 2: Create the Stream Analytics resources
- Create the Stream Analytics deployment.
- Create a Kafka connection using the Kafka instance's public IP, and select Plaintext for Security protocol.
- Create a GoldenGate connection.
- Assign the connections to the Stream Analytics deployment.
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.