Announcing OCI GoldenGate on Oracle Database@Google Cloud

September 10, 2024 | 3 minute read
Nick Wagner
Senior Director, Product Management, Oracle
Text Size 100%:

Announcing OCI GoldenGate on Oracle Database@Google Cloud

We are pleased to announce that Oracle Cloud Infrastructure (OCI) GoldenGate will join Oracle Exadata and Oracle Autonomous Database as part of the Oracle Database@Google Cloud partnership, allowing customers to provision a managed OCI GoldenGate service from within the Google Cloud console.  

OCI GoldenGate as part of Oracle Database@Google Cloud

Figure 1:  OCI GoldenGate on Oracle Database@Google Cloud Summary

 

OCI GoldenGate Use Cases

OCI GoldenGate is a fully managed service and part of the Oracle GoldenGate product family, delivering real-time trusted information across Oracle and non-Oracle data stores. For over 20 years, the GoldenGate platform has exceled low impact, change data capture (CDC), transactional data replication, high-speed data ingestion, data pipelines for continuous transformation and loading (CTL), and a wide variety of analytics on streaming data. With trusted, real-time, fault tolerant data replication, the data replicated by GoldenGate is continuously available ‘as-it-happens’ enabling better decisions, responsive applications, and more flexible architectures.

OCI GoldenGate is the cornerstone of data movement needed to create data fabrics and mesh architectures. OCI GoldenGate can be used to offload reporting to secondary systems to reduce the overhead of ad-hoc reporting on and/or ETL from, production OLTP databases, to increase database scalability and availability through active-active replications, and to reduce downtime for planned and unplanned database events.

OCI GoldenGate Use Cases

Figure 2:  GoldenGate’s diverse use cases

 

OCI GoldenGate Connectivity to Google Cloud

OCI GoldenGate in Oracle Database@Google Cloud will have feature parity with OCI GoldenGate running natively in OCI, and will have the same connectors for hundreds of data sources and targets including Google Cloud native services, and 3rd party software running on Google Cloud.

  • Google Cloud native services such as Google Cloud SQL, Google Pub/Sub, Google Cloud Storage, Google BigQuery, and Google AlloyDB
  • 3rd party technologies running on Google Cloud such as Snowflake, Databricks, and Confluent Kafka

As part of this partnership, we plan on certifying GoldenGate with Google Cloud Spanner for both capture and delivery, and augmenting GoldenGate’s existing delivery to Google BigQuery with the ability to capture from it.

 

OCI GoldenGate integration with Google Cloud native services

Figure 3:  GoldenGate integration with Google Cloud native services

 

OCI GoldenGate Hybrid and Multicloud Connectivity 

OCI GoldenGate is seamlessly integrated with on-premises Oracle GoldenGate environments for hybrid deployments to replicate between on-premises environments and the cloud.  OCI GoldenGate in Google Cloud will also connect with GoldenGate running in Azure, Amazon Web Services (AWS), and in the Oracle Cloud for replication across cloud vendors enabling multi-cloud architectures.

GoldenGate data sources and targets

Figure 4:  Overview of GoldenGate’s comprehensive connections

 

Summary 

Many Google Cloud customers already use OCI GoldenGate for low-impact, optimized capture from any source database, but especially those from Oracle.  In conjunction with real-time/transactional feeds to Google Cloud based targets, the planned availability of OCI GoldenGate as part of Oracle Database@Google Cloud will enable even more integrated, high performance and real-time workloads, spanning OCI and Google Cloud for OLTP and analytics systems. 

Want to learn more?

 

 

 

Nick Wagner

Senior Director, Product Management, Oracle

Nick Wagner is a Senior Director of Product Management at Oracle. He was one of the original Oracle GoldenGate product managers, and has been working with database replication technologies since the late 1990s. Nick has deep knowledge on Oracle’s Maximum Availability Architecture helping customers build 24/7 mission-critical systems.

Show more

Previous Post

How to connect to GoldenGate with IDCS Federation using adminclient

Adriano Tanaka | 3 min read

Next Post


A Step-by-Step Guide to Setting Up GoldenGate DAA 23ai for MongoDB and Oracle JSON Database Integration

Carmelo Millan Rosales | 6 min read