MongoDB

The Qlik MongoDB Connector is a premium connector that loads data from a MongoDB database into a Qlik Sense or QlikView app.

Tip:

The Qlik Web Connectors help you connect to different data sources and fetch data in the same way. Learn how to authenticate a data source connection and how to use tables to fetch data.

Connecting to data sources

The Qlik MongoDB Connector can be used for the following tasks: 

  1. To list the available collections in a MongoDB database.
  2. To list all of the documents in a collection.
  3. To extract and load the data from a collection into a Qlik Sense or QlikView app.

To use the Qlik MongoDB Connector, you must have access to a MongoDB database.

Ways to access your data

The Qlik MongoDB allows you to connect to a MongoDB data source by specifying a valid MongoDB connection string or by entering a MongoDB server, port, username, password and database name.

List available collections

To list all of the collections on a MongoDB database, specify a valid connection string or enter a MongoDB server, port, username, password and database name. Enter the name of the MongoDB database you want to connect to and then click Save Inputs & Run Table.

Note: Once you click Save Inputs & Run Table the information is used to run all tables.

List documents in a collection

To list all of the documents in a collection, specify a collection name and then click Save Inputs & Run Table.

Extract and load data from a collection

In the Collection table, you can define some data parameters before running the Collection table. The Qlik MongoBD Connector supports JSON queries.

If the collection that you want to load contains a large number of rows, you can use the Max Number of Rows parameter to set the maximum number of rows that will be returned when you run the table.

Use the JSON Query parameter to run specific queries on a collection.

If your collection contains nested sub documents, you can create nested array structures by using the Sub Document Key Path and Sub Document Path fields. In the Sub Document Path field, enter the path of the sub document that you want to extract, and in the Sub Document Key Path field, enter the path of the document you want to link it to.

Troubleshooting

If you are having authentication issues, verify that your username, password, and other connection details are correct for the MongoDB database that you want to connect to.

Kerberos authentication

The Qlik MongoDB Connector uses the official c# driver, which supports Kerberos.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?