In Oracle : OBIEE architecture ( 11g )

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle Data Warehouse & BI

In-Oracle.com  -> Oracle Data Warehouse & BI  -> Oracle Business Intelligence (BI)

-> OBIEE architecture

 

OBIEE architecture (11g)  

 

Here is an image showing the OBIEE architecture:

OBIEE architecture

OBIEE architecture ( 11g )

 

As you can see we have 2 main databases: OLTP database and OLAP database. The OLTP database is the database we use for current (transactional) processes. This is the production/ operation database. The second one, the OLAP database is the database we use for reporting (we hold the data for the reports/ analysis). We can say that these 2 components are enough for having a data warehouse, but in this case the presentation will suffer (we will not have nice reports and easy-to-use or see reports). Theoretically 2 databases are enough, but if we work in a professional environment,  we need also:

 

The OBIEE server

 The BI Server doesn't itself hold data. It translates the incoming logical query into one or more outgoing ”physical queries” against the relevant data sources. The data sources could be: an OLAP database, text files,etc. Even an OLTP database can be used as a data source (even if this is a rare case). The translation of the logical query into the physical query is done by the OBIEE server by using the OBIEE server repository. OBIEE server repository is stored in/on the OBIEE server, but it is created with the OBIEE Client (Oracle BI Administration Tool).

 

The OBIEE Client (Oracle BI Administration Tool)

OBIEE Client (Oracle BI Administration Tool) is installed on the data warehouse developer PC. OBIEE Client (Oracle BI Administration Tool) is used to create/ modify a OBIEE server repository. You can use the OBIEE Client (Oracle BI Administration Tool) in an offline mode or an online mode. When you work in an online mode you are connected to the OBIEE Server and the modifications in the repository are seen automatically by the OBIEE server. When the repository you create/ modify is on your laptop/ PC but not on the server you are working in an offline mode. If you are working in an offline mode you have to load that repository in the OBIEE server later. Oracle BI Administration Tool can work with a OLAP database which have or not the database OLAP option installed. If the OLAP option is installed we will deal with the MOLAP or HOLAP generally.

 

The Informatica PowerCenter & Oracle DAC

Informatica PowerCenter Server is a tool used for ETL (Extract Transform Load). For sure, you can use other tools for the same result, but Oracle recommend Informatica PowerCenter Server because its tasks can be easily scheduled with the Oracle DAC (Oracle Data Warehouse Administration Console).

 

So, here it is from a large perspective the OBIEE architecture. The OBIEE architecture is not very complicated but nor simple.

 

On the figure there are the signification for the numbers:

1 = load the data in the OLAP database

2 = create the repository using the Oracle BI Administration Tool using a connection to the OLAP database

3 = load the repository to the OBIEE server

4 = OBIEE server run logical SQL to the physical OLAP database

 

Attention:

 

You can use Analytic Workspace Manager for creating measures, dimensions and cubes in the OLAP database if the database was installed with the OLAP option.

 

 

In-Oracle.com  -> Oracle Data Warehouse & BI  -> Oracle Business Intelligence (BI)

-> OBIEE architecture

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.