Friday, August 3, 2012

OBIEE 11G Technical 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:



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



 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.



 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

Thanks,
Satya Ranki Reddy

No comments:

Post a Comment