GoldenGate
Oracle Cloud Infrastructure (OCI) GoldenGate is a managed service providing a real-time data mesh platform, which uses replication to keep data highly available, and enabling real-time analysis. Customers can design, execute, and monitor their data replication and stream data processing solutions without the need to allocate or manage compute environments.
Watch the video (27:14)
The latest release of Oracle GoldenGate brings extreme performance with simplified configuration and management, tighter integration with Oracle Database, and enhanced security.
Learn about the usefulness of a Data Mesh to create Data Products implemented with Oracle GoldenGate, Oracle Stream Analytics, and Apache Kafka.
Explore the principles, use cases, and examples of Oracle customers deploying a data mesh.
Wikibon believes that the close integration of GoldenGate with OCI significantly changes the skill and time required to set up and maintain these environments. Wikibon believes this integration is a gamechanger and expands its potential use to enterprises of any size.
Oracle GoldenGate features
GoldenGate as a cloud service on OCI
Reduce planned downtime
OCI GoldenGate is a real-time data mesh platform, providing a managed service allowing users to design, execute, orchestrate, and monitor their data replication and stream data processing solutions in the Oracle Cloud Infrastructure.
Database replication for Oracle Database
Faster data movement
GoldenGate connection to the Oracle Database kernel delivers high-speed data movement for the best performance.
Oracle Database optimized for GoldenGate.
Optimization reduces buffer latency for parallel writes to targets.
Database replication for non-Oracle databases
Range of sources and targets
Integrate data among Oracle and non-Oracle databases and data services, such as Microsoft SQL Server, IBM DB2, Teradata, MongoDB, MySQL, PostgreSQL, HDFS, Kafka, Spark, and cloud object stores across cloud providers.
Reliable data transfer
Provide transactional integrity with built-in conflict detection and resolution Deliver data securely with SSL and encryption.
High availability and scalability
Reduce planned downtime
Eliminate downtime during routine database maintenance and upgrades, operating system patches, application upgrades, and platform migrations. All operations are protected with failback capabilities, eliminating the risk of losing data.
Database scalability
Deploy in multi-master or active-active configurations to achieve database scalability or distributed synchronization. Any number of databases can originate transactions and then synchronize with all others for data consistency.
24/7 availability
Oracle Maximum Availability Architecture relies on Oracle GoldenGate to provide zero downtime for planned and unplanned outages and Oracle Active Data Guard to provide zero data loss at any distance.
Optimize server use
Allows for production utilization of live standby servers for high-performance reporting, ETL for operational data stores, and routine backups.
Support for non-Oracle databases
Reduce planned and unplanned downtime, while providing high availability and disaster recovery for non-Oracle platforms.
Integrate with big data
GoldenGate for big data
Integrate with technologies like Hadoop, HBase, Kafka, etc. Support NoSQL (MongoDB, Cassandra, and Oracle NoSQL).
Multi-cloud support
Capture data from AWS, Google Cloud, Oracle Cloud, and Azure.
Real-time streaming and analysis
Stream data and events
Capture CSV, JSON and Avro files in Kafka and JMS queues. Stream transactional data into Kafka, REST, Autonomous Database, or data lakes.
Integrates with Oracle Stream Analytics
Analyze, correlate and graphically analyze in-motion data. Gain actionable insights as soon as data is found.
Validate with Oracle GoldenGate Veridata
Data verification
Identify table records that are out-of-sync. Verify data consistency across heterogeneous databases.
Data fix
Compare and repair datasets to improve data quality.
Key capabilities
Graphical user experience
Easy-to-use graphical user experience enables administrators to securely configure, monitor, and manage operations from all major desktop browsers.
End-to-end monitoring
Ensure service level agreement commitments with data verification and visibility into extensive real-time performance and usage statistics across all sources and targets.
Extensive operational APIs
Use well-documented REST APIs to customize the administrative user experience, add operational controls into replication processes, and integrate with third-party tools.
Automatic scaling
Achieve optimal throughput regardless of workload variability with dynamic scalability and parallel transaction processing.
Inline transformation
Data replication processes allow for more than 50 built-in data manipulation functions for transformation and validation and stored procedure callouts for further inline data preparation for enrichment, analytics, and more.
Real-time data mesh
Uniquely designed to replicate Oracle and non-Oracle databases and data services across operating systems, endianness, character sets, and object structures. Supports every data movement topology and modern architecture pattern.
More integration solutions
Integrate with Oracle ETL
Works with Oracle Data Integrator. Keep data synchronized after performing an initial bulk load.
Integrates with Enterprise Data Quality
Cleanse and profile data for data warehouses and data lakes.
Monitor and manage
Automated monitoring
Visibility into replication status with real-time alerts. View status in a robust management console or engineer automated recovery using rich APIs.
Enterprise-wide visibility
Monitor replication process completion and performance using management dashboards and real-time notifications.
Integrates with Oracle Enterprise Manager
Monitor GoldenGate across the enterprise with centralized management and monitoring, improving productivity.
SailGP depends on real-time data movement and analytics to win the race
SailGP uses real-time race data and analytics to further the excitement of competitive sailing. From the water and in the air, real-time telemetry is delivered across a data mesh built with Oracle GoldenGate and Oracle Stream Analytics.
Gartner MQ Leader in Data Integration Tools
Oracle has once again, been named a Leader in the 2021 Gartner® Magic Quadrant™ for Data Integration Tools. This year Gartner says, “The data integration tools market is seeing renewed momentum driven by urgent requirements for hybrid/multi-cloud data management, augmented data integration and data fabric designs. This assessment of 18 vendors will help data and analytics leaders choose a best fit for their data integration needs.”
Read the complete postAnnouncements
- October 2021 Announcing GoldenGate for Big Data 21.3
- August 2021 Announcing Oracle GoldenGate 21c
- March 2021 Oracle GoldenGate Veridata 12.2.1.4.0 BP3 (12.2.1.4.210226) is now available for download. Read the release announcement.
- July 2020 Release announcement for Oracle GoldenGate Veridata 12.2.1.4.0 BP
GoldenGate pricing
GoldenGate
Product |
Comparison Price ( /vCPU)* |
Unit Price |
Unit |
Oracle Cloud Infrastructure - GoldenGate |
OCPU per hour |
||
Oracle Cloud Infrastructure - GoldenGate - BYOL |
OCPU per hour |
- *To make it easier to compare pricing across cloud service providers, Oracle web pages show both vCPU (virtual CPUs) prices and OCPU (Oracle CPU) prices for products with compute-based pricing. The products themselves, provisioning in the portal, billing, etc. continue to use OCPU (Oracle CPU) units. OCPUs represent physical CPU cores. Most CPU architectures, including x86, execute two threads per physical core, so 1 OCPU is the equivalent of 2 vCPUs for x86-based compute. The per-hour OCPU rate customers are billed at is therefore twice the vCPU price since they receive two vCPUs of compute power for each OCPU, unless it's a sub-core instance such as preemptible instances. Additional details supporting the difference between OCPU vs. vCPU can be accessed here.
GoldenGate solutions
-
GoldenGate Microservices
Read how GoldenGate Microservices can be used to simplify cloud deployments.
-
Integrate Big Data for ML and analytics
Ingest to targets like Hadoop, Kafka, JMS, NoSQL databases and Machine Learning.
-
GoldenGate for high availability
High availability cloud migration blueprints using GoldenGate and Maximum Availability Architecture.
-
Disaster Recovery
Read MAA blueprints to help reduce down-time for Exadata, Cloud database.
-
Real-time streaming analytics
Watch the Techtalks video about GoldenGate as a data streaming platform.
Resources
Certifications and licensing
Datasheets and technical briefs
- Dynamic Data Fabric and Trusted Data Mesh using GoldenGate (PDF)
- OCI Data Migration Service Technical Brief: On premises to ADB (PDF)
- Datasheet: Oracle GoldenGate 21c (PDF)
- Datasheet: OCI GoldenGate (PDF)
- Datasheet: Oracle GoldenGate 19c (PDF)
- Datasheet: Oracle GoldenGate Studio 12c (PDF)
- Datasheet: Oracle GoldenGate for Big Data (PDF)
- Datasheet: Oracle Management Pack for Oracle GoldenGate (PDF)
- Ensuring Data Consistency with Oracle GoldenGate Veridata (PDF)
- Oracle GoldenGate Statement of Direction (PDF)
- Transparent Role Transitions with Data Guard and GoldenGate (PDF)
- Best practices: Oracle Real Application Clusters Configuration (PDF)
- Best practices: Active-Active Configuration (PDF)
- Oracle Maximum Availability Architecture GoldenGate Hub (PDF)
Join a community of your peers
Classes and certification
Orchestrating microservices
Support and services
Related cloud products
Get started with GoldenGate
Watch an overview with demos
See the value of high-speed replication
Try Cloud Free Tier
Try Oracle Cloud—for free
Request a demo
Talk with Oracle and learn more
Use GoldenGate on Oracle Cloud
Move your data to the cloud