R is a free software environment for statistical computing and graphics, and it is compatible with Jedox software. The R installation process allows you to perform R integration on Windows and Linux systems. The most recent tested release is R-3.5.1.
Note: Linux installation is very similar to Windows installation, but may differ depending on the flavor of Linux that is running.
- Download of R for all platforms from http://www.r-project.org/. For Windows specifically, you can also go to https://cran.r-project.org/bin/windows/base/. For both Windows and Linux, select the 64-bit option.
- Start the installer. The installation of R must be done on the same system as the Jedox Suite. Note that for Linux installation, the R package must be installed in changeroot (chroot).
Installing R-package rJava (R to Java interface)
- Start the R console as an administrator and enter the command
install.packages('rJava').If you do not start the R console as an administrator, you may get an error message regarding insufficient authorization.
- Choose a CRAN mirror.
If the installation cannot be performed as above, try performing the following steps.
- Download the Windows binary corresponding to the R version (the file
rJava*.zip) from http://www.rforge.net/rJava/files/.
- Start the R console.
- In the R console, enter
- A message is displayed, asking if you would like to use a personal library instead. Select No.
- In the File Picker, choose the downloaded file
Setting the system environment variables
- Set the system environment variable
R_HOME=C:\Program Files\R\R-2.15.3(Windows) or
- Add the path to the R executable to the system environment variable path. For example, in a 64-bit Tomcat installation on Windows, the path may be
C:\Program Files\R\R-2.15.3\bin\x64. A Linux path is similar, and varies based on the flavor of Linux in use.
Changes in Jedox Integrator (already done by Jedox Setup)
Windows: in the file
\tomcat\bin\setenv.bat, verify that the line starting with set
Library_Path looks like
Linux: in the file
/opt/jedox/ps/tomcat-etl/setenv.sh, add the line
If you need to define several directories for the
Library_Path setting, the entries are separated by the character sequence
Library_Path=%R_HOME%\library\rJava\jri\x64';'C:\Program Files (x86)\Jedox\Jedox Suite\tomcat\webapps\etlserver\WEB-INF\lib\auth\x64
The Jedox Tomcat Service has to be removed and started again.