topic Re: How to connect external R server from Qlik sense in Integration, Extension & APIs

How to connect external R server from Qlik sense

pavan045 — Sat, 16 Nov 2024 07:52:59 GMT

Hi All,

I am able to connect to R (which was installed in Qliksense server only) from Qliksense using following Complied version of SSE plug -in.

Compiled Open Source R Plugin (SSE-R-Plugin)

Now I am trying to connect to an external R server from my Qliksense. I tried to use same SSE Plugin and tried to update CONFIG file with external R server and port details, but it is not working. Anyone can point me in the right direction please ?

Re: How to connect external R server from Qlik sense

petter — Mon, 30 Jul 2018 16:31:44 GMT

I guess you have done this?

Have you either restarted or exited and started the Qlik Sense again after the edit?

Re: How to connect external R server from Qlik sense

petter — Mon, 30 Jul 2018 16:32:35 GMT

It might very well be firewall settings that needs to be adjusted by allowing the port-number to get through the firewall of the Qlik Sense computer/server.

Re: How to connect external R server from Qlik sense

yannick_c — Tue, 31 Jul 2018 07:16:23 GMT

Hi Pavan,

For me I am using SSE plugin as a Windows service for Qlik and an external R server.

To connect to the external R server I changed the file SSEtoRserve.exe.config adding the following markup:

            <setting name="rserveHost" serializeAs="String">

                <value>192.168.X.XX</value>

            </setting>

Regards

Re: How to connect external R server from Qlik sense

yannick_c — Tue, 31 Jul 2018 07:25:16 GMT

Where are you using your SSE plugin ? (the same as your Qlik Server or computer, with your R server or external ?)

Can you ping your R server from your computer/server ?

Re: How to connect external R server from Qlik sense

pavan045 — Tue, 31 Jul 2018 08:51:53 GMT

Hi Yannick,

Thank you for your response.

I am actually changing the R hostname in config file to my R server's hostname. whenever I do that and trying to start SSE a CMD window will appear for a 2 seconds and gone. I am able to ping to my R server from my Qliksense server (using R server's hostname) where I am trying setup SSE plugin. Not sure if I can check the connection to exact Rserve port (using Defalut port 6311).

Anything can you think of please ?

Re: How to connect external R server from Qlik sense

yannick_c — Tue, 31 Jul 2018 09:09:58 GMT

Well maybe one of this point is your solution:

SSE plugin config
File config
R Server
Qlik Engine

1. The SSE plugin config

My SSE plugin is running on the Qlik Server, so I didn't change the SSE config as Petter mentionned (I let QMC / Analytic connection / Name : R + Host : localhost + Port 50051)

2. The file config

Sorry I forgot this markup too

<setting name="grpcHost" serializeAs="String">

<value>0.0.0.0</value>

</setting>

EDIT : I did not change this markup

3. The R Server

Can you use telnet on your R server ?

My R server is on CentOS Server with the following command

R CMD R/x86_64-redhat-linux-gnu-library/3.4/Rserve/libs/Rserve --RS-enable-remote --save

--RS-enable-remote is very important

4. The Qlik Engine

You have to run the SSE-Plugin then restart the Qlik Sense Engine Service for the install. Did you do it ?