๐Ÿ”Œ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

Then click 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): enter a query that will be sent to Mongo, which will then return only the relevant results. For instance, if you wish to filter results based on columns such as rated and year you can make use of Mongo's operators (refer to the information below). After inputting your query, select "Preview" to review the results, and then click "Save" to create a dataset based on your chosen selection.

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".

Last updated