Knowledge Base Article

Connecting Sisense to R Server

Problem
You want to establish the connection between Sisense server console to the R server.
Solution

Installing Rserve

  • Open an R console window.
  • Run the command prompt:
> install.packages("Rserve")

Running Rserve

  • Open an R console window.
  • Load the Rserve Package into R.
> library("Rserve")
  • Setup the environment.
> Rserve()
  • Open the Sisense server Console from the start menu.
  • Click on the Server preference icon to open the server settings.
  • In the Rserver field, enter the IP address of your R server, and select the checkbox to enable the connection.
Test the connection by clicking on the Test button.
The default Rserve port is 6311, make sure it is accessible (Test by telnet command) if necessary.

Windows users: Running Rserve automatically every time you start windows

Rserve is a stand -alone program so it can be started directly as well.
  • Search for "Rserve.exe" file and click copy.
  • Paste "Rserver.exe" file into "C:\Program Files\R\R-3.2.4revised\bin\x64"
  • Create "Short cut" to the "C:\Program Files\R\R-3.2.4revised\bin\x64\Rserve.exe" file.
  • Paste the "Short cut" Rserve.exe in the Startup folder(Path: "%appdata%\Microsoft\Windows\Start Menu\Programs\Startup")
Discussion
Rserve acts as a socket server (TCP/IP or local sockets) which allows binary requests to be sent to R from various languages without the need to initialize R.
References
Updated 02-07-2024
No CommentsBe the first to comment