Analyze data in motion with OCI GoldenGate Stream Analytics

September 19, 2023 | 3 minute read
Text Size 100%:

OGG CloudWorld Banner

Oracle Cloud Infrastructure (OCI) GoldenGate is a fully managed service providing a unified real-time data replication, transformation, and analysis platform. In addition to adding support for the new Data Transforms deployment type, we are also releasing the Stream Analytics deployment in limited availability in several OCI regions (San Jose, Chicago, Toronto, Montreal)!

OCI GoldenGate Stream Analytics (OCI GG SA) allows users to model, process, analyze, and act on real-time streaming information using sophisticated correlation patterns, time-series analytics, geospatial analysis, and machine learning. With OCI GG SA, businesses can make informed decisions with timely and accurate insights into their data.

OCI GoldenGate Stream Analytics

OCI GoldenGate Stream Analytics is fully integrated with OCI GoldenGate, enabling developers to process and analyze data streams coming from any of the technologies supported by OCI GoldenGate (Oracle, MySQL, Microsoft SQL Server, PostgreSQL, Kafka, OCI Streaming, Azure Event Hub, MongoDB, and more).

Key Features

OCI GoldenGate Stream Analytics offers the following key capabilities:

  • No-code environment to design continuous ETL and analytics workflows with an interactive pipeline designer. Developers can instantly validate their work with live results displayed within a data-immersive user experience.
  • Rich set of built-in transformations, including a pattern library for advanced data transformation and real-time analytics with patterns for detecting CEP data patterns, including event sequence, geospatial (distance, speed, proximity), financial trend, anomaly detection, missing and duplicate events.
  • Predictive analytics based on a wide selection of Artificial Intelligence (AI) models and integration with industry-standard Open Neural Network Exchange (ONNX), Predictive Model Markup Language (PMML), and Oracle Machine Learning (OML) models. These models are used to predict events based on data streams and act on them.
  • Simple provisioning and configuration with the automation of various maintenance activities, such as setting up pipelines for high availability, managing Spark environment for parallel in-memory processing, elastic scaling, or storage optimizations for log management.
  • Import existing Stream Analytics pipelines and dashboards to preserve your prior investments while reducing your total cost of ownership with a fully managed service.

Use Cases

By analyzing data streams in real-time, OCI GoldenGate Stream Analytics can be used in a variety of use cases, including:

  • Real-time fraud detection: Identify and prevent fraudulent activities before they occur.
  • Customer experience management: Improve customer experience by providing real-time insights into customer behavior and preferences.
  • Product performance monitoring: Detect and address issues before they impact the customer experience.
  • Financial forecasting: Make more accurate economic forecasts by providing real-time insights into financial data.


OCI GoldenGate Stream Analytics is designed to work with various data sources, including structured and unstructured data, and can easily handle large volumes of data. In addition to all the technologies supported by the core GoldenGate functionality, OCI GG SA can also directly connect to the following technologies, whether on-premises, in OCI, or 3rd party clouds:

  • Oracle GoldenGate (Source/Target)
  • Relational Databases
    • Oracle Autonomous Transaction Processing (Source/Target)
    • Oracle Autonomous Data Warehouse (Source/Target)
    • Oracle Database (Source/Target)
    • MySQL Database Server (Source/Target)
  • NoSQL Databases
    • MongoDB (Target only)
    • Apache Ignite (Source/Target)
  • Streaming
    • OCI Streaming (Source/Target)
    • Apache Kafka (Source/Target)
    • Confluent Kafka (Source/Target)
    • Java Message Service (JMS) (Source/Target)
  • Cloud Storage
    • OCI Object Storage (Target only)
    • Amazon S3 (Target only)
    • Azure Data Lake Storage (Target only)
  • Coherence (Source/Target)
  • Hadoop File Storage (HDFS) (Target only)

You can connect to Oracle Cloud Infrastructure and start using OCI GoldenGate today with the Stream Analytics deployment type. I recommend going through some of our Workshops to familiarize yourself with the service and its capabilities.

More resources:


Julien Testut is a Senior Principal Product Manager in the Oracle GoldenGate group focusing on OCI GoldenGate and GoldenGate for Big Data. He previously led product management activities for OCI Data Integration, Data Integration Platform Cloud (DIPC), Oracle Data Integrator (ODI), and ODI Cloud Service. Julien has an extensive background in Cloud, Big Data, Data Integration, Data Quality, and Data Governance solutions. He is also a co-author of the 'Getting Started with Oracle Data Integrator: A Hands-on Tutorial' and 'Oracle Data Integrator Cookbook' books. Before joining Oracle, he was an Applications Engineer at Sunopsis, which Oracle then acquired.

Previous Post

OCI GoldenGate adds support for Google Cloud Storage, Amazon Kinesis, SingleStore, Redis, and more

Julien TESTUT | 2 min read

Next Post

Oracle GoldenGate Free 23c with Oracle Database 23c

Shrinidhi Kulkarni | 14 min read