Oracle BI Architecture Components

In this discussion you will get the information about the component of OBIEE 10g and relationship between all the components.

1. Clients

2. Oracle BI Presentation Services

3. Oracle BI Server

4. Oracle BI Repository

5. Data sources

A Simple Architecture:

We will discuss all the components one by one.

1. Clients:

It provides access to Business Intelligence information via a Web Browser.

The Best of Client is Oracle BI Answers and Oracle BI Interactive Dashboard

Oracle BI Answers is a set of graphical tools used to build, view and modify Oracle BI Requests.

Oracle BI Interactive Dashboard is the place where we are displaying the answers requests and other items like (Prompts, filters, Briefing Book and etc.,

2. Oracle BI Presentation services

Oracle BI Presentation Services is an extension to an existing Web server. It receives processing instructions from an Oracle BI client, retrieves the requested information from Oracle BI server, and then renders the information inside the requesting client.

Oracle BI Presentation Services uses a catalog to store saved content, such as Oracle BI requests and Oracle BI Interactive dashboards.

3. Oracle BI Server

It is the core server behind the Business Intelligence Application and provide efficient process to access the physical data sources and structure information.

Oralce BI Server connects natively or through ODBC with database.

It generates the dynamic SQL query to get the data from physical datasources and provides the Business Intelligence data to Oracle Presentation services.

4. Oracle BI Repository:

Oracle BI Server stores metadata in repositories. The Administration Tool has a graphical user interface that allows server administrators to set up these repositories.

An Oracle BI Server repository consists of three layers. Each layer appears in a separate pane in the Administration Tool user interface and has a tree structure. You can expand each object to see a list of its components. These layers are not visible to the end user.

5. Data Sources

Data sources are the physical sources where the data is stored. They can be in any format, including transactional databases, online analytical processing databases, text files, XMLA, spreadsheets and etc., A connection to the data source is created and then used by Oracle BI Server. The data source connection can be defined to use native drivers or ODBC.

SQL is generated by Oracle BI Server against the data sources using the data source connection, information from the repository, and database-specific parameters stored in a DBFeatures.INI file. Thus, Oracle BI Server is not just a SQL generator. It figures out the best source and the optimal way to access data. In some cases, Oracle BI Server takes on operations that are more efficient for it to do rather than the host data source.