Replicating Data to MongoDB Atlas

With Syniti Data Replication, you can replicate relational data to MongoDB Atlas document database. MongoDB is currently supported as a target both in refresh and mirroring.

To define a target connection for MongoDB Atlas:

  1. Make sure that you have downloaded and installed the MongoDB .NET Provider. For nformation on where to obtain a .NET provider, check the Supported .NET Providers article in the Help Center. The Help Center also provides database-specific setup notes in PDF format..

  2. In the Metadata Explorer, choose Targets, then Add New Connection from the right mouse button.

  3. In the Add Target Connection wizard, type a name for the connection and choose MongoDB Atlas in the Database field.

  4. In the Set Connection String screen Output Folder field, enter the path to a directory to contain the output files and schema.

  5. Choose values for the following fields:

    Server The server name or IP address of the MongoDB instance.

    Port The port number of the server running MongoDB.

    Use DNS Seedlist If set to false, the standard connection format is used. If set to true, a DNS-constructed seed list is used. Using DNS to construct the available servers list allows more flexibility of deployment and the ability to change the servers in rotation without reconfiguring clients.

    User ID The user name for MongoDB Atlas.

    Password The password for MongoDB.

    Database The MongoDB database name.

    Output Folder The schema name and location to hold config files for the MongoDB objects.

    Default Collection All MongoDB replications need to be targeted to a specific collection. Use this field to indicate a default collection for all replications in that connection. Alternatively, if the Default Collection is left blank, every replication will need a collection name.

    Create Collection Per Table If set to true, every new replication will attempt to use the collection named as the target table. If the collection does not exist, it will be created using the Syniti DR table name.

    Use One Writer Per Group Default is True. When True, Syniti DR uses a single writer object common to all replications in a group (if groups are used). When False, a new object is created for each replication.

  1. Click Next to view the Select Tables screen.
    If this is the first time you have created a connection using the output folder defined above, the table display will be empty. You can add a representation of target tables after completing the wizard.

  2. Click Next to display the Actions screen,

  3. Optionally choose to continue with creating replications once the wizard is complete.

  4. Click Next to display the summary, then click Finish to create the connection.

  5. The next step is to add target output representation to the Metadata Explorer. This will be represented as relational tables.

Now you can set up replications from whichever source connection you have defined to the JSON target file.