Setting up MongoDB Atlas

After you have selected MongoDB Atlas as the Source for creating the Pipeline, provide the following connection settings and data replication details in the Configure Your Source page. You can fetch the database settings from your MongoDB Atlas account.

Retrieving Database Settings from MongoDB Atlas

Perform the following steps to retrieve your MongoDB Atlas database settings:

  1. Access your MongoDB Atlas account and select the project whose data you want to replicate.

  2. Click Clusters in the left navigation bar.

    MongoDB connection settings

  3. Click CONNECT.

  4. Click on Connect with the mongo shell.

  5. Ensure that the mongo shell version is greater than 3.6, and click COPY to copy the connection string.

  6. Copy the database host name and the user name.

    MongoDB Atlas database host address and user name

Defining MongoDB Atlas Connection Settings in Hevo

Provide your MongoDB Atlas database connection details in the Configure Your Source page:

  • Pipeline Name: A unique name for the Pipeline.

  • Provide the following details fetched from the MongoDB Atlas account:

    • Database Host: The MongoDB DNS name fetched from your MongoDB Atlas account. No additional information needs to be provided in this field irrespective of your MongoDB configuration.

    • Database User: The authenticated user that can read the collections in your database.

      Note: It is recommended that only Read-Only permissions are provided to the user.

  • Database Password: The password for the database user.

  • Provide the following Connection Settings:

    • Connect through SSH: Enable this toggle option to connect to Hevo using an SSH tunnel, instead of directly connecting your MongoDB Atlas database host to Hevo. This provides an additional level of security by not exposing your MongoDB setup to the public. Read Connecting Through SSH.

      If this option is disabled, you must whitelist Hevo’s IP addresses, as listed here, in the MongoDB Atlas settings to allow Hevo to connect to your MongoDB Atlas host. This step is performed in your MongoDB Atlas account.
      Access your MongoDB Atlas account and:

      1. Click on Network Access.
      2. In the IP Whitelist tab, click on Add IP Address and provide Hevo’s IP address.

      Whitelisting HEVO IP Addresses in MongoDB Atlas

  • Provide the following Advance Settings:

    • Load All Databases: If enabled, Hevo fetches data from all your databases on the selected host. If disabled, provide the Database Name to fetch data from.

      Note: You can separate multiple database names with a comma.

    • Merge Collections: If enabled, collections with the same name across different databases are merged into a single Destination table. If disabled, separate tables are created, prefixed with the respective database name. See Example - Merge Collections Feature.

    • Load Historical Data: If disabled, Hevo loads data written in your database after the time of creation of the Pipeline. If enabled, the entire table data is fetched during the first run of the Pipeline.

Last updated on 25 Aug 2020