Creating an analytic connection
With analytic connections you are able to integrate external analysis with your business discovery. An analytic connection extends the expressions you can use in load scripts and charts by calling an external calculation engine (when you do this, the calculation engine acts as a server-side extension (SSE)). For example, you could create an analytic connection to R, and use statistical expressions when you load the data.
Do the following:
Open the QMC: https://<QPS server name>/qmc
If you have more than one server, use the central server.
Select Analytic connections on the QMC start page or from the Start drop-down menu to display the overview.
Click Create new in the action bar.
Edit the properties.
Identification properties Property Description Name
Name of the analytic connection. Must be unique and must not start with numbers. 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 or R for an R plugin.
Host of the analytic connection, for example, localhost if on the same machine or mymachinename.qlik.com if located on another machine.
Port Port to use when connecting. Certificate file path
The full path to the certificate: C:\ProgramData\Qlik\Sense\Repository\Exported Certificates\<server name>. The path should point to the folder containing both the client and server certificates and keys. 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.Information noteIt is optional to set the certificate file path, but the connection is insecure without a path.
Reconnect timeout (seconds) Default value: 20 Request timeout (seconds) Default value: 0
Custom propertiesInformation noteIf no custom properties are available, this property group is not displayed at all (or displayed but empty) and you must make a custom property available for this resource type before it will be displayed here.
Click Apply in the action bar to create and save the analytic connection.Information noteSuccessfully added is displayed at the bottom of the page.