7 Installing R and Oracle R Enterprise for External Logical SQL Functions
The external Logical SQL functions such as EVALUATE_SCRIPT, FORECAST, and CLUSTER feed input data to the standalone R-process or to Oracle R Enterprise. Therefore, to create analyses that include these functions, you must install either the R or Oracle R Enterprise external engine in your environment.
R is a widely used environment for statistical computing and graphics and can be used with many different data sources including external files or databases. Oracle R Enterprise is installed specifically for use with the Oracle Database, and makes the open source R statistical programming language and environment ready for use by Oracle BI EE.
See Advanced Analytics External Logical SQL Functions in User's Guide for Oracle Business Intelligence Enterprise Edition for more information about using these functions in analyses.
- Installing R and R Packages
To create analyses using the advanced analytics external Logical SQL functions, you must install R and the required R packages. - Installing Oracle R Enterprise and Required R Packages on the Oracle Database
Oracle BI EE uses the R engine included in Oracle R Enterprise instead of R. Oracle BI EE can use the Oracle R Enterprise colocation option, where the data can reside in the Oracle R Enterprise database. (In the non-colocation option, the data does not reside in the Oracle R Enterprise database.)
Installing R and R Packages
To create analyses using the advanced analytics external Logical SQL functions, you must install R and the required R packages.
If you are using Oracle Database, then see Installing Oracle R Enterprise and Required R Packages on the Oracle Database for more information.
- Before You Begin the Installation
You need to install the 3.1.1 R version distributed with Oracle BI. - Installing R and R Packages on Linux Platforms
Use the procedures in this section to install R and the R packages on Linux platforms. - Installing R and R Packages on Windows
Use the procedures in this section to install R and the R packages on Windows.
Before You Begin the Installation
You need to install the 3.1.1 R version distributed with Oracle BI.
You can find the R installer in the following Oracle BI environment location:
ORACLE_HOME/bi/bifoundation/advanced_analytics/r-installer.zip
The distributed R installation supports Linux (OLE 6 and OLE 7) and Windows (7 and 8).
Parent topic: Installing R and R Packages
Installing R and R Packages on Linux Platforms
Use the procedures in this section to install R and the R packages on Linux platforms.
See Before You Begin the Installation for general prerequisite information.
Before you perform the installation, note the following important information and required tasks:
-
Run
RInstaller.sh
as root or using the sudo command. See theREADME.txt
that is included inr-installer.zip
for more information. -
Locate
proxy.txt
in the RInstaller directory and edit it to include the proxy server details. -
For OLE 7, before you install the Oracle R distribution, you need to install the TexLive and TexInfo RPMs.
-
The required RPM versions are:
texlive-epsf-svn21461.2.7.4-32.el7.noarch.rpm
andtexinfo-tex-5.1-4.el7.x86_64.rpm
. -
Download the RPMs and install them using
rpm -ivh <rpm_name>
. -
You must install the RPMs in this specific order:
texlive
and thentexinfo
.
-
To Install R on Linux Platforms:
Note:
You must run the RInstaller in the following operation as a Root user.Open a command line, navigate to the installer's location, and enter the following to decompress and run the distributed R installer:
bash-4.1$ unzip r-installer.zip
bash-4.1$ cd RInstaller
bash-4.1$ ./RInstaller.sh
Usage ./RInstaller { install | installpackages | uninstall }
bash-4.1$ sudo ./RInstaller.sh install
To Install R Packages on Linux Platforms
For Linux platforms, after you have installed R, then from the same command line, run the following command to download and install the required R packages (forecast, randomForest, RJSONIO, and matrixcalc). Running this command also installs the OBIEEAdvancedAnalytics R package. The installer uses the proxy information from proxy.txt
to download the packages from CRAN.
bash-4.1$ sudo ./RInstaller.sh installpackages
Parent topic: Installing R and R Packages
Installing R and R Packages on Windows
Use the procedures in this section to install R and the R packages on Windows.
See Before You Begin the Installation for general prerequisite information.
Before you perform the installation, locate the proxy.txt
file in the RInstaller directory and edit it to include the proxy server details.
Parent topic: Installing R and R Packages
To Install R Packages on Windows:
After you have installed R, then from the same command line, run the following command to download and install the required R packages (forecast, randomForest, RJSONIO, and matrixcalc). Running this command also installs the OBIEEAdvancedAnalytics R package.
.\RInstaller.bat installpackages
Installing Oracle R Enterprise and Required R Packages on the Oracle Database
Oracle BI EE uses the R engine included in Oracle R Enterprise instead of R. Oracle BI EE can use the Oracle R Enterprise colocation option, where the data can reside in the Oracle R Enterprise database. (In the non-colocation option, the data does not reside in the Oracle R Enterprise database.)
See Before You Begin the Installation. If you are using databases other than the Oracle Database, then see Installing R and R Packages.
- Before You Begin the Installation
Oracle BI EE requires that you install Oracle R Enterprise version 1.4 or 1.4.1. - Installing Oracle R Enterprise and R Packages
Use the procedures in this section to install Oracle R Enterprise 1.4.1 on the Oracle database and to install the required R packages on Oracle R Enterprise. - Configuring Oracle R Enterprise to Work with Oracle BI EE
After you have installed Oracle R Enterprise and the R Packages, the next step is to configure Oracle R Enterprise.
Before You Begin the Installation
Oracle BI EE requires that you install Oracle R Enterprise version 1.4 or 1.4.1.
Table 7-1 ORE Configuration and Support Matrix
Oracle R Enterprise Version | Oracle R Enterprise Distributed R Version | Oracle Database Version |
---|---|---|
1.4 |
3.0.1 3.1.1 |
11.2.0.3 11.2.0.4 12.1.0.1 |
1.4.1 |
3.0.1 3.1.1 |
11.2.0.3 11.2.0.4 12.1.0.1 |
Installing Oracle R Enterprise and R Packages
Use the procedures in this section to install Oracle R Enterprise 1.4.1 on the Oracle database and to install the required R packages on Oracle R Enterprise.
To Install Oracle R Enterprise on the Database
A sample user such as ruser or rqueser is used for R Execution on the database.
To install Oracle R Enterprise 1.4.1 on the database, follow the installation instructions in Oracle R Enterprise Installation and Administration Guide, Release 1.4.1.
For information about the steps in a typical installation of Oracle R Enterprise on a Linux server and a Windows client, see A Sample Installation of Oracle R Enterprise in Oracle R Enterprise Installation and Administration Guide.
To Install R Packages on Oracle R Enterprise