🔌Setting up a MongoDB connector

This connector is used to retrieve data from a MongoDB database, which is also a NoSQL database. This is a clear example that shows Toucan’s vast spectrum of connectivity, allowing our users to connect to RDBMS’s as well as NoSQL DB’s like MongoDB with ease!

Configuring the MongoDB connector in Toucan

Fill in the mandatory connection information:

• Host

• Port

• Username

• Password

MongoDB connection form

Then click TEST CONNECTION

MongoDB Test connection

and finally SAVE it.

After successfully configuring the connector, you will be able to find it in the Connector section of the DataHub "Datasource" tab

Selecting data from MongoDB

To create a dataset from MongoDB, click on the "create from icon", you will then be able to:

• Select the Database

• Select a Collection

• Add a Query (optional): Use MongoDB aggregation pipeline to queries your collections , and return only the relevant results. After inputting your query, select "Preview" to review the results, and then click "Save" to create a dataset based on your chosen selection.

Query a datasource MongoDB

For more info, see the dedicated section Creating datasets

After selecting data from your connector you will be able to create a dataset thanks to YouPrep using the selection as "source step".