Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Initializing and Populating the Siebel Customer-Centric Enterprise Warehouse >

Database Types for Data Warehouse Objects

PowerCenter supports database independence. It is the database type that you specify in the Workflow Manager connection that determines the database type that PowerCenter Server uses. A target table that is displayed as the default, DB2, can actually be in SQL Server, DB2, or Oracle, depending on the Workflow Manager connection information.

Sources and targets found in the Siebel Customer-Centric Enterprise Warehouse folder are usually defined with the database type DB2. The source-specific folders in the Designer navigator window also contain sources and targets defined for databases other than what you actually run. However, you must specify your database type in Workflow Manager. The only limitation is that a single Source Qualifier needs to read from all the tables (with the same database type) that are defined in a mapping.