Analytic connections

通过分析连接,您能够将外部分析与自己的商业探索集成。服务器端扩展 (SSE) 可用于通过对第三方引擎的调用的支持来扩展表达式框架。您可为加载脚本以及图表表达式配置服务器端扩展,以通过外部计算引擎扩展内置表达式库。

Creating an analytic connection

For both QlikView Desktop and QlikView Server (QVS) , analytic connections are configured by editing the Settings.ini

备注: QlikView Desktop must be closed before editing the Settings.ini file.
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.
备注: Note that the server-side extension (SSE) plugin server must be running before you start QlikView otherwise the connection will not be established.

执行以下操作:

  1. 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.
  2. Add the following configuration:

    [Settings 7]
    SSEPlugin=<PluginConfig>[;<PluginConfig>...]

    Where <PluginConfig> is a comma-separated list of configuration elements containing the following:

    <EngineName>,<Address>[,<PathToCertFile>,<RequestTimeout>,<ReconnectTimeout>]

 

属性 说明
<EngineName> 分析连接的名称。必须为唯一。这是将在应用程序中使用的插件的映射/别名。要使用插件功能,必须有 <EngineName>。例如 SSEPython 用于 Python 插件,或者 R 用于 R 插件。
<Address>

带两个元素的冒号分隔的列表:

<Host>:插件的 DNS 名称(或 IP 地址)。

<Port>:插件在其上进行监听的端口。

<PathToCertFile> 包含客户端证书的文件夹的文件系统路径,与插件进行安全通信需要使用此证书。该路径直接指向证书所在的文件夹。您必须确保将它们实际复制到该文件夹。三个证书的名称必须如下:root_cert.pemsse_client_cert.pemsse_client_key.pem。仅允许相互认证(服务器和客户端认证)。
备注: 可选择设置证书文件路径,但是如果省略该步骤,则会造成不安全通信。
<RequestTimeout> 整数(秒)。可选。默认值为 0(无限)。消息持续时间超时。
<ReconnectTimeout> 整数(秒)。可选。默认值为 20(秒)。在指向插件的连接丢失后,客户端尝试重新连接至插件的时间。
  1. 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.

Examples

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