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

Apply Schema Definitions to the Physical Database

Once the new schema has been imported into Siebel Tools, you must apply it to the physical database (the OLTP).

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:
    • 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_RUN
    • S_ETL_R_IMAGE
    • S_ETL_REF_PARAM
    • S_ETL_SRC_TABLE
    • S_ETL_TIME_DAY
    • S_ETL_VI_IMAGE
    • S_ETL_VR_IMAGE
  2. Select all these tables, and click Apply at the top of the screen.
  3. 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.)
  4. Click Apply.

 Siebel Data Warehouse Installation and Administration Guide
 Published: 09 September 2004