Jedox ETL: Integration of R and R-Studio

The knowledge-base contains an excellent instruction for the integration of R into the ETL ( Integration-Management ).

R Installation

But unfortunately there is one major step missing. You have to run the R-Console for the installation of rJava as Administrator, otherwise the library path would be set incorrect!

Change the file \Jedox\Jedox Suite\tomcat\bin\setenv.bat with this line: (yes, the quotation-mark syntax below is right!)

set Library_Path=%R_HOME%\library\rJava\jri\x64';'C:\Program Files (x86)\Jedox\Jedox Suite\tomcat\webapps\etlserver\WEB-INF\lib\auth\x64

After the change of the serenv.bat, please do not restart the JedoxTomcatService. This is not enough. You have to reinstall the servive by executing these files: (both as Administrator!)

• \Jedox\Jedox Suite\tomcat\bin\serviceRemove.bat
• \Jedox\Jedox Suite\tomcat\bin\serviceInstall.bat

With this groovy-job, you can check the installation: (Everything in the job-Monitor should be ‚green‘

import com.jedox.etl.core.util.FileUtil;
model="64";
String rPath=new File(System.getenv("R_HOME")).getCanonicalPath();
LOG.info("rPath: "+rPath);
String jriPath = FileUtil.convertPath(rPath + "/library/rJava/jri/" + (model.equals("32") ? "i386" : "x64"));
LOG.info("jriPath: "+jriPath);
if (!FileUtil.fileExists(FileUtil.convertPath(jriPath+"/jri.dll")))
    LOG.error("The "+model+"-bit rJava package is not installed correctly. Missing file jri.dll in "+jriPath);
else 
   LOG.info("OK");

String lib = System.getProperty("java.library.path");
LOG.info(lib);
if (System.getProperty("java.library.path").indexOf(jriPath)==-1)
    LOG.error("The java.library.path does not include the path to the rJava package: "+jriPath);

Werbeanzeigen