Oracle® Business Intelligence Applications Installation and Configuration Guide > Overview of Oracle Business Analytics Warehouse >

Oracle Business Analytics Warehouse Overview


The Oracle Business Analytics Warehouse is a unified data repository for all customer-centric data. The purpose of the Oracle Business Analytics Warehouse is to support the analytical requirements of SAP Applications, Oracle's Siebel, E-Business Suite and Peoplesoft Applications.

The Oracle Business Analytics Warehouse includes the following:

  • A data integration engine that combines data from the transactional database to build a data warehouse.
  • An open architecture to allow organizations to use third-party analytical tools in conjunction with the Oracle Business Analytics Warehouse using the Oracle Business Intelligence Server.
  • Optional prebuilt data extractors to incorporate data from external applications into the Oracle Business Analytics Warehouse (licensed separately).
  • A set of ETL (extract-transform-load) processes that takes data from SAP, Oracle's Siebel, E-Business Suite and Peoplesoft Applications transactional data (OLTP) and creates the Oracle Business Analytics Warehouse tables.

    For more information about ETL processing, see Oracle Business Analytics Warehouse Data Model Reference.

  • The Oracle Business Intelligence Data Warehouse Administration Console (DAC), a centralized console for the set up, configuration, administration, loading, and monitoring of the Oracle Business Analytics Warehouse.

Figure 1 provides an overview of the Oracle Business Analytics Warehouse.

Figure 1. Oracle Business Analytics Warehouse Overview
Click for full size image
Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.