Navigation

Connect from Qlik Sense

This tutorial demonstrates how to connect to MongoDB Connector for BI using Qlik Sense.

Authentication

New in version 2.2: The MongoDB Connector for BI now offers MySQL authentication plugins allowing you to connect with authentication but without TLS/SSL.

There are two options for authenticating your connection:

  1. Use an authentication plugin with either the SCRAM-SHA-1 or PLAIN authentication mechanism.

    Important

    The use of TLS/SSL is recommended as:

    • The SCRAM-SHA-1 mechanism hashes the passwords in the client plugin. However, all other data is in cleartext.
    • The PLAIN mechanism sends the password in cleartext.

    See C Authentication Plugin or Install the JDBC Authentication Plugin for more information on the plugins.

  2. Provide cleartext credentials for simple username/password authentication against a MongoDB database. This method uses MySQL’s built-in mysql_clear_password plugin.

    Note

    Authentication with mysql_clear_password requires the use of TLS/SSL. See Connect from MySQL with Authentication and TLS/SSL for more information.

The MongoDB Connector for BI requires authentication when running with --auth. When the MongoDB Connector for BI receives a connection with authentication credentials from a client, it passes those credentials through to the underlying MongoDB instance.

You can specify the following authentication options after your username as URI-style query parameters:

Connection Option Description
source

Specify the name of the database which stores the user’s credentials. If you do not specify this option, the MongoDB Connector for BI will default to the current database associated with the MySQL connection.

For authentication mechanisms such as PLAIN (LDAP) that delegate credential storage to other services, set the source value to $external.

mechanism

Specify the mechanism that the MongoDB Connector for BI should use to authenticate the connection. Accepted values include:

The PLAIN (LDAP) mechanism requires MongoDB Enterprise, and requires that source be $external.

Note

Neither Kerberos (GSSAPI) nor x.509 are supported.

Example

To authenticate as the user grace with authentication mechanism PLAIN and using an external source, you would use the following username:

grace?mechanism=PLAIN&source=$external

Connect from Qlik with Authentication Enabled

1

Create a System DSN (Data Source Name)

Follow the instructions in the Create a System DSN tutorial to create a Data Source Name for use with your connection to Qlik Sense.

2

Start Qlik Sense

Start the Qlik Sense desktop application.

3

Create a Connection to a MongoDB Database Using BI Connector

  1. Click Create a New App

  2. Give your app a name and open it.

  3. Click Add Data.

  4. Select ODBC from the list of data sources.

  5. In the Create New Connection window, select the ODBC data source you created in Step 1.

    Screenshot of Qlik list of data sources

    Note

    The username and password values you specified in your DSN override any values you enter in this dialog window, so you can leave those fields blank.

  6. The database and tables listed in your schema file should appear in your app’s overview.