Select and load data from a MongoDB database

Once you have created a connection to a MongoDB database, you can select data and load it into Qlik Sense or QlikView. In Qlik Sense, you load data through the Add data dialog or the Data load editor. In QlikView, you load data through the Edit Script dialog.

The SELECT statement does not include a WHERE clause, but one can be added in the Data load editor after the script built automatically in the script panel is inserted there. The SELECT statement for the MongoDB Connector supports the addition of WHERE clause.

Qlik Sense: MongoDB database properties

Database properties that can be configured
Properties	Description
Database	The database specified in the connection dialog.
Tables	Shows the tables in the specified database. Selecting a table will cause the table fields to be displayed in the Data preview tab.
Data preview	Shows a preview of the fields and data of the selected table.
Metadata	Shows a table of the fields and whether they are primary keys. Primary-key fields are also labeled with a key icon beside the field name.
Fields	The fields in the selected table. If the table name check box is selected, all the fields in the table are automatically selected. If you click only the table name, fields are displayed but not selected. They can then be selected individually. You can also change the field name by clicking on the existing field name. The new name is then used as an alias for the name the field has in the database.
Filter data	Displays a field in which you can enter filter criteria to select a subset of data in the fields you are loading. The Filter data property displays after tables have been selected. Filter data from an ODBC database
Filter fields	Shows a field where you can enter filter criteria. Filter data from an ODBC database
Hide script/Preview script	Shows or hides the load script that is automatically generated when table and field selections are made.
Include LOAD statement	Adds a LOAD statement before the SELECT statement. Add a LOAD statement to an ODBC connection
Add data	Opens the Associations view of the Data manager. Allows you add more data sources, fix any errors in your data, and create table associations. This option is available only when you use Add data. Managing data associations
Insert script	Inserts the script displayed in the Data preview panel into the script editor. This option is available only when you use the Data load editor.

QlikView: MongoDB database properties

Database properties that can be configured
Properties	Description
Database	The database specified in the connection dialog.
Tables	Shows the tables in the specified database. Selecting a table will cause the table fields to be displayed in the Data preview tab.
Fields	The fields in the selected table. If the table name check box is selected, all the fields in the table are automatically selected. If you click only the table name, fields are displayed but not selected. They can then be selected individually.
Script	Displays the load script built automatically from the selected tables and fields.
Preview	Shows a preview of the fields and data of the selected table. You can select which data columns to include by checking the box beside the field name. You can also change the field name by clicking on the existing field name. The new name is then used as an alias for the name the field has in the database.
Preceding load	Adds a LOAD statement before the SELECT statement. Add a LOAD statement to an ODBC connection
OK	Inserts the script displayed in the Script panel into the script editor.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here