About Oracle Cloud Infrastructure GoldenGate

Learn about data replication concepts to help you get started with Oracle Cloud Infrastructure GoldenGate.

Oracle Cloud Infrastructure GoldenGate is a fully managed, native cloud service that moves data in real-time, at scale. OCI GoldenGate processes data as it moves from one or more data management systems to target databases. You can also design, run, orchestrate, and monitor data replication tasks without having to allocate or manage any compute environments.

Watch a short overview video, or take an interactive service tour to learn more.

OCI GoldenGate concepts

The following concepts are essential for working with the Oracle Cloud Infrastructure GoldenGate service.

  • Compartment: Organizes and isolates your cloud resources, such as cloud networks, compute instances, block volumes, or OCI GoldenGate deployments, and database registrations. Only users with permission to a compartment can work with the resources within that compartment. Compartments also serve as a security boundary inside OCI GoldenGate. Only deployments and database registrations within the same compartment can access each other.
  • Connection: Contains the network connectivity details for a data source or target for OCI GoldenGate. Connections support database and non-database technologies such as Oracle, MySQL, Apache Kafka, OCI Object Storage, OCI Streaming, and Oracle GoldenGate Distribution and Receiver servers.
  • Deployment: A container for your OCI GoldenGate resources, such as the OCI GoldenGate Deployment Console.
  • Deployment type: Represents a specific replication scenario.
  • Deployment Backup: A backup of a deployment's current state, retained for 60 days. It can be used to restore a deployment or create a new deployment with the state of the original deployment at the time the backup was taken.
  • Extract: A process that runs against the source database and extracts, or captures data.
  • Trail: A series of files on the source, intermediary, and/or target system where Oracle GoldenGate stores the captured changes to support the continuous extraction and replication of database changes.
  • Replicat: A process that delivers data to a target database. It reads the trail file on the target database, reconstructs the DML or DDL operations, and applies them to the target database.

For more information about Oracle GoldenGate concepts, see Components of the Oracle GoldenGate Microservices Architecture.

OCI GoldenGate connectivity

Discover how OCI GoldenGate connects with other services and technologies.

By default, all network connectivity to OCI GoldenGate is encrypted over SSL. The following network diagram illustrates how traffic is routed through specific ports, depending on the service or technology OCI GoldenGate is connecting to.

For example, you can access an OCI GoldenGate deployment through its deployment console. Connectivity to the deployment console is done over HTTPS through port 443. OCI GoldenGate connects to Oracle Databases using the default ports 1521 or 1522, and MySQL databases using default port 3306. For Big Data targets, OCI GoldenGate connects using port 443. You can also create private endpoints when needed to access private resources.

Description of ggs-network-diagram.png follows
Description of the illustration ggs-network-diagram.png

User roles

Service administrators, Application DBAs, and Data engineers are among the types of data professionals who use OCI GoldenGate. You may perform one or more of the following roles:

  • Service administrators are responsible for the administration, management, monitoring, diagnostics, lifecycle management, and security for OCI GoldenGate.
  • Application DBAs use OCI GoldenGate to develop, build, and test solutions focused on high availability, transaction replication, and data warehouse loading.
  • Data engineers use OCI GoldenGate to develop, build, and test solutions focused on data lake pipelines and stream processing.