Data Integration With Oracle GoldenGate

Aug 10, 2023

What Can Oracle GoldenGate do for You?

At BLUEPRINT 4D 2023, in Dallas, Oracle’s Alexandre Lima shared how Oracle’s product, GoldenGate, can help manage data integration, availability, and migrations across multiple platforms.

What’s the Business Case for Using GoldenGate?

There are three main business cases for which GoldenGate customers can use the product:

GoldenGate can empower business continuity. With 99.999% data availability, there’s no downtime during migrations for most customers. If zero downtime is impossible, GoldenGate will diminish the downtime considerably.
Customers leverage GoldenGate for continuous integration between sites, partners, vendors, or within their organization. This is advantageous from ground to cloud to multi-cloud environments and applies event-based data integration.
GoldenGate can deliver timely insights. Customers can stream analytics via the real-time data warehouse, data lake, and data lakehouse.

History of GoldenGate

Oracle acquired GoldenGate in 2009. After acquiring the application, Oracle invested heavily in improving GoldenGate. This has made the GoldenGate family of products reliable, consistent, secure, and fast-moving.

There is an integration layer that includes GoldenGate OnPrem, GoldenGate Big Data, GoldenGate Stream Analytics, and GoldenGate SaaS. At the governance layer, you’ll find GoldenGate OEM Plug-in, GoldenGate Veridata, and GoldenGate Studio, or the GoldenGate Foundation Suite.

Oracle GoldenGate is the any-cloud solution for data with options for decentralized multi-vendor, decentralized single-vendor, partly decentralized/partly converged, and centralized converged. It was built with a cloud mindset.

You can use GoldenGate to empower modern data architecture. GoldenGate does not replicate applications, but it does replicate data. It supports the application as long as it supports the data underneath the application.

GoldenGate has moved from a classic architecture to a monolithic architecture. In the classic architecture, it was command-line only, had no remote connection, and limited security to the OS user. Additional challenges existed such as in-transit security not being available, complex automation, and monitoring.

This was not practical moving forward, especially in the multi-cloud world. Therefore, GoldenGate moved to microservices by de-supporting classic features. Next, classic architecture is de-supported in 23c. It will not ship with 23c.

While the de-support may not be well-received by all customers, GoldenGate Microservices is the strategic direction. Under the GoldenGate Microservices Architecture, microservices are fully encapsulated with C-based services, and no additional app service or database is required.

Data integration works with Microservices (with a local HUB). You have the option to run Golden Gate as a Mesh or as a Hub.

Mesh is suitable for large enterprises and multi-cloud. It distributes events between Microservices with GoldenGate Distribution Services (paths).

The advantage of Hub is that you don’t have to maintain as much. It’s suitable for single projects and single org ownership. This consolidates all GoldenGate runtimes to a single host and can work for most combinations of sources and targets.

In terms of Microservices Admin Client, there are important architecture distinctions. It does employ the same commands as ggsci, however, and the learning curve is very easy. Every call is a REST call.

Additionally, GoldenGate deployments are secure, and the services are compatible with reverse proxy services. This was based on customer requests.

GoldenGate with Microservices is ready for you to tackle multi-cloud distribution databases. From a survey, 98% of enterprises either use or plan to use multi-cloud. They are not staying on OCI or Azure. They’re going multi-cloud. GoldenGate already serves customers who are multi-cloud.

With GoldenGate, you get the max availability for Oracle Database. An Oracle strength, GoldenGate powers thousands of mission-critical, globally distributed applications with zero data loss and extreme high availability requirements. It’s crucial for systems that can never go down.