Siebel Data Warehouse Installation and Administration Guide > The Siebel eBusiness 6.3 to 7.5 Analytics Bridge > Installation Process >

Apply Schema Definitions to the Physical Database


Once imported into Siebel Tools, the new schema must be applied to the physical database.

To apply schema definitions to the physical database

  1. In Siebel Tools, go to the Table screen. Search for S_ETL*.
    You should see the following tables:
  2. S_ETL_COSTLST
    S_ETL_CTRYREGN
    S_ETL_DATASRC
    S_ETL_DAY
    S_ETL_ERRHLP
    S_ETL_ERRLOG
    S_ETL_EXCH_RATE
    S_ETL_I_IMAGE
    S_ETL_INC_STAT
    S_ETL_INDUS_VER
    S_ETL_LOV
    S_ETL_PARAM
    S_ETL_R_IMAGE
    S_ETL_REF_PARAM
    S_ETL_RUN
    S_ETL_SRC_TABLE
    S_ETL_TIME_DAY
    S_ETL_VI_IMAGE
    S_ETL_VR_IMAGE

  3. Select all these tables, and click the Apply button at the top of the screen.
  4. In the next window (Apply Schema), under the entry Tables, select Current Query from the dropdown. Under the subsequent entries, enter the connection parameters for the development database. (Your connection information will vary depending on your particular database platform and on the configuration of your particular database environment.)
  5. Click the Apply button.

 Siebel Data Warehouse Installation and Administration Guide, Version 7.5, Rev. C 
 Published: 18 April 2003