Qlik Connection

This component defines a connection to Qlik Sense, the business intelligence and visualization software. For this connection, a Qlik Connector License is required. Note that Qlik and Jedox should not be installed on the same server.

The following ports must be open for the Qlik APIs to work correctly:

  • 4239
  • 4242
  • 4243
  • 4747
  • 4748

Note: Qlik Sense Desktop is not supported.

To connect to the Qlik Sense server, a virtual proxy must be created in the Qlik Management Console (QMC). To access it, enter the URL for your Qlik Sense server followed by /qmc/, e.g. https://qlik.server.local/qmc/.

  1. In the left-side navigation pane, click on Virtual Proxies, which is under the CONFIGURE SYSTEM heading.
  2. Click the Create new button at the bottom of the page and specify the basic info settings according to your requirements.
  3. Select Authentication from the Properties list on the right. For Authentication method, select Header authentication Dynamic User Directory. Jedox authentication only works with this option.
  4. Specify "Header authentication header name" and "Header authentication dynamic user directory" as indicated below:
    Authentication setup screenshot
  5. Click the Apply button. Qlik Sense server will show a warning dialog that indicates that the virtual proxy will be restarted. Click Yes at the prompt.

  6. Select Load Balancing from the Properties list on the right. Click on Add new server node. Select Central and click on Add. Click on the Apply button.

After these steps, Jedox Integrator will be able to connect the Qlik server instance with predefined parameters.

Settings

Qlik Sense host Virtual proxy to the Qlik Sense server
User Name of the Qlik Sense user
User directory name Name of the Qlik Sense user directory
Virtual proxy settings

SSL mode

Verify: the certificate is verified.
Trust: the certificate is imported to the keystore if not yet available.
Off: no SSL used.

 

User directories can be found in https://qlikServer/qmc/users.

Important: if the Domain Active Directory is not set up correctly, Qlik extracts will not be able to return any data, even if a connection is successful.

 

Note: if no valid SSK certificate is available, the following error message will appear:

ERROR pool-10-thread-2 MetadataExecution.java:90 - Websocket execution exception: No subject alternative DNS name matching r00sqsent1 found.

Updated June 5, 2023