Como executar script python no Qliksense Server

[msludo]

Boa tarde,

Tenho um script python que faz um tratamento de dados e gera um dataframe como resultado final e eu queria usar esse dataframe no qliksense. Mas queria deixar isso de forma automatica para ser executado diariamente. É possível executar script python dentro do qliksense server?

[fernando_tonial · Accepted solution]

Olá, é possível utilizando o SSE (Server-side Extension).

Aqui tem alguns exemplos de como fazer funcionar essas conexões analíticas.

GitHub - qlik-oss/server-side-extension: A Qlik server-side extension protocol for extending the Qli...

Segue algumas informações retiradas do site acima.

Configuring SSE plugins in Qlik

Qlik Sense

You must configure SSE plugins, referred to by Qlik as analytic connections, in the Qlik Management Console (QMC), in the settings.ini file or using the Qlik Repository Service API.

For an overview of analytic connections, see Analytic connections in the Qlik Sense Developers help.

For instructions of adding a new SSE plugin in QMC, see Creating an analytic connection in the Qlik Sense help.

For information about SSE plugins for Qlik Sense Desktop, see Configuring analytic connections in Qlik Sense Desktop in the Qlik Sense help.

Qlik Sense Enterprise

1. Install Qlik Sense Enterprise (June 2017 release or later).

2. Make sure you have Python 3.4 (or later) installed as well as the grpcio package. For more information, see Prerequisites for running the Python examples.

3. Add the SSE plugin settings in QMC under Analytic connections by inserting the following values: name: <EngineName>, host: localhost, port: <port>

   Alternatively, add SSEPlugin=<EngineName>,localhost:<port> on a new line in your settings.ini file located at C:\ProgramData\Qlik\Sense. Insert the values for <EngineName> and <port> from the table above for the selected example.

   Note: Configuring the plugin via the settings.ini file is only valid for this node/machine; the settings will not be visible in the QMC. Also no access rules would apply in this case.
   Note: If you are using Sense April 2018, you can configure your plugins in QMC during runtime without having to restart Qlik engine in step 6 below. See Limitations for more details.

4. Add the .qvf file from the selected example folder to QMC.

5. Run the corresponding <examplename> python package. The easiest way to do this is to open a command prompt, go to the example\python folder and type:

   python <examplename>

   Insert the value for <examplename> from the table above for the selected example.

6. Start Qlik Sense Enterprise and open the app for the example you chose.

Don't worry, be Qlik.
Tonial