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.
Analytic connections support up to 200 parameters.
The Analytic connections overview lists all the available analytic connections. The following table presents the available fields and buttons. By default, only some of the fields are displayed. You can use the column selector () to add fields.
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 (integer).|
|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|
|ID||ID of the analytic connection.|
|Created||Date and time when the analytic connection was created.|
|Last modified||Date and time when the analytic connection was last modified.|
|Modified by||By whom the analytic connection was modified.|
|<Custom properties>||Custom properties, if any, are listed here.|
Sort the list ascending or descending. Some columns do not support sorting.
Type a string to filter on, or, when available, select a predefined value. All rows that match your filter criteria are displayed. You can filter on multiple columns simultaneously to narrow your search. If a filter is applied to a column, is displayed.
To remove your criteria, click Actions in the table header bar and select Clear filters and search.
You can combine filtering with searching.
Options for clearing filter and search, selecting and deselecting all rows, and toggling wrapping.
Information noteThe option Select all rows is applied to the rows that are currently displayed. Any rows that have been filtered out before selecting all rows are disregarded, even if they were selected. The option Deselect all rows is applied to all rows, including those that were filtered out.
|Column selector: Select which columns to display in the overview. Click to reset to the default columns.|
Search – both basic and more advanced searches.
Refresh the page.
|Edit||Edit the selected connection.|
|Delete||Delete the selected connection.|
|Create new||Create a new connection.|
|Show more||The overview shows a set number of items, by default. To show more items, scroll to the end of the list and click Show more. Searching, sorting, and filtering of items is always done on the full database list of items, not only the items that are displayed.|