Establish Connectivity to Qlik Sense

This article describes the process of creating a plugin Data Source to connect to Qlik Sense. This Data Source will allow data from existing Qlik Sense objects to be used in building elements using Metric Insights tools.

PREREQUISITES:

  • Enable the following ports: 80 (HTTP), 443 (HTTPS), 4747 (Websocket API), and 4243 (REST API). If you have a Load Balancer, forward the same ports.
  • For other step-by-step instructions, see  Prerequisites to connecting to Qlik Sense server

VERSIONS SUPPORTED:

  • Qlik Sense May 20121 qliksenseserver:14.20.5
  • QlikSense February 2021 qliksenseserver:14.5.4
  • QlikSense June patch 3 qliksenseserver:13.82.11

NOTE: Versions outside of this list may be supported but are not actively tested. If you have an older or newer version, please work with support@metricinsights.com so that we understand your requirements.

[Release 6.x]: 'Remote Data Collector' renamed to 'Remote Data Processor'

With the release of Version 6.2.1, .conf files are no longer required for advanced configuration in Metric Insights. It is recommended to use the Plugin Config page to adjust parameters and their values. See this article for more details.

1. Create New Data Source

Access Admin > Collection & Storage > Data Sources

  1. [+ New Data Source]
  2. Choose "Qlik Sense" from the Other drop-down list
  3. [Next Step]

2. Provide Required Qlik Sense Parameters

  1. Input a descriptive phrase in Data Source Name
  2. Provide Click through server
  3. Enter the host name of the Qlik Sense server
  4. Provide Username

Optionally, toggle on Enable On-Demand Element Creation and Enable Content Auto Synchronization

3. Configure a Host White List on the Qlik Sense Server

Qlik Sense server must be added to the Host white list. The server name must be specified in the exact same way as it is used for MI Data Source configuration > Info tab (server field).

Secure Connection Virtual Proxy

Access the Host white list via Virtual Proxy > Profile > Properties > Advanced tab.

Connection Proxies (optional configuration)

Additionally, you can secure your Connection Proxies and increase Session Timeout per Proxy site.

If your Qlik Sense uses a secure connection, provide a certificate by going to your Qlik Sense server and logging onto the QMC (http://your-qliksense-server/qmc/virtualproxies).

Increase Session Timeout for the Proxy Site

Navigate to your Proxy on the QMC.

Increase the Session Timeout

Increase the Session inactivity timeout (minutes). This will allow Metric Insights to complete more job requests (e.g., getting data from a report) without Qlik Sense prematurely ending the session.

4. Configure Optional Qlik Sense Parameters


Description
1 Upload the client certificate file
  • Generated on the Qlik Sense side. See more details below.
2 Upload the client private key file
  • Generated on the Qlik Sense side. See more details below.
3 Specify the limit for filter values count that will be applied to all filters
4

Specify object type(s) to be retrieved: APPLICATION, SHEET, or OBJECT. 

  • Separate multiple values with a comma.
5 Specify stream name(s) by which you want to filter your results 
  • Wildcard(*) syntax is supported
6 Specify the title(s) of your Qlik Sense Sheet(s)
  • Wildcard(*) syntax is supported
7 Specify application(s) you have created in Qlik Sense
  • Wildcard(*) syntax is supported
8 Specify name(s) of Object(s) you need to bring from Qlik Sense
  • Wildcard(*) syntax is supported
9 Specify the domain group for your Username
5. Generating PEM Files

Navigate to Certificates from the QMC

  1. Enter a descriptive name
  2. Select Platform independent PEM-format from the drop-down
  3. [Export certificates]
  4. Access the folder that contains exported certificates at the specified location on the server

6. Proceed with Advanced Configuration

Advanced Configuration settings can be set to default values unless Data Source requires more precise tuning. For more details on how to proceed, refer to Advanced Data Source Configuration.

[Test Connection] in the upper right corner