Installing Oracle Analytics Client Tools on Windows

Purpose

This blog post is intended for all the Oracle Analytics Server Administrators, Developers, Data Model designers, DW architects.

Prerequisites

Installation of Oracle Analytics Client Tools 5.5.0 on Windows 64bit

Download the OAS Client Tool

Step 1: Uncompress the downloaded zip file OAS-5.5.0-bi_client-win64.zip use any unzip tool which runs on a Windows machine.

Step 2 : Open a new CMD and 'Run as Administrator' enter the .exe file hit ENTER key

C:\work\data>OAS-5.5.0-bi_client-win64.exe

Step 3: Launches install wizard

Wizard step 2

Wizard step 3

Wizard Step 4

Wizard Step 5

Wizard Step 6 (Development of RPD or online RPD connections required this configuraiton)

Wizard Optional Step "Add" ODBC configuration Select "Oracle BI Server DSN Configuration" is specific to your Datasource to which you have target to use, stored as Data.Source.. (This step is must for Design Data Model and Develop new RPD files)

Troubleshooting

If you run the installer from regular double click it will throws error as:

you can fix the above issue as suggested in the error message run as Administrator command line.

Advanced Analytics on OAS with R, R-packages

Installing R and R Packages on OAS 5.5.0

The main objective of this post is to give step-by-step "Installing of R and R-Packages" in an Oracle Analytics Server (OAS) 5.5.0. Similar steps were followed earlier on OBIEE environments as well.
Here I have the target installing platform is "Oracle Linux" same steps will work for all RHEL flavors.

What is R?

R is open-source programming language and it is specially designed as scripting environment for statistical computing and Visualization graphics. R programming evolving since 1994, as an alternative to SAS, SPSS, and other proprietary Statistical environments. 

R Environments with a rich set of packages to enhance productivity in businesses such as : 

• Spatial Statistics 
• Financial Market analysis 
• Bioinformatics 
• Social Network analysis

What is the purpose of this installation?

In the data Analytics, there is huge scope for external Logical SQL functions such as "EVALUATE_SCRIPT", "FORECAST", and "CLUSTER" feed input data to the standalone R-process or to Oracle R Enterprise. To use such powerful advanced analytics function, we must install either the R or Oracle R Enterprise external engine in your environment. Here is my story Oracle Analytics using R for Advanced Analytics. 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 as a data miner helps the Business to formulate strategies and plan in advance for the possible road blockers. statistical models and quantitative analysis sits at the core of data science and measures past performance to predict the future.

Pre-requisites

* Locate the 'Rinstaller' folder in the OAS isntalll directory within the given path: /bifoundation/advanced_analytics/r-installer.zip
For example on my VM:

/u01/fmw/bi/bifoundation/advanced_analytics/r-installer.zip

This r-installer.zip (R installer distribution) will be supporting Oracle Linux 6 and 7.x versions and also Windows versions.

unzip r-installer.zip -d /tmp/
cd /tmp/Rinstaller

After extraction, You can follow README.txt file.

Install of R 3.1.1 on Linux platform

The R installer needs to run from the root user.
Step 1: Set your proxy URL (specific to your company if exists) in the proxy.txt file. For example proxy.txt content as: proxy=http://www-proxy-company-url:80
Step 2: install the TexLive and TexInfo RPMs You can locate the rpm installers at : http://download.mostlylinux.com/7.0/x86_64/os/Packages/st/?C=S;O=A texlive-epsf-svn21461.2.7.4-32.el7.noarch.rpm and texinfo-tex-5.1-4.el7.x86_64.rpm
Confirm that required OL packages are (already exists in the Tex library path) installed.

[root@localhost tex-rpms]# rpm -qa | grep -i texinfo-tex
texinfo-tex-5.1-5.el7.x86_64

[root@localhost tex-rpms]#  rpm -qa | grep -i texlive-epsf
texlive-epsf-svn21461.2.7.4-45.el7.noarch

If not installed try with the latest versions:

rpm -ivh texlive-epsf-svn21461.2.7.4.32.el7.noarch.rpm
rpm -ivh texinfo-tex-5.1-4.el7.x86_64.rpm

Step 3: Install R 3.1.1 Check the Usage options for RInstaller:

./RInstaller.sh
Usage ./RInstaller { install | installpackages | uninstall }

Let's run install command option

./RInstaller.sh install
respond to Y/n with y

You could see last screen ends as :

Installed:
  R.x86_64 0:3.1.1-2.el7

Dependency Installed:
  R-core.x86_64 0:3.1.1-2.el7   R-devel.x86_64 0:3.1.1-2.el7   libRmath.x86_64 0:3.1.1-2.el7   libRmath-devel.x86_64 0:3.1.1-2.el7

Complete!
################# Install of R 3.1.1 ...successful ######################

Step 4: Install R dependent packages for Advanced Analytics along with the OASAdvancedAnalytics R package

./RInstaller.sh installpackages
Do you want to continue (y/n)y

And at the end of the installation, you could see

#################  R Dependency Package Install Complete ######################

Further readings: 

1. Oracle R engine downloads
2. Installing R and R packages for Exernal logics for SQL functions

References: 

1. A Perfect Storm Oracle Big Data science for enterprise R
2. Oracle R enterprise server configuration