Qlik Connection

image_pdfimage_print

This component defines a connection to Qlik Sense, the business intelligence and visualization software. For this connection, a Qlik Connector License is required.

Note: Qlik Sense Desktop is not supported.

Main Settings

Qlik Sense Host:

Host of the Qlik Sense server

User:

Name of the Qlik Sense user

User Directory:

Name of the directory the Qlik Sense user directory

To connect to the Qlik Sense server, a virtual proxy must be created in the Qlik Management Console (QMC), which is accessible via the URL “<qlikServerAddress>/qmc/”.

In the QMC main dashboard “Virtual Proxies”, which is under the “CONFIGURE SYSTEM” node, create a virtual proxy with the following steps:

  1. Click “Create new” button and specify the basic info settings according to your requirements.
    (Right panel shows all of the properties via the selection).
  2. Select “Header authentication Dynamic User Directory” in Authentication section.
    (Jedox authentication only works with “Header authentication Dynamic User Directory”. Other authentications will be implemented in future.)
  3. Specify “Header authentication header name” and “Header authentication dynamic user directory” (see screenshot “Internal qmc panel” below).
  4. Click “Apply” button. Qlik Sense server will show a warning dialog that indicates that the virtual proxy will be restarted. Click yes and this will create the virtual proxy.
  5. The last step is the creation of a link between the central proxy and the proxy created in step 4. Under the right panel “Associated Items/Proxies”, the user can define link to the central proxy. (This panel is not activated until the virtual proxy is applied in Step 4.) 

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

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

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

 Internal qmc panel:

Virtual Proxy Settings

Prefix:

The prefix of the virtual proxy

Authentication Header Name:

The authentication header name of the virtual proxy

Authentication Dynamic User Directory:

The authentication dynamic user directory of the virtual proxy

 Advanced Settings

SSL Mode:

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

 

image_pdfimage_print