Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse > Updating Siebel OLTP Schema Definitions >

Importing the SIF File into the Siebel OLTP

To import new schema definitions into the Siebel OLTP

  1. Copy the file named SRW_76.sif from \dwdb\dwrep to \tools\objects.
  2. Open Siebel Tools and point to the development database.
  3. Lock the projects named Table ETL and Table Nquire.
  4. In the menu, click Tools > Import from Archive.
  5. Navigate to the directory containing the SIF files and open srw_76.sif.

    The Import Wizard-Preview screen appears.

  6. Click Next.
  7. Select the option Merge the object definition from the archive file with the definition in the repository, and click Next.
  8. The Import Wizard reviews all the object conflicts between what is in the repository and what is in the SIF file. When the Import Wizard process is done, you can expand the tree under Conflicting Objects to verify the changes being applied from the SIF file to the repository. When you are done, click Next.
  9. A warning appears: "The operation is going to modify your repository ..." Click Yes.
  10. When the process finishes, click Finish.

After you import the new schema into Siebel Tools, you need to apply the schema to the physical database.

To apply schema definitions to the physical database

  1. In Siebel Tools, in the Object Explorer, click on the Table tab and query for S_ETL_*.

    A list of tables appears.

  2. Select all the tables in the list and click Apply.

    The Apply Schema wizard appears.

  3. In the Tables drop-down menu, select Current Query. Enter the appropriate connection parameters, and click Apply.

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