Siebel 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.
• 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