OCI GoldenGate Stream Analytics (OCI GGSA) allows users to model, process, analyze, and act on real-time streaming information by using sophisticated correlation patterns, time-series analytics, geo-spatial analysis, and machine learning. You can learn more and see a demonstration in this CloudWorld video presentation.
Timely analytics and insights have long been the decision-making objective, but day-end and period-end batch data transfers into analytic data stores have never been the sufficient answer. Stream Analytics offers a transformational payoff – analyze data events as fast as they arrive - whether for conventional business transactions or in-motion IoT events.
GoldenGate Stream Analytics is an integral part of the Oracle GoldenGate product family. It is available on premises, in the OCI Marketplace, and now as a native, fully managed OCI service.
OCI GGSA captures data from sources as the events happen. Then, after the analysis and action, it can archive, publish, and send the data along through your information architecture.
OCI GGSA can subscribe and publish to various event streams from OCI Streaming Service and Apache Kafka, in addition to a myriad of other open source, 3rd party, and Oracle technologies, such as AWS, Azure and Oracle object stores, HDFS, and MySQL.
OCI GGSA supports standards-based machine model descriptions ONNX, PMML and Oracle Machine Learning. These ML models can be called upon within event streams to make predictions and guide alternative paths in the pipeline, alert users and/ or take specific programmatic corrective actions.
As part of the OCI GoldenGate platform, OCI GGSA is easily provisioned, automatically maintained, and enabled for elastic scaling. Stream processing resources automatically scale up and down based on computational demand. OCI GGSA is integrated with related OCI services, such as OCI Streaming to ingest and propagate Kafka and other messages, OCI Notifications to send alerts through SMS, email, and other means, OCI Metering to measure system activity; it also shares configuration and connection information with other OCI GoldenGate deployments.
OCI GGSA can ingest data from multiple GoldenGate products whether on premises, in OCI, or in 3rd party clouds. GoldenGate can capture Oracle (Database, Exadata, Autonomous) and non-Oracle (PostgreSQL, MySQL, Db2 LUW, iSeries and mainframe, SQL Server, and others) database transactions to be processed as events in OCI GGSA.
In conversations with Amy Machado, Research Manager for Streaming Data Pipelines at IDC, she remarked, “OCI GoldenGate Stream Analytics is a powerful data-in-motion addition to the Oracle Cloud portfolio. While we hold the core on-premises capabilities (no-code pipeline building, continuous SQL analytical time-series and geo-spatial functions, and end user visualizations) in high regard, we are pleased to see that these have all been faithfully repurposed and improved in the corresponding fully-managed cloud service. With the continuously expanding number of heterogeneous supported sources and targets, OCI GoldenGate is positioning itself to become a real-time hybrid and multicloud enterprise data fabric.”
OCI GoldenGate Stream Analytics will be available in the 1st quarter of 2023, please contact us if you would like an early preview of this capability right now!
At Cloud World you can learn more
Learn more here:
Alex is Director of Product Management in the Database team and covers Database Migration, Streaming and Big Data products such as OCI Database Migration, Oracle Stream Analytics, and GoldenGate.