Example OCI GoldenGate topologies

Before you create your OCI GoldenGate deployments, review these sample topologies to help you plan for the number of resources your solution needs.

Related Topics

How many resources do I need?

Deployments

To determine how many deployments your solution needs, consider the types of technologies you're replicating data between.

For example, if your source and target databases are Oracle Autonomous Databases, then you need only one Oracle deployment type.

Description of atp-adw.png follows
Description of the illustration atp-adw.png

See Replicate data between cloud databases in the same region.

If you're replicating data between two different technologies, then you need two OCI GoldenGate deployments. For example, if your source database is a MySQL database type, and your target is a Big Data type, then you must:
  • Create a MySQL deployment for your MySQL source
  • Create a Big Data deployment for your Big Data target
This solution also requires a Distribution Path. See the following examples for details.

Connections

You must create a connection for each source and target technology, and then assign the connections to the appropriate deployment. Using the MySQL to Big Data example above, you must:
  • Create a connection to your source MySQL database, and then assign it to the MySQL deployment
  • Create a connection to your target Big Data technology, and then assign it to the Big Data deployment

Note:

If your target deployment doesn't have a public endpoint, then you must also create a GoldenGate connection, and then assign this connection to the source deployment.

Example: Azure SQL Managed Instance to Autonomous Transaction Processing

In this example, Azure SQL Managed Instance is the source technology and Autonomous Transaction Processing (ATP) is the target.

Description of azure-atp.png follows
Description of the illustration azure-atp.png

For this replication scenario, you need:

  • Two deployments:
    • A Microsoft SQL Server deployment for the source database
    • An Oracle deployment for the target database
  • Connections:
    • A connection to Azure SQL Managed Instance, and then assigned to the Microsoft SQL Server deployment
    • A connection to Autonomous Transaction Processing, and then assigned to the Oracle deployment
    • If your target deployment doesn't have a public endpoint, create an Oracle GoldenGate connection and then assign it to the source deployment.
  • Processes:
    • An Extract process created in the source deployment
    • A Distribution Path created in the source deployment
    • A Replicat created in the target deployment

This replication scenario is available as quickstart.

Example: Autonomous Transaction Processing to Apache Kafka

In this example, Autonomous Transaction Processing (ATP) is the source technology and Apache Kafka is the target.

Description of atp-kafka.png follows
Description of the illustration atp-kafka.png

For this replication scenario, you need:

  • Two deployments:
    • An Oracle deployment for the source database
    • A Big Data deployment for the target technology
  • Connections:
    • A connection to Autonomous Transaction Processing, and then assigned to the Oracle deployment
    • A connection to Apache Kafka, and then assigned to the Big Data deployment
    • If your target deployment doesn't have a public endpoint, create an Oracle GoldenGate connection and then assign it to the source deployment.
  • Processes:
    • An Extract process created in the source deployment
    • A Distribution Path created in the source deployment
    • A Replicat created in the target deployment

This replication scenario is available as a quickstart.

Example: PostgreSQL to Autonomous Transaction Processing

In this example, PostgreSQL is the source technology and Autonomous Transaction Processing (ATP) is the target.

Description of postgres-atp.png follows
Description of the illustration postgres-atp.png

For this replication scenario, you need:

  • Two deployments:
    • A PostgresSQL deployment for the source database
    • An Oracle deployment for the target technology
  • Connections:
    • A connection to PostgreSQL, and then assigned to the PostgreSQL deployment
    • A connection to Autonomous Transaction Processing, and then assigned to the Oracle deployment
    • If your target deployment doesn't have a public endpoint, create an Oracle GoldenGate connection and then assign it to the source deployment.
  • Processes:
    • An Extract process created in the source deployment
    • A Distribution Path created in the source deployment
    • A Replicat created in the target deployment

This replication scenario is available as a quickstart.

Example: PostgreSQL to MySQL

In this example, PostgreSQL is the source technology and MySQL is the target.

Description of postgres-mysql.png follows
Description of the illustration postgres-mysql.png

For this replication scenario, you need:

  • Two deployments:
    • A PostgresSQL deployment for the source database
    • A MySQL deployment for the target technology
  • Connections:
    • A connection to PostgreSQL, and then assigned to the PostgreSQL deployment
    • A connection to MySQL, and then assigned to the MySQL deployment
    • If your target deployment doesn't have a public endpoint, create an Oracle GoldenGate connection and then assign it to the source deployment.
  • Processes:
    • An Extract process created in the source deployment
    • A Distribution Path created in the source deployment
    • A Replicat created in the target deployment

This replication scenario is available as a quickstart.

PostgreSQL to Snowflake

In this example, PostgreSQL is the source technology and Snowflake is the target.

Description of postgres-snowflake.png follows
Description of the illustration postgres-snowflake.png

For this replication scenario, you need:

  • Two deployments:
    • A PostgresSQL deployment for the source database
    • A Big Data deployment for the target technology
  • Connections:
    • A connection to PostgreSQL, and then assigned to the PostgreSQL deployment
    • A connection to Snowflake, and then assigned to the Big Data deployment
    • If your target deployment doesn't have a public endpoint, create an Oracle GoldenGate connection and then assign it to the source deployment.
  • Processes:
    • An Extract process created in the source deployment
    • A Distribution Path created in the source deployment
    • A Replicat created in the target deployment

This replication scenario is available as a quickstart.