Siebel Business Analytics Applications Upgrade Guide > Upgrading Siebel Business Analytics Applications >

Upgrading the Data Warehouse Schema

This procedure adds new tables, columns, and indexes to the existing Siebel Data Warehouse schema. It does not alter or disrupt your existing data.

To upgrade the Siebel Data Warehouse Schema

1. From the DAC menu bar, choose Tools > ETL Management > Configure.
2. In the Sources dialog box, select the database platform for the target data warehouse, source transactional database, and the Informatica repository.

   The Data Warehouse Configuration Wizard opens.

3. Select the Create Siebel Data Warehouse Tables check box, and click Next.

   The Data Warehouse tab is active.

4. Enter the following information.

   Field	Description
   Database Type	Type of database. If the database type is DB2 390, then select the 390 Database check box.
   Table Owner	Valid database user.
   Password	Valid database user password.
   ODBC Data Source	Data Source Name (DSN) for the Siebel Data Warehouse.
   Data Area	(Optional) Tablespace where the data warehouse tables are created.
   Index Area	(Optional) Indexspace where the data warehouse indices are created (applicable only to Oracle and DB2 databases).
   Is Unicode	Specifies whether the data warehouse database is Unicode. Check with your database administrator to determine whether your database is Unicode.

5. Check the log file to confirm the new tables, columns, and indexes were added to the schema.

   The log file lists all new objects that were added to the schema.