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

Apply Schema Definitions to the Physical Database

Once imported into Siebel Tools, the new schema must be applied 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_CTRYREGN
    • S_ETL_CURR_RUN
    • S_ETL_DAY
    • S_ETL_INDUS_VER
    • S_ETL_REF_PARAM
    • 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.
  5. Leave Siebel Tools open for the next procedure.

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