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
Define who will have access and who will be able to administrate this connection using Data Connection permissions.
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.
Define who will have access and use the information in this entity to create insights and automate KRs and KPIs using the Data Source permissions.
Click on the Finish 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.