GoldenGate

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.

• Read GoldenGate advantages (PDF)
• Available sources and 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.

• Available sources and targets

Reliable data transfer

Provide transactional integrity with built-in conflict detection and resolution Deliver data securely with SSL and encryption.

Integrate with big data

GoldenGate for big data

Integrate with technologies like Hadoop, HBase, Kafka, etc. Support NoSQL (MongoDB, Cassandra, and Oracle NoSQL).

• Available sources and targets

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.

• Available sources and targets

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.

• Learn more about Data Mesh

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.