MongoDB

This document describes the Dataworkz connector configuration required to access MongoDB .

Prerequistes

Copy NAT Gateway IP in Dataworkz

This is the IP of Dataworkz platform NAT gateway and can be viewed by following the steps provided below.

• Login to Dataworkz Application

• Goto Configuration by clicking the gear icon at top right of the screen

• From left menu select Security -> Deployment Details

• Copy all the cluster IP listed

• These IP addresses would need to be configured in your MongoDB settings to allow access from Dataworkz.

Whitelist the IP in MongoDB Atlas

For the purpose you need to login to the MongoDB Atlas account and select the appropriate project. Follow the steps below for IP whitelisting.

1. Goto Security -> Network Access

   
2. Enter the list of the IPs that were copied from Dataworkz platform.

Creating MongoDB Configuration in Dataworkz

1. Login to Dataworkz Application

2. Goto Configuration -> Databases -> MongoDB

3. 
4. Click the Add new configuration

5. 
6. Enter the MongoDB Database Name

7. Select the Authentication Method (Choose between Username & Password or TLS/SSL Certificate)

8. Provide Host Server name

9. Enter Username & Password (If using password-based authentication)

10. Enter Keystore Path, Keystore Password, Truststore Path, Truststore Password (If using certificate-based authentication)

11. Click Test Connection to verify the MongoDB connection.

    1. If the connection is successfully established, it will return a Success message.

    2. If the connection fails, review and correct the provided details.

Click "Save" to save the configuration