Qlik Extract

image_pdfimage_print

This extract type provides data extraction from QlikSense Server after defining Qlik Virtual Proxy as described in the article Connecting to Qlik.

Main Settings

Qlik Connection:

Name of the Qlik Connection.

 Qlik Application Name 1) :

Name of the Qlik application. Note that applications are hidden to the outside until they are published.

Qlik Table Name 1) :

Name of one table of the data structure that Qlik Application uses. Tables can be seen from the  Data Manager on the Qlik server.

Row Count (optional):

The total number of rows that can be fetched from the server. Maximum number is 2.147.483.647 (default value).

Offset (optional):

Sets a unit to offset from the beginning of the table.

 

1) If the connection configuration is correct, the selected box provides context-aware selection by using dynamically fetched data from the server.

Notes:

  • If Qlik Sense server exists outside of the corporate firewall/network, then it might be necessary to add the IP or host name of the Qlik server to Qlik host whitelist, which enables Qlik engine communication. If this is not done, the Qlik extract test will fail, even if the Qlik connection test is successful.
  • In contrast to Qlik LOAD, which uses QMC API, Qlik Extract technically uses the Qlik engine API to provide data from the Qlik server based on WebSocket technology.

 

image_pdfimage_print