Skip to main content

MongoDB

Connections to a MongoDB database are made by selecting MongoDB from the list of drivers in the list of connectors in the QlikView ODBC Connection dialog or the Qlik Sense Add data or Data load editor dialogs.

MongoDB is a NoSQL database program. It uses JSON-like documents with schemas.

Note: Industry-accepted best practices must be followed when using or allowing access through the ODBC Connector. Administrators must follow The Principle of Least Privilege when setting up source database privileges and permissions.

Supported offerings

  • Qlik Sense Desktop/Qlik Sense Mobile Client Managed
  • Qlik Sense Enterprise SaaS
  • QlikView (Requires separate installation)

Supported MongoDB versions

The followings database versions are supported:

  • 3.4
  • 3.6
  • 4.0
  • 4.2

Supported MongoDB data types

The following MongoDB data types are supported by the MongoDB Connector.

  • Date
  • DBPointer
  • Decimal
  • JavaScript
  • JavaScript (with scope) -- Not supported as string. Converts to SQL_VARCHAR.
  • MaxKey
  • MinKey
  • NumberDouble
  • NumberInt
  • NumberLong
  • ObjectID
  • Regular Expression
  • String
  • Symbol
  • Timestamp
  • Undefined