To succesfully 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 Studio installed.
• Target databases/schemas enabled for ORDS and REST APIs.

1. Create the source MongoDB connection:
   1. On the GoldenGate Studio Home page, click 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. Click 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. Click Next.
   7. On the Confirmation page review a summary of your connection details, and then click Create.
2. Repeat the steps above to create the target Oracle JSON Collection Tables or Oracle Autonomous JSON Databaseconnection, 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.

1. Create the pipeline:
   1. On the GoldenGate Studio Home page, click Create pipeline.
   2. On the Recipe page, select the Database Migration recipe, and then click Next.
   3. On the Overview page, complete the following fields, and then click Next:
      1. For Name, enter demo-pipeline.
      2. For Migration Type, select Online.
   4. On the Connections page, complete the following fields, and then click 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 click Next.
   6. On the Validate Target page, select Validate, and then click Next.
   7. Click Save & configure.
2. Configure the pipeline:
   1. On the Configuration page, configure the database/schema and collection/table mappings as needed. Click Save.
   2. On the Overview page, in the Initialization view, click 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.

1. Monitor the pipeline in the GoldenGate Studio console.
2. For advanced monitoring, you can review the Extracts and Replicats the GoldenGate Microservices console.