The knowledge-base contains an excellent instruction for the integration of R into the ETL ( Integration-Management ).
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);