Establish Connectivity to Qlik Sense

This article describes the process of creating a Data Source to connect to Qlik Sense. This Data Source will allow using existing Qlik Sense objects for building Elements in Metric Insights.

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.

1. Create New Data Source

Access Admin > Collection & Storage > Data Sources

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

2. Provide Required Qlik Sense Parameters

  1. Data Source Name: input a descriptive phrase.
  2. [Create]
  3. Qlik Sense Server: specify the URL to use for creating UI links back to your Qlik Sense server. This is the same URL you use for accessing Qlik Sense via your web browser.
  4. Username: input the username that you use to log in to Qlik Sense.
    • NOTE: To establish connectivity, Client certificate and Client private key must be provided under Optional Parameters. See instructions on how to generate them below.

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 Qlik Sense Data Source > Info tab (server field).

Secure Connection Virtual Proxy

  • Access the Virtual Proxies tab in your Qlik Sense QMC using the following URL: http://your-qliksense-server/qmc/virtualproxies
  • From the Virtual Proxies menu, access the Host white list via Virtual Proxy > Profile > Properties > Advanced tab.
Expand or collapse content 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
Expand or collapse content 5. Generating PEM Files

Navigate to Certificates from the QMC: http://your-qliksense-server/qmc/certificates

  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.