Spotfire Statistics Server Configuring with Open Source R

Before Downloading and Installing the R Open Source Engine on the machine, check for the Tibco Spotfire Statistics Requirements.

http://support.spotfire.com/sr_statservices70.asp



For Spotfire 6.5 Version, the highest supported version is 3.1.2.

Now we can go ahead and install R 3.1.2 from the Cran R project site

http://cran.r-project.org/bin/windows/base/old/3.1.2/


Steps:
- Install Tibco Statistics Server 6.5 (64 bit) on Server with engine as SPLUS or  TERR
- Install 64 bit Java JRE (jre1.8.0_45) on Statistics server machine.
- Run the below command from R console
     install.packages("rJava")

   R console location: [R location]\R-3.1.2\bin\x64

-  To verify whether rJava is successfully installed or not, run the below command and it shouldn't return any error message
  library(rJava)



 - Now, navigate to the folder [Tibco Statistics Server path]\statsvcs65\SplusServer\conf. 

 ex:-  C:\Program Files\TIBCO\statsvcs65\SplusServer\conf

- Open spserver.properties and look for engine.type and update the value to R.
     engine.type=R

- Now open the Command prompt using Run as Administration and go to Tibco Statistics Server bin location and run the command 
           TSSS65SplusServerw//ES/TSSS65SplusServer

 

- Then you would get below prompt window and Stop the service.





 - Go to Java -> Java Options and Add below entry to the list
         -Dspserver.rhome=C:\Program Files\R\R-3.0.2



 
 - Apply the changes and start the service

These are the settings/steps from Server side.


Now open the Spotfire Professional and go to Administrator Manager-> Preferences. Click on Everyone Group and give the Statistics server details accordingly as below.


 



 


Now we are all set to use R open :) 

PS: Try to test by writing some basic R scripts and run the same.