I am trying to connect knime to an R Server that my company has. There are two main reasons for this:
I want to be able to make the server do some of the heavy lifting and ETL
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.
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!?