Create a Database Migration

Use a recipe to create a Database Migration in Oracle GoldenGate for MongoDB Migrations.

Before you begin

To successfully complete this Quickstart, you need:

• Source and target databases with sample data loaded.

• A replica set for an online migration MongoDB source connection.

• A MongoDB version that has not reached end of life for the online migration source connection.

• GoldenGate for MongoDB Migrations installed.

• Target databases/schemas enabled for ORDS and REST APIs.

Task 1: Create the database connections

1. Create the source MongoDB connection:

   1. On the Home page, select Create connection.

   2. The Create connection configuration panel consists of three pages. On the General Information page, enter SourceMongoDB as a Connection name, and optionally, a Description.

   3. For Connection type, select MongoDB from the dropdown.

   4. Select Next.

   5. On the Connections details page, enter a Connection string.

      Note: If the Connection string requires a Username and Password, enter them in the fields provided below. Ensure that your connection string follows the expected format.

   6. Select Next.

   7. On the Confirmation page review a summary of your connection details, and then select Create.

2. Repeat the steps above to create the target Oracle JSON Collection Tables or Oracle Autonomous JSON Database connection, and make these changes:

   • On the General Information page, for Name, enter TargetJSONCollection.

   • On the General Information page, for Connection type, select Oracle JSON Collection Tables.

   • On the Connection details page, enter a username and password.

   Note: See the connection strings expected format table for more information.

Task 2: Create and configure the pipeline

1. Create the pipeline:

   1. On the Home page, select Create pipeline.

   2. On the Recipe page, select the Database Migration recipe, and then select Next.

   3. On the Overview page, complete the following fields, and then select Next:

      1. For Name, enter demo-pipeline.

      2. For Migration Type, select Online.

   4. On the Connections page, complete the following fields, and then select Next:

      1. For Source database, select the source database from the dropdown.

      2. For Target database, select the target database from the dropdown.

   5. On the Validate Source page, select Validate, and then select Next.

   6. On the Validate Target page, select Validate, and then select Next.

   7. Select Save & configure.

2. Configure the pipeline:

   1. On the Configuration page, configure the database/schema and collection/table mappings as needed. Select Save.

   2. On the Overview page, in the Initialization view, select Start.

      Note: It takes a few minutes for the pipeline initialization to run. The status of each of the steps will change from PENDING to IN PROGRESS to COMPLETED when it is ready for you to use.

   3. In the Runtime view, you can view the real time database statistics, such as Operations Extract and Operations Replicat.

Task 3: Monitor the pipeline

1. Monitor the pipeline in the GoldenGate Studio console.

2. For advanced monitoring, you can review the Extracts and Replicats the GoldenGate Microservices console.