MongoDB

Prerequisites

• If your MongoDB security posture requires IP whitelisting, have our data syncing service's static IP available during the following steps. It will be required in Step 3.

Step 1: Locate connection information

MongoDB CLI

1. Connect to your MongoDB node using the MongoDB CLI as an admin.
2. Execute the following query:

db.adminCommand( { replSetGetStatus : 1 } ).members

3. Make a note of the host identifiers.

MongoDB Atlas

1. Log in to your Atlas dashboard, click into the Database tab and click Connect.
2. Under Connect your application, click into the Drivers option.
3. In the following screen, make a note of the host identifier within your connection string. It can be found within the string that starts with mongodb+srv and the identifier is the URI after the @. E.g., some-cluster.some-characters.mongodb.net.

Step 2: Allow database access

MondoDB CLI

1. Connect to your MongoDB node using the MongoDB CLI as an admin.
2. Execute the following script (with a username and password) to create a new user. Replace database with the name of the database you'd like to load data into.

   use admin
   db.createUser({
     user: "<username>",
     pwd: "<password>",
     roles: [ {role: "readWrite", db: "<database>"} ]
   })

MongoDB Atlas

1. Log in to your Atlas dashboard, click into the Database Access section of the Security options.
2. Select Add New Database User. Choose the Password authentication method, and enter a username and password for the new user.
3. In the Database User Privileges menu, select Grant Specific User Privileges. Within Specific Privileges, add the following: readWrite@<database> (with the name of the database you'd like to load data into). You can leave the Collection field blank (*).
4. Click Add User to create the new user.

Step 3: Setting up Network Access

If your MongoDB instance enforces IP Access restrictions, you'll need to allow access to a static IP.

MongoDB CLI

1. Connect to your MongoDB node using the MongoDB CLI as an admin.
2. Execute the following script

use admin
atlas accessLists create "<static_ip_address>" --comment "data sharing service static IP"

MongoDB Atlas

1. Log in to your Atlas dashboard, click into the Network Access section of the Security options.
2. Select Add IP Address. In Access List Entry enter the static IP of the service.
3. Add an optional comment (e.g., "data sharing service") and click Confirm.

Step 4: Add your destination

Use the host name, port, and database name (as noted in Step 1) and the username and password (as configured in Step 2) to complete the connection.