Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse on Windows > Updating Siebel Transactional Database Schema Definitions >

Importing the SIF File into the Siebel Transactional Database

Follow this procedure to import new schema definitions into the Siebel transactional database.

To import new schema definitions into the Siebel transactional database

1. Copy the files named SRW_77.sif and SRW_771.sif from SiebelAnalytics\dwrep to \tools\objects.
2. Open Siebel Tools and point to the development database.
3. Lock the projects named Table ETL and Table Nquire.

   For Siebel Industry Applications, lock the projects named Table ETL, Table ETL CCM, and Table Nquire.

4. In the menu, click Tools > Import from Archive.
5. Navigate to the directory containing the SIF files and open SRW_77.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.

   The Import Wizard reviews all the object conflicts between what is in the repository and what is in the SIF file.

8. When the Import Wizard process is done, 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.
11. Lock the project named Table ETL CCM, and then Repeat Step 5 through Step 10 using the file SRW_771.sif.

    For Siebel Industry Applications, lock the projects named Table ETL and Table ETL CCM, and then Repeat Step 5 through Step 10 using the file SRW_771.sif.

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 Siebel transactional 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.