topic Re: How to enable R integration on Qlik Sense Enterprise with several nodes in Integration, Extension & APIs

How to enable R integration on Qlik Sense Enterprise with several nodes

PoojaPrasad — Sat, 16 Nov 2024 04:52:19 GMT

Hello Experts,

We are trying to integrate R with Qlik Sense Enterprise having several nodes. We have installed R, Rserve, and SSEtoRserve on a separate server. Rserve and SSEtoRserve is running on that server. Our objective is to install R, Rserve and SSEtoRserve and keep them up and running on one server and access that server by giving its name rather than localhost while adding 'Analytics Connection' on Qlik QMC.

After the installation, when I am trying to check the decision tree app and other apps provided on https://github.com/qlik-oss/sse-r-plugin, I do not see any of them working. Please note I have imported both extensions given in the link on the Qlik.

I am wondering if we can achieve integrating R with Qlik Sense Enterprise with several nodes by redirecting them to a server with R, Rserve and SSEtoRserve up and running. If not, what could be the right way to integrate them with R.

Re: How to enable R integration on Qlik Sense Enterprise with several nodes

Anonymous — Thu, 29 Aug 2019 11:56:48 GMT

in the SSEtoRserve.exe.config you can define where your R Server is running. Default is 127.0.0.1 Port 6311(localhost)

So for multinode environments you have two deployment options:

- Install the SSEtoRserve Plugin on every Engine-Node. Change the SSEtoRserve.exe.config so they all point to the remote RServer

- Install the SSEtoRServe on the same Server as the RServer. Then you can keep the Default SSEtoRserve.exe.config. Instead you change the Analytic Connection in the Qlik Sense QMC from http://localhost:50051 to http://yourRServer:50051

Best regards,

Roland

Re: How to enable R integration on Qlik Sense Enterprise with several nodes

PoojaPrasad — Thu, 29 Aug 2019 17:24:02 GMT

Hello Roland,

Thank you for your response. We are trying to implement the second option you gave:

We have R, Rserve and SSEtoRServe on a virtual machine. Rserve and SSEtoRServe is running on that virtual machine server. We have given its name in the Analytics Connection in Qlik Sense QMC as shown below:

We have also restarted the Qlik Engine service.

But we still dont see R packages working on the app, not even on the central node of the Enterprise. I was wondering how to confirm if Qlik Enterprise is even able to connect to the vm server.

Thank you for your help.

Re: How to enable R integration on Qlik Sense Enterprise with several nodes

Anonymous — Fri, 30 Aug 2019 07:40:15 GMT

Have you sest "grpcHost" to 0.0.0.0 to make the SSEPlugin reachable from the outside world?

Re: How to enable R integration on Qlik Sense Enterprise with several nodes

Anonymous — Fri, 30 Aug 2019 07:44:08 GMT

once you did that you can check if Telnet or PowerShell can reach the Service on port 50051

https://www.techtutsonline.com/powershell-alternative-telnet-command/

Re: How to enable R integration on Qlik Sense Enterprise with several nodes

PoojaPrasad — Fri, 30 Aug 2019 20:28:24 GMT

I set the "grpcHost" to 0.0.0.0 to make the SSEPlugin and its working for all the nodes. Thank you so much. 🙂

Re: How to enable R integration on Qlik Sense Enterprise with several nodes

chris-s — Wed, 05 Apr 2023 09:05:45 GMT

Sorry to revive this post. If you want to use client-server certificate authentication for a secure connection, where you you have to place the folder with the three certificates? On each node or just the central node? I'm asking, because you can just configure one general path in the QMC.

Chris