MongoDB

As MongoDB has no schema, Quantive samples that data and creates an implicit schema.

Neli Ivanova avatar
Written by Neli Ivanova
Updated over a week ago

MongoDB is a popular NoSQL database. Quantive can connect to any collection in the MongoDB database. As MongoDB has no schema, Quantive samples that data and creates an implicit schema.

How to connect

  • In Quantive, navigate to Settings > Data Sources screen

  • Click the Select data source button

  • From the Choose a connector dialog, select the Databases tab and then MongoDB

Enter the necessary information to connect to your MongoDB database:

  • Host: hostname or IP address of your MongoDB instance

  • Database: the name of the database to which you wish to connect

  • Username: the name of the user with which you wish to connect

  • Password: the password of the user with which you wish to connect

  • Port: the port where MongoDB is listening. The default is 27017, which is a standard MongoDB port

Click on the Connect button

  • Choose a collection to which you want to connect and click on the Use ... button

  • Give the name of your data source, something that makes sense to you and select the sync schedule (how often you want this data source to be synced automatically)

  • Click on the Add my data source button
    โ€‹
    Note: Contact us for information on Quantive's outbound IPs for your account so that you can ensure that your Mongo database is accessible for Quantive synchronization services.

What data from MongoDB can I use?

Since MongoDB is a NoSQL database and hence does not have a defined schema, Quantive will sample the data present in the collection and infer an implicit schema.

You can sync any "field" from any collection in any database that is accessible to the user with which you connected to the MongoDB database.

Quantive will automatically coerce types for you, so for example you can map the ObjectId type to String.

Did this answer your question?