Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > Overview of Siebel Data Warehouse >

About the Data Warehouse Application Console

---

The Data Warehouse Application Console (DAC) is a centralized console, providing access to the entire Siebel Data Warehouse application. It allows you to create, configure, and execute modular data warehouse applications in a parallel, high-performing environment.

Important features of the DAC include the following:

• Single command and control point for the Siebel Data Warehouse
• Dynamic load balancing of Informatica workflows across servers
• Dynamic load balancing of database tasks (non-Informatica) across database connections and databases
• Metadata-driven ETL execution plans and drop and create indices
• Registration of Informatica servers, Informatica databases, and source and target databases
• Automated configuration of ETL for full and incremental load of selected data warehouse subject areas
• Intelligent prioritization of sessions in queue during execution based on estimated run time and other criteria
• Structured history tracking and categorization of diagnostic logs by execution plans rather than by sessions
• Customization and extension of data warehouse subject areas
• Scheduling and optimal execution of the ETL process based on database and hardware resources
• Restarting of the ETL process from point of failure
• Email notification about the status of ETL processes

Bookshelf Home | Contents | Index | Search | PDF