Analytic connections

借助分析连接,您将能够将外部分析与商业探索集成。分析连接扩展您可在加载脚本和图表中使用的表达式,方法是调用外部计算引擎(当您如此操作时,计算引擎用作服务器端扩展 (SSE))。例如,您可创建指向 R 的分析连接,并在加载数据时使用统计表达式。

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.

备注: 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.

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.

备注: 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.

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.

Searching and filtering in the QMC


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

备注: 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.
' Column selector: Select which columns to display in the overview. Click B to reset to the default columns.

Search – both basic and more advanced searches.

Searching and filtering in the QMC


Refresh the page.

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