Connecting to R Server

[emilioalvarez]

Hello,

I am trying to connect knime to an R Server that my company has. There are two main reasons for this:

1. I want to be able to make the server do some of the heavy lifting and ETL
2. I would ideally like to connect that to a Knime server in the future, but first need to check how to connect it to my local version.

I figure I need to point knime to the R Server, but I am unsure how to do that given that it is an enterprise instance of the R Server provided by R Studio.

Any help/direction is appreciated!

Emilio

[mlauber71]

That is actually a pretty good question. What I found was that @stoeter wrote an entry about such a connection:

How to connect R remote(KNIME) and R server under Windows environment

Hi Rajendra, if you want to use the Scripting Integration nodes and Rserve, then follow the URL in the help of the node descrition: https://github.com/knime-mpicbg/knime-scripting/wiki/R-server-for-knime (I agree, this documentation needs some update/clarification... it is on our to do list...) In brief: on your windows machine: - install KNIME, Scripting Integration nodes and R/R-Rstudio - install and start Rserve (in R:  install.packages("Rserve"); library(Rserve); Rserve(args='--vanill…

He references this page but mentioned it could be tricky:

knime-mpicbg/knime-scripting

And that was some time ago. From what I understand these components would be necessary:

• Prepare the server with some sort of .sh script to accept commands for the command line (I might be wrong about that)
• use the Rserve package (on the R Server) but tell it to accept remote connections like (–vanilla --RS-enable-remote)

These are just some quick ideas. Maybe someone from KNIME might know more. I have used R and KNIME from a local installation only.

[stoeter]

Hi Emilo,

If you want to use an R server and the Rserve package you can use the R nodes from the Scripting Integration community nodes for KNIME. However it could be that the enterprise R Server of R-Studio works differently and the connection via that Rserve package doesnt work.

Anyway, please follow the links of mlauber71 to set up the local R server, in brief:

• install R/R-Studio and Scripting Integration nodes (Community nodes) in KNIME
• install Rserve package (from R version 3.5 this is more complex that ealier versions, but it is explained if you follow the links…)
• set in KNIME preferences (R-scripting the server to localhost)

The easiest way to check the connection is to use the R snipptet node with an input of a simple table and just execute without any further configuration/script. Then the table will be sent to the R server and comes back. It that works the connection is fine, and the rest is just R scripting…

Once the local R server works just change the R server name in the preferences to the remote (enterprise) R Server name or IP-adresss and check the connection. Maybe you need to verify the port!?

Good luck!

Martin