MongoDB as a Source
  • 1 Minute to read
  • Dark
    Light

MongoDB as a Source

  • Dark
    Light

Step 1 - Add MongoDB as a Destination

In order to connect a database as a source, first, you need to add it as a destination. Read more about the steps here.

Step 2 - Create a MongoDB Data Source

  1. Sign in to your Dataddo account and click on Sources at the top of the page.

  2. Click on Create Source in the top right corner.

  3. From the list of sources, choose MongoDB. You can type the name of the connector into the search bar to find it faster.

  4. From the drop-down menu, choose your Account connected to Dataddo and Click on Next to continue with the setup.
    MongoDB - source - account

  5. Choose a Name for your new Data Source and fill in the following fields:
    MongoDB - source - label

    1. MongoDB Collection - write the name of the collection from your Mongo database, copy-paste the name include the case (case matters)  (example: in this database, we are accessing the "Box" collection. So the collection field should be "Box")
      MongoDB - collection

    2. Aggregation pipeline - it accepts "json" format transformation.
      Example:
      Mongo DB - json example

  6. Configure your snapshotting preferences by choosing your Sync frequency. Under Advanced setting,s you can select the exact Time, of synchronization. Confirm your setup by clicking on Next.
    If the Data range is available to select, you can load historical data. Read more in our guide.

  7. Before saving the source, you can see a preview of your data by clicking on the Preview button. you can adjust the date range to a more specific view.

    • Also, you can see the full list of the metrics you selected by clicking on Show all Metrics and attributes, in the left navigation.
      Data source - create - preview
  8. Click on Save and your new Data Source is ready.

Congratulations, your new Data Source is ready!


Troubleshooting

Broken View / Error Message

If you cannot see a preview of your data, go back a few steps and check your setup. The most common causes are:

  • Date range - we recommend a smaller date range. If you need to load historical data, check our guide.
  • Invalid metrics, attributes or breakdowns, or their combination - you may not have any values for them.
    Data source -create- error

Need assistance?

Feel free to contact us and we will help you with the setup. To speed the process of resolving your issue, make sure you provide us with sufficient information.


Was this article helpful?

What's Next