To successfully complete this quicktart, you must have the following:

• MongoDB replica set configured.
  • OCI GoldenGate Big Data capture uses operations log (oplog) to read the CDC records. The oplog is a capped collection that keeps a rolling record of all operations that modify the data stored in your databases. Oplog files are created in MongoDB when Replicat set is enabled. MongoDB Atlas comes with a preconfigured Replicat set configuration. For on premises MongoDB, you need to deploy a replica set.
• MongoDB 3.6 & later.
• OCI GoldenGate support for capture of following operations: INSERT, UPDATE, DELETE.

To learn more, see Using Oracle GoldenGate Capture for MongoDB.

1. Create an Oracle Autonomous JSON Database.
2. Create a Big Data deployment for the source MongoDB and target Oracle Autonomous JSON Database.
3. Create a MongoDB connection.
4. Create connection for target Create an Autononous JSON Database connection.
5. Create a connection to GoldenGate, and then assign this connection to the Big Data deployment.
6. Assign MongoDB and Autonomous JSON connections to the Big Data deployment.

1. In the OCI GoldenGate deployment console, ensure that you're on the Administration Service Overview page, and then click Add Extract (plus icon).
2. Add an Extract with the following values:
   1. On the Extract Information page, under Extract type, select Integrated Extract, enter MCDC as a Process Name, and then click Next.
   2. On the Parameter File page, ensure the source mapping includes TABLE source.*;.
3. Click Create and Run.

1. In the OCI GoldenGate deployment console, ensure that you're on the Administration Service Overview page, and then click Add Extract (plus icon).
2. Add an Extract with the following values:
   1. On the Extract Information page:
      • For Extract Type, select Initial Load Extract.
      • For for Process Name, enter MIL.
   2. On the Parameter File page, make the following changes:
      • Locate the EXTTRAIL line and replace $extfilePath with your trail name. For example:

        EXTFILE I1

      • Define the source mapping as TABLE source.*;.
        Note
        
        This is the source database/collection mapping. TABLE *.* results in extracting from all the databases/collections.
3. Click Create and Run.

   When MongoDB Initial Load Extract runs successfully, you will see the statistics in the extract report file.

1. In the OCI GoldenGate deployment console, ensure that you're on the Administration Service Overview page, and then click Add Replicat (plus icon).
2. Add the Initial Load Replicat with the following values:
   1. On the Add Replicat page, under Replicat type, select Classic, enter a Process Name, and then click Next.
   2. On the Replication Options page:
      • For Name, enter the name of the Trail from Task 3 (I1).
      • For Domain, select a domain.
      • For Alias, select the Autonomous JSON connection connection created in Task 1.
      • For Checkpoint Table, select the checkpoint table you created for the target deployment.
   3. On the Managed Options page, leave the fields as they are, and click Next.
   4. On the Replicat Parameters page, you can specify parameters to further configure your Replicat:

      MAP *.*, TARGET *.*;

3. Click Create and Run:

1. In the OCI GoldenGate deployment console, ensure that you're on the Administration Service Overview page, and then click Add Replicat (plus icon).
2. Add a Replicat with the following values:
   1. On the Replicat Information page, under Replicat type, select Classic Replicat, enter MCDC as a Process Name, and then click Next.
   2. On the Parameter File page, you specify parameters to further configure your Replicat, and then click Create and Run:

      HANDLECOLLISIONS
      MAP *.*, TARGET *.*;

      Note
      
      Add HANDLECOLLISIONS to resolve the issues with duplicate or missing records while applying the replicat.

      HANDLECOLLISIONS parameter has a negative impact on the performance and that’s why it is recommended to use as needed. When your source & target is synced, you can stop the CDC replicat, remove HANDLECOLLISIONS and re-start the replicat.