Skip Headers
Oracle® Business Intelligence Applications Installation Guide for Informatica PowerCenter Users

Part Number E14843-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF

2 Overview of Oracle BI Applications

This chapter provides an overview of Oracle BI Applications. It includes the following topics:

2.1 What Is Oracle BI Applications?

Oracle BI Applications is a prebuilt business intelligence solution.

Oracle BI Applications supports Oracle sources, such as Oracle E-Business Suite Applications, Oracle's Siebel Applications, Oracle's PeopleSoft Applications, Oracle's JD Edwards Applications, and non-Oracle sources, such as SAP Applications. If you already own one of the above applications, you can purchase Oracle Business Intelligence Enterprise Edition and Oracle BI Applications to work with the application.

Oracle BI Applications also provides complete support for enterprise data, including financial, supply chain, workforce, and procurement and spend sources. These enterprise applications typically source from both Oracle data sources, such as Oracle EBS and PeopleSoft and non-Oracle data sources, such as SAP.

Oracle BI Applications consists of the components shown in Table 2-1.

Table 2-1 Oracle BI Applications Components (with Informatica/DAC)

Component Description

DAC Repository metadata files

This content includes repository objects such as tables, subject areas, execution plans, and tasks, and is contained in XML files.

Embedded Informatica ETL tool

This is a third-party application that performs the extract, transform, and load (ETL) operations for the data warehouse.

Prebuilt Informatica content

This content includes ETL repository objects, such as mappings, sessions, and workflows, and is contained in the Informatica Repository file (Oracle_BI_DW_Base.rep).

Prebuilt metadata content

This metadata content is contained in the Oracle BI Applications repository file (OracleBIAnalyticsApps.rpd).

Prebuilt reports and dashboard content

This content is contained in the Oracle BI Presentation Services Catalog.

Oracle Business Analytics Warehouse

The prebuilt data warehouse that holds data extracted, transformed, and loaded from the transactional database. For more information, see Section 2.2, "Oracle Business Analytics Warehouse Overview."

2.2 Oracle Business Analytics Warehouse Overview

The Oracle Business Analytics Warehouse is a unified data repository for all customer-centric data, which supports the analytical requirements of the supported source systems.

The Oracle Business Analytics Warehouse includes the following:

2.3 Oracle Business Analytics Warehouse Architecture

High-level analytical queries, like those commonly used in Oracle Business Intelligence, scan and analyze large volumes of data using complex formulas. This process can take a long time when querying a transactional database, which impacts overall system performance.

For this reason, the Oracle Business Analytics Warehouse was constructed using dimensional modeling techniques to allow for fast access to information required for decision making. The Oracle Business Analytics Warehouse derives its data from operational applications and uses Informatica PowerCenter to extract, transform, and load data from various supported transactional database systems (OLTP) into the Oracle Business Analytics Warehouse.

2.3.1 Oracle Business Analytics Warehouse Architecture Components

Figure 2-1 illustrates the Oracle Business Analytics Warehouse architecture when deployed with Informatica PowerCenter and DAC.

Figure 2-1 An example Oracle Business Analytics Warehouse architecture with Informatica PowerCenter and DAC

OBI Warehouse Architecture with Informatica and DAC
  • The Client tier contains the Informatica PowerCenter client tools and the Oracle BI Data Warehouse Administration Console (DAC). DAC is a command and control interface for the data warehouse to allow for set up, configuration, administration, and monitoring of data warehouse processes.

  • The Server tier contains the following:

    • DAC Server. Executes the instructions from the DAC Client. The DAC Server manages data warehouse processes, including scheduling, loading of the ETL, and configuring the subject areas to be loaded. It dynamically adjusts its actions based on information in the DAC Repository. Depending on your business needs, you might incrementally refresh the Oracle Business Analytics Warehouse once a day, once a week, once a month, or on another similar schedule.

    • DAC Repository. Stores the metadata (semantics of the Oracle Business Analytics Warehouse) that represents the data warehouse processes.

    • Informatica PowerCenter Services:

      • Integration Services - The Integration Service reads workflow information from the repository. The Integration Service connects to the repository through the Repository Service to fetch metadata from the repository.

      • Repository Services - The Repository Service manages connections to the PowerCenter Repository from client applications. The Repository Service is a separate, multi-threaded process that retrieves, inserts, and updates metadata in the repository database tables.

    • Informatica Repository. Stores the metadata related to Informatica workflows.

  • The Database tier contains the OLTP and OLAP databases.

2.4 Roadmap to Installing and Setting Up Oracle BI Applications

To install and set up Oracle BI Applications, do the following:

Once you have installed and set up Oracle BI Applications components, configured the modules (optional), and customized Oracle BI Applications (optional), you are ready to start running ETL processes.

For a detailed example of how to run an ETL for Oracle Financials with an Oracle EBS OLTP data source, see Section 4.20, "About Running A Full Load ETL".

For information about running ETL processes, see Oracle Business Intelligence Data Warehouse Administration Console User's Guide.

2.5 Using Oracle BI Repository Documentation

When you deploy Oracle BI Applications, you can use the following documentation and tools to manage your metadata: