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.

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 Autonomous AI Databases, then you need only one Oracle deployment type.

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, 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

Example: Azure SQL Managed Instance to Autonomous AI Transaction Processing

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

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 AI Transaction Processing, and then assigned to the Oracle 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 AI Transaction Processing to Apache Kafka

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

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 AI Transaction Processing, and then assigned to the Oracle deployment

  • A connection to Apache Kafka, and then assigned to the Big Data 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 AI Transaction Processing

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

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 AI Transaction Processing, and then assigned to the Oracle 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 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

• 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 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

• 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.