R Installation


Related link: R Installation of External Packages, Transform R Script

The following steps have to be performed to use the R Integration.
These explanations are for Windows. For Linux analog steps have to be performed.

1.) Installation of R:

Download of R from http://www.r-project.org/ for platform Windows or Linux. The most recent tested release is R 3.0.3.
(Link for Windows: https://cran.r-project.org/bin/windows/base/).
Start the Installer. The installation of R has to be done on the same system as the Jedox Suite.
During the R installation you can select both, 32-bit and 64-bit files, or only the 32-bit files (if you run Jedox Suite on 32-bit) or only the 64-bit files (if you run Jedox Suite on 64-bit).

2.) Installation of R-package rJava (R to Java interface):

Start the R console.
Enter in the R console:
Choose a CRAN mirror.
Note: If you get an Error message on insufficient authorizations you have to start the R console as an administrator.
In case the installation failed with the steps above:
Download from http://www.rforge.net/rJava/files/ the Windows binary according to the R version (File rJava*.zip).
Start the R console
Enter in the R console:
Answer the question “Would you like to use a personal library instead?” with “No” (if it shows up).
In the File Picker choose the downloaded file rJava*.zip.

3.) System environment variables:

Set the System environment variable R_HOME to the R-installation directory e.g.
R_HOME=C:\Program Files\R\R-2.15.3
Add the path to the R-executable to the System environment variable PATH.
For 32-bit Tomcat e.g. : C:\Program Files\R\R-2.15.3\bin\i386
For 64-bit Tomcat e.g. : C:\Program Files\R\R-2.15.3\bin\x64
Note: You must not use the path C:\Program Files\R\R-2.15.3\bin.

4.) Changes in Jedox Integrator (This is already done by Jedox Setup):

Verify that in file \tomcat\bin\setenv.bat the line starting with set Library_Path:
* For 32-bit Tomcat: set Library_Path=%R_HOME%\library\rJava\jri\i386
* For 64-bit Tomcat: set Library_Path=%R_HOME%\library\rJava\jri\x64
Note: if you need to define several directories for the “Library_Path” setting, the entries are separated by the character sequence <single quote><semicolon><single_quote>, as follows: ‘;’
set 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.



Was this post helpful?
NoYes (-7 rating, 7 votes)