Configuring analytic connections in Qlik Sense Desktop

With the analytic connections, you can extend the expression framework with support for calling third-party engines. You configure Qlik Sense Desktop to extend the Qlik Sense built-in expression library, both for load script and for chart expressions with external calculation engines.

For Qlik Sense Desktop, the configuration must be done in the Settings.ini file.

Do the following:

1. Open the file Settings.ini.

   For Qlik Sense Desktop it is located in C:/Users/<User ID>/Documents/Qlik/Sense/ or in C:/Users/AppData/Local/Programs/Qlik/Sense/Engine.

   For Qlik Sense it is found in: C:/ProgramData/Qlik/Sense/Engine/.

2. Add the following configuration (note the empty line at the end):

   [Settings 7]
   SSEPlugin=<PluginConfig>[;<PluginConfig>...]
    

Where <PluginConfig> is a comma-separated list of configuration elements containing the following:

<EngineName>,<Address>[,<PathToCertFile>,<RequestTimeout>,<ReconnectTimeout>]

Qlik open source SSE repositories

The following two Qlik SSE repositories are open source:

• https://github.com/qlik-oss/server-side-extension

  Contains the SSE protocol, general documentation, and examples written in Python and C++.

• https://github.com/qlik-oss/sse-r-plugin

  Contains an R-plugin written in C#, only the source code. You must create the plug-in before it can be used.

Description of the elements

<EngineName>: Mapping/alias to the plugin that will be used from within the expressions in the app using the plugin functions, for example, SSEPython for a Python plugin.

<Address>: colon-separated list with two elements, and

• <Host>: DNS name (or IP-adress) of the plugin.

• <Port>: Port on which the plugin listens, typically 50051.

<PathToCertFile>: File system path to folder containing client certificates required for secure communication with the plugin. Optional. If omitted, insecure communication will be invoked. This path just points to the folder where the certificates are located. You have to make sure that they are actually copied to that folder. The names of the three certificate files must be the following: root_cert.pem, sse_client_cert.pem, sse_client_key.pem. Only mutual authentication (server and client authentication) is allowed.

<RequestTimeout>: Integer (seconds). Optional. Default value is 0 (infinite). Timeout for message duration.

<ReconnectTimeout>: Integer (seconds). Optional. Default value is 20 (seconds). Time before the client tries to reconnect to the plugin after the connection to the plugin was lost.

Examples:  

• Example where one SSE plugin server is defined: SSEPlugin=SSEPython,localhost:50051
• Example where two SSE plugin servers are defined: SSEPlugin=SSEPython,localhost:50051;R,localhost:50053
• Example where one SSE plugin server is defined without certificate path but with timeouts set: SSEPlugin=SSEPython,localhost:50051,,0,20