MongoDB

An overview of the MongoDB integration with Secoda

Getting started with MongoDB

There are 3 steps to get started using MongoDB with Secoda

  1. Create a database user

  2. Whitelist Secoda IP Address

  3. Connect MongoDB to Secoda

Requirements

  • The MongoDB cluster must be running version 5.0 or above. Prior MongoDB versions do not support MongoDB's Stable API. You can read more about Stable API in the MongoDB documentation

Creating a database user

If you are using cloud MongoDB (Atlas), you may need to create a new database user to connect to Secoda. To do that, repeat the following steps.

  1. Log into your Atlas account

  2. On the sidebar go to Security -> Database Access and click on ADD NEW DATABASE USER on the top right

  3. Use the password authentication method and save both the user name and password. The role given to the database user can be Only read any database under built-in role but it may need to be updated at a later date when Secoda comes out with new features

Whitelist Secoda IP Address

Once you have created the new database user, you need to add Secoda's IP address to the allowlist. To do that, repeat the following steps.

  1. Log into your Atlas Account

  2. On the side, navigate to Security -> Network Access and click on ADD IP ADDRESS on the top right

Connect MongoDB to Secoda

To connect to MongoDB to Secoda, repeat the following steps.

  1. In the Secoda App, select "Add Integration" on the Integrations tab

  2. Click on MongoDB

  3. Enter the URI, cluster name, and the team the integration will be associated with

    1. The URI can be found by navigating to Deployment -> Database on Atlas and clicking on the cluster you are trying to connect to

    2. Click on Driver to see a sample URI of the cluster

    3. Copy and paste the connection string to the URI field, replacing <username> and <password> with the username and password that was used to create the database user in step 1

  4. Once successfully connected, choose the databases and collections you want to extract to Secoda

  5. Run the initial extraction

Data type conversion

Last updated