Qlik Sense

Learn how to connect Qlik Sense desktop tool to Exasol using ODBC connection.

Exasol takes no responsibility for changes in functionality or terms of use for third-party tools. For more details about the compatibility and use of these tools with Exasol, refer to the respective software vendor’s website.

Environment

The following procedure uses Qlik Sense for Windows. For more information, refer to the Qlik website.

Prerequisites

  • Qlik Sense for Windows must be installed.

  • Your Exasol database must be running and reachable from the environment where the tool is used.

  • The Exasol ODBC driver must be installed. To learn more, see ODBC driver.

Exasol SaaS

  • The IP address of the host where the tool is running must be in the allowed IP address list in Exasol SaaS. To learn how to allow traffic to your database, see Network security (SaaS).

  • To connect the tool to an Exasol SaaS cluster you will need the connection string and a personal access token (PAT) for authentication. To learn how to get the connection details, see Connect to Exasol SaaS.

Connect Qlik Sense to Exasol

  1. In Qlik Sense Desktop, from the Qlik Sense Desktop Hub, click on Create New App.

  2. In the dialog box, type the name of your new app and click Create, then click Open app.

  3. Click Add data from files and other sources, and in the next screen click on ODBC.

  4. In the dialog box, select your DSN.

  5. In the Username and Password fields, enter the name and password for the Exasol user.

    For Exasol SaaS, use a valid personal access token as password.

  6. Click Create to create and open the connection to the Exasol database.

You can now select a schema from your Exasol database and start importing data into Qlik Sense. For more information about how to use Qlik Sense, refer to the Qlik documentation.