Qlik Sense Configuration

This tutorial will guide you through setting up a basic connection between Qlik Sense and Kognitio.

For this there are four requirements:

You can choose to connect via the Qlik Sense visual GUI or the Qlik Sense script editor. Both options are detailed below.

Connecting via the Qlik Sense GUI

1. Creating the app

From the Qlik Sense hub, start by creating a new app. Name the app in the pop-up that appears. Click Create and open the app when the creation is finished.

Name the app

2. Select connection type

Select the Add data from files and other sources box.

Select connecting option

On the new screen you’ll see an assortment of connections for different data sources. Click ODBC. In the pop-up window select the Kognitio DSN that you created earlier from the list. Enter your Kognitio login credentials. Name the connection and click Create.

Login credentials

3. Select database objects and load data

From the Owner dropdown select a schema. This will populate the Tables list. Check the box of the view with a table/view and you’ll see a sample of the data. Click Add data.

Select data

Warning

When using the Qlik Sense GUI all the data from a selected source will be loaded into memory on your Qlik Sense server. Therefore only select a view that contains a small amount of data

After the load you’ll be taken to the sheet editing screen and a confirmation that the data has been loaded.

Finished load

Now you can start creating visuals in Qlik Sense with data from Kognitio. For details on how to explore larger data sets see our tutorial on Using Kognitio to run Qlik Sense ODAG.

Connecting via the script editor

1. Creating the app

From the Qlik Sense hub, start by creating a new app and name the app in the pop-up that appears, click the Create button and open the app once it’s finished. .

Name the app

2. Select connection type

Select the Add data from files and other sources box. Then select the Script editor box.

Select connecting option

3. Connect to Kognitio via ODBC

In the Main section, enter the connection string. The syntax for this is:

LIB CONNECT TO '<connection_name>'

The connection_name can be found on the right of the load editor. In this example we have:

LIB CONNECT TO 'test_connection (ec2amaz-6vll591_administrator)';

If you don’t have a connection then create a new one

  • Click on Create new connection.

  • Select ODBC

  • Select Kognitio DSN created earlier

  • Enter your Kognitio login credentials.

  • Name the connection and click Create.

4. Add the SQL query and load data

Enter a SQL query into the Main editor pane below the preset variables. The syntax for this is:

<table_name_for_qlik_sense>:
LOAD
  <column_names_from_SQL_query>
;
SQL
  <your_SQL_query>
;

For an example see How to use Qlik Sense with Kognitio

After the load you’ll be taken to the sheet editing screen and a confirmation that the data has been loaded.

Finished load

Now you can start creating visuals in Qlik Sense with data from Kognitio.

Using the script editor is more flexible than the Qlik Sense GUI. You have more control over the size of the data that is loaded into Qlik Sense. It is easy to remove unwanted columns from a data source using the SELECT statements; use SELECT TOP N and ORDER BY to filter results; or use GROUP BY to produce an aggregated results set that can then be visualized or analyzed further in Qlik Sense.

5. Learn more

  1. Get Started using Qlik Sense with Kognitio

  2. Learn how to query large data sets with Kognito and Qlik Sense On Demand App Generation

  3. Video showing how to use Kognitio and Qlik Sense On Demand App Generation on Retail Data