The power of Visual Warehouse and the simplicity of the DB2 Control Center have been merged to provide a single, new user interface for business intelligence customers. You can use the Data Warehouse Center to register and access data sources, define data extraction and transformation steps, populate data warehouses, automate and monitor warehouse management processes, and manage and interchange metadata. The Warehouse Launchpad simplifies the job of populating a warehouse by leading you through the related tasks. The Data Warehouse Center supports full refresh and incremental update data movement options including leveraging the power of IBM's integrated data replication functions. Integrated SQL Assist capabilities (see SQL Assist) help customers define over 100 transformations using the rich SQL available with DB2. Users can also build custom transformation routines using Stored Procedure Builder (see Stored Procedure Builder).
See the Data Warehouse Center Administration Guide and the Data Warehouse Center Application Integration Guide for more warehousing information.
Within the Data Warehouse Center, the Warehouse Schema Modeler is a specialized tool for generating and storing schema associated with a data warehouse. Any schema resulting from this process can be passed easily as metadata to an OLAP tool. See the Data Warehouse Center Administration Guide for more information.
The Process Modeler allows users to graphically link the steps needed to build and maintain data warehouses and dependent data marts. Dependency relationships, conditional processing, and notifications can all be included in the model. Processes can be scheduled for one-time or repeating execution, or triggered by internal or external processes.