Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse > Using the DAC's Data Warehouse Configurator Wizard >

Creating Data Warehouse Tables


Use this procedure to create data warehouse tables. Before you perform this procedure make sure the SSE role has been created for the Siebel Data Warehouse and OLTP and that the database user has been associated with the role.

NOTE:  Additional work by the database administrator is required if the data warehouse tables need to be moved to different table spaces (for performance or manageability).

To create data warehouse tables

  1. From the DAC menu bar, click Tools > ETL Management Configure.
  2. Select the Create Siebel Data Warehouse Tables check box.

    The Data Warehouse tab is active.

  3. Enter the following information:
    Field
    Description
    Database Type
    Type of database.
    Table Owner
    Valid database user.
    Password
    Valid database user password.
    ODBC Data Source
    Data Source Name (DSN) for the Siebel Data Warehouse.
    Data Area
    Tablespace where Data Warehouse tables are created.
    Index Area
    Tablespace where Data Warehouse indices are created (applicable only to Oracle and DB2 databases).
    Is Unicode
    Specifies whether the Data Warehouse database is Unicode.

 Siebel Data Warehouse Installation and Administration Guide
 Published: 11 March 2004