Oracle BICS Architecture

BUSINESS INTELLIGENCE CLOUD SERVICE ARCHITECTURE

Any users required guidance and discover the right questions by using the analytic and this type of analytic required reach and quality data and the very important is richness in the functionality to solve the hard questions.
 

Flexibility and functionality to view analytic is given by cloud Oracle BICS. Below is architecture of BICS.

Oracle BICS Architecture

The Business Intelligence Cloud Service and Data Sync supports the load of on-premises data residing in one or more relational or comma-separated value file sources into the schema provisioned on the Oracle Business Intelligence Cloud Service.

PRE-REQUISITES for DATA SYNC:

Requirements Before installing, you must have the Java 1.7 or later version of Java Developer Kit (JDK). On an on-going basis, any critical updates specific to this version of Java should always be applied.

DATABASE SUPPORT:

Business Intelligence Cloud Service Data Sync supports the following databases:
Oracle (source and target)
Microsoft SQL Server (source and target)
DB2 (source and target)
Teradata (source and target)
MySQL (source only)
Oracle TimesTen (source and target)

SETTING UP THE SOFTWARE

To set up the software, copy the BICSDataSync.Zip file to an installation directory with no spaces in its name, and unzip the files.

Setting the Java Home:

Depending on your operating system, edit either the config.bat or config.sh file, modifying the line that sets the JAVA_HOME. Replace the @JAVA_HOME with the directory where the JDK is installed.

For example, on Windows:

Set JAVA_HOME=D: \Java

For example, on UNIX:

JAVA_HOME=usr/jav