This integration allows you to connect and pull data from MongoDB into your data notebooks.
In this guide:
To connect your MongoDB database with your data notebooks you need to have the following:
- Appropriate permissions and generated API key on MongoDB
- Intersect account and owner access level
Connecting your MongoDB database
You can add your MongoDB integration from the Dashboard > Integrations > Add integrations > Add MongoDB section.
One-click on the MongoDB box and the connection portal will open. These are the fields that are required for the connection to be successful:
- Integration name
- Connection String
- Database Name
- Collection Name
To access these parameters, you need to create an API key using the Access manager in MongoDB. You should be able to do it on your own if you follow the official documentation on this link. If you set it up correctly, you will be given access to the username, password, and connection string.
You can then proceed to fill the connection portal in Intersect. If the connection is successful, you should be able to see your new MongoDB integration on your Integrations page.
Pull data from MongoDB
After you configure your Salesforce integration, you can import your data into your notebook. To do that, click Import data > Database > Read from MongoDB (Add).
Once you select the integration, a new “Read from MongoDB” step will be added to your data notebook. To successfully pull data you will need to select your integration (in our case it’s called: My MongoDB database). Then, from the dropdown, you can select two types of queries: aggregate or find. Finally, you can add a custom MongoDB query to source the appropriate data.
If the step is successfully configured you will see an output with your sourced data.
If you wish to preview the table you can expand the Output step, which will preview the table that was sourced.