MongoDB

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

Prerequisites

Copy NAT Gateway IP in Dataworkz

To find the Dataworkz platform NAT gateway IP address:

• Log in to the Dataworkz application.

• Go to Configuration by clicking the gear icon at the top right.

• From the left menu, select Security > Deployment Details.

• Copy all cluster IPs listed. These IP addresses must be added to your MongoDB settings to allow access from Dataworkz.

Whitelist the IP in MongoDB Atlas

Log in to your MongoDB Atlas account and select the appropriate project. Follow the steps below to whitelist the IP.

1. Go to Security > Network Access.

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

Creating MongoDB Configuration in Dataworkz

1. Log in to the Dataworkz application.

2. Go to Configuration > Databases > MongoDB.

1. Click Add New Configuration.

1. Enter the MongoDB Database Name.

2. Select the Authentication Method (Username & Password or TLS/SSL Certificate).

3. Enter the Host Server name.

4. If using password-based authentication, enter the Username and Password.

5. If using certificate-based authentication, enter the Keystore Path, Keystore Password, Truststore Path, and Truststore Password.

6. Click Test Connection to verify the MongoDB connection.

   1. If the connection succeeds, a success message appears.

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

Click Save to save the configuration.