Bookshelf Home | Contents | Index | Search | PDF

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

Import New Siebel OLTP Schema Definitions

---

After the Bridge-specific Siebel Analytics and Informatica repositories have been installed, update the 7.0.4 Siebel eBusiness operational application's database (the OLTP database).

NOTE:  You need to be running Siebel Tools for this part of the procedure.

To import new schema definitions into the OLTP application

1. Copy the following file:

   Copy	From	To
   objects_704_bridge.sif	704_Bridge folder	objects_704_bridge.sif \tools\objects

   For Japanese and Korean language users of the Analytics Bridge, the objects_704_bridge.sif file encoding parameter must be changed for proper import. Using a text editor, the following change must be made to the first line in the file:

   • Preconfigured .sif file encoding parameter:

   <?xml version="1.0" encoding="windows-1252"?>

   • Change for Japanese language:

   <?xml version="1.0" encoding="Shift_JIS"?>

   • Change for Korean language:

   <?xml version="1.0" encoding="KS_C_5601-1987"?>

2. Open Siebel Tools, pointing to the development database.
3. In Object Explorer, click Project.
4. In the Table ETL Projects list row, click in the Locked column to check out (lock) the Table ETL project.
5. Navigate to Tools > Import from Archive.
6. In the Select Archives to Import window, select the objects_704_bridge.sif file.
7. Select Open. When you open the bridge .sif in Tools, the Import Wizard—Preview screen appears, listing the Analytics Bridge tables. Be sure to select the Merge option, and then click Next.
8. Click Next. The Import Wizard—Review Conflicts and Actions screen appears. Use this screen to review the differences in objects and attributes between old and new .sif files. (In the following example, clicking the user key attribute HOURS in the S_ETL_TIME_DAY table shows two object differences, with the attribute differences for HOURS shown in the bottom right pane.)
9. Click Next. A dialog box warns you that continuing will modify your repository, and lists the objects that will be inserted, deleted, or updated. Clicking Yes imports the changes.
10. When the import process is finished, the Import Wizard—Summary screen appears, showing you a summary of the .sif changes to the repository files.

    NOTE:  All the objects imported in this process should be new to your 7.0.4 repository, therefore there should be no conflict due to an import. However, should there be a conflict message, choose the second Conflict Resolution option: Merge the object definition from the archive file with the definition in the Repository.

11. In the next screen, click Finish to complete the import process.

Bookshelf Home | Contents | Index | Search | PDF