Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Saturday, 22 April 2017

OBIEE 12C Installation in LINUX Step by Steps


Hi Mates - Recently I have done OBIEE 12C installation in linux environment for checking feasibility of Ibots components and it is really awesome experience. Pl refer the below screenshots for reference. You can straightly follow the screenshots and 












Installing OBIEE 12c:











Configuration:




Username: weblogic

Password: welcome1

Schema Prefix: SSIBI

Schema Password: oracle12c

Username: Sys

Password: oracle123






Happy Blogging!!!

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
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

Data Load from Data Sync - BICS


Download mysql-connector-java-5.1.34.bin.jar and com.mysql.jdbc-5.1.5.jar

and place it data sync folder.











Source connection:





If connection fails, paste the data sync path in system properties

Go to view->system properties-> paste the path in Data file root directory,

And click save.



Click test connection



Here in MYSQL I have created a table named book





Then go to projects, in that click Relational Data and click Data from SQL





Give name for the target table and write a select query (e.g.: select * from book)



Then click ok





Go to target tables/Data sets, in that click table columns, you could see the target table columns.





Click run job



Go to jobs and click current jobs.





Click history in jobs



Job successfully completed







Go to object browser in BICS, you would see the target table book1 has been loaded successfully.







SQL Data Definition Language (DDL)


The Data Definition Language (DDL) part of SQL permits database tables to be created or deleted. We can also define indexes (keys), specify links between tables, and impose constraints between database tables. 










The most important DDL statements in SQL are: 


CREATE TABLE - creates a new database table 


ALTER TABLE - alters (changes) a database table 


DROP TABLE - deletes a database table 


CREATE INDEX - creates an index (search key) 


DROP INDEX - deletes an index

SQL Data Manipulation Language (DML)



SQL (Structured Query Language) is a syntax for executing queries. But the SQL language also includes a syntax to update, insert, and delete records.

These query and update commands together form the Data Manipulation Language (DML) part of SQL:




 SELECT - extracts data from a database table 


 UPDATE - updates data in a database table
 

 DELETE - deletes data from a database table
 

 INSERT INTO - inserts new data into a database table

Labels

1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (46) Informatica Online Training (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA 11.1.1.7.1 (1) OBIA 7.9.6.3 (3) OBIA Installation (33) OBIEE (1) OBIEE 10G (8) OBIEE 11G (137) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)