Connecting Sisense to R Server

[intapiuser]

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

https://rforge.net/Rserve/doc.html#inst

https://cran.r-project.org/web/packages/Rserve/index.html

https://docs.sisense.com/main/SisenseLinux/using-r-in-formulas.htm

http://qu-c.com/blogs/install-r-server-on-aws/setup-security-for-r-server