Replicating Data to Amazon DocumentDB

To define a target connection for DocumentDB:

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

  2. In the Add Target Connection wizard, type a name for the connection and choose MongoDB Atlas in the Database field. (Amazon DocumentDB uses the MongoDB .NET provider.)

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

  4. Choose values for the following fields:

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

    Port The port number of the server running DocumentDB.

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

    Password The password for DocumentDB.

    Database The DocumentDB database name.

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

    Default Collection All DocumentDB 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.

  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.

The next step is to set up replications from whichever source connection you have defined to the DocumentDB target database.