Skip to main content

Analytic connections

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.

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 (Table) to add fields.

Note: For the Analytic connections to appear on the start page, it is a prerequisite that the virtual proxy used for accessing the QMC has a load balancing server. On the Edit virtual proxy page, under Load balancing, make sure that there is a server node for load balancing.
Analytic connection properties
Property Description

Name of the analytic connection. Must be unique. 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 if located on another machine.

Port Port to use when connecting (integer).
Certificate file path

The full path to the certificate. 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.

Note: It 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.
Arrow down Arrow up

Sort the list ascending or descending. Some columns do not support sorting.

Filter container

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, Filter container 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.

Searching and filtering in the QMC


Options for clearing filter and search, selecting and deselecting all rows, and toggling wrapping.

Note: The 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.
Table Column selector: Select which columns to display in the overview. Click Undo to reset to the default columns.

Search – both basic and more advanced searches.

Searching and filtering in the QMC

Dimension - Cyclic

Refresh the page.

Edit Edit the selected connection.
Delete Delete the selected connection.
Create new 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.