Siebel Business Analytics Applications Installation and Administration Guide > Overview of Siebel Data Warehouse >

Siebel Data Warehouse Overview

The Siebel Data Warehouse is a unified data repository for all customer-centric data. The purpose of the Siebel Data Warehouse is to support the analytical requirements of Siebel Business Applications.

NOTE:  The Siebel Data Warehouse is also referred to as the Siebel Relationship Management Warehouse (RMW).

The Siebel Data Warehouse includes the following:

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

  For more information about ETL processing, see Siebel Data Warehouse Data Model Reference.

• The Data Warehouse Application Console (DAC), a centralized console for the set up, configuration, administration, loading, and monitoring of the Siebel Data Warehouse.

Figure 1 provides an overview of the Siebel Data Warehouse.

Figure 1. Data Warehouse Overview