With analytic connections you are able to integrate external analysis with your business discovery. Server-side extensions (SSE) can be used to extend the expression framework with support for calling third-party engines. You can configure a server-side extension to extend the built-in expression library, both for load script and for chart expressions with external calculation engines.
Creating an analytic connection
For both QlikView Desktop and QlikView Server (QVS) , analytic connections are configured by editing the Settings.ini
QlikView Server must be stopped before editing the Settings.ini file.
After adding new connections or changing existing connections, a restart is required for the changes to take effect.
Do the following:
- Open the file Settings.ini.
For QlikView Desktop it is located in C:\Users\username\AppData\Roaming\QlikTech\QlikView.
For QlikView Server it is located in C:\ProgramData\QlikTech\QlikViewServer.
Add the following configuration:
Where <PluginConfig> is a comma-separated list of configuration elements containing the following:
|<EngineName>||Name of the analytic connection. Must be unique. This is the mapping/alias to the plugin that will be used from within the expressions in the app. <EngineName> is required to use the plugin functions. For example, SSEPython for a Python plugin or R for an R plugin.|
Colon-separated list with two elements:
<Host>: DNS name (or IP-adress) of the plugin.
<Port>: Port on which the plugin listens.
|<PathToCertFile>||File system path to the folder containing client certificates required for secure communication with the plugin. 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.
Note: It is optional to set the certificate file path, but, if omitted, insecure communication will be invoked.
|<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.|
- After saving the changes in the Settings.ini file, restart QlikView. Now you can use the analytic connection by adding it through the Edit Expression dialog or the Load Script dialog.
Restrictions in using Analytic connections
Analytic connection functionality (configuring a server-side extension) is disabled when creating a new shared server object.
When an existing sheet object containing a server-side extension (SSE) expression is copied, the chart property editor is automatically disabled. This means that the chart properties are no longer editable.
The following examples show how to set a server-side extension (SSE) plugin. Here, a Python plugin is used and one or multiple servers are defined.
- One SSE plugin server: SSEPlugin=SSEPython,localhost:50051
- Two SSE plugin servers: SSEPlugin=SSEPython,localhost:50051;R,localhost:50053
- One SSE plugin server is defined without certificate path but with timeouts set: SSEPlugin=SSEPython,localhost:50051,,0,20