Qlik Sense Desktopedit

This functionality is experimental and may be changed or removed completely in a future release. Elastic will take a best effort approach to fix any issues, but experimental features are not subject to the support SLA of official GA features.

You can use the Elasticsearch ODBC driver to access Elasticsearch data from Qlik Sense Desktop.


Data loadingedit

To use the Elasticsearch SQL ODBC Driver to load data into Qlik Sense Desktop perform the following steps in sequence.

  1. Create new app

    Once the application is launched, you’ll first need to click on the Create new app button:

    apps qlik newapp

  2. Name app

    …​then give it a name,

    apps qlik create

  3. Open app

    …​and then open it:

    apps qlik open

  4. Add data to your app

    Start configuring the source to load data from in the newly created app:

    apps qlik adddata

  5. Load from ODBC

    You’ll be given a choice of sources to select. Click on the ODBC icon:

    apps qlik odbc

  6. Choose DSN

    In the Create new connection (ODBC) dialog, click on the DSN name that you have previously configured for your Elasticsearch instance:

    apps qlik dsn

    Provide a username and password in the respective fields, if authentication is enabled on your instance and if these are not already part of the DSN. Press the Create button.

  7. Select source table

    The application will now connect to the Elasticsearch instance and query the catalog information, presenting you with a list of tables that you can load data from:

    apps qlik selecttable

  8. Visualize the data

    Press on the Add data button and customize your data visualization:

    apps qlik visualize