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> 才能使用外掛程式功能。例如,Python 外掛程式的 SSEPython 或 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