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.
  • Generate Qlik Sense certificates on QMC. Find more details below

VERSIONS SUPPORTED:

  • Qlik Sense November 2023 Patch 4
  • Qlik Sense August 2023 Patch 2

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 [email protected] so that we understand your requirements.

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. Enter the host name of the Qlik Sense Server
  3. Provide Username

Optionally, toggle on:

3. Configure 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.

Secure Connection Proxies

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


Name Description
1 API Server
  • The host name of the Qlik Sense server with URI scheme specified (e.g. http://qliksense.metricinsights.com or https://qliksense.metricinsights.com). Leave blank if server field is completed.
2 Sheet Filter Specify the title(s) of your Qlik Sense Sheet(s)
  • Wildcard(*) syntax is supported
3 Application Filter
Specify application(s) you have created in Qlik Sense
  • Wildcard(*) syntax is supported
4 Object Filter Specify name(s) of Object(s) you need to bring from Qlik Sense
  • Wildcard(*) syntax is supported
5 User Domain

Specify the domain group for your Username

6 Client Certificate
Upload the client certificate file
  • Generated on the Qlik Sense side. See more details below.
7 Client Private Key Upload the client private key file
  • Generated on the Qlik Sense side. See more details below.
8 Limit Filter Values Specify the limit for filter values count that will be applied to all filters
9 Object Types to Collect Specify object type(s) to be retrieved: APPLICATION, SHEET, or OBJECT
  • Separate multiple values with a comma
10 Stream Filter
Specify stream name(s) by which you want to filter your results
  • Separate multiple values with a comma
  • Wildcard(*) syntax is supported
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.

Click [Test Connection] in the upper right corner