Bookshelf Home | Contents | Index | Search | PDF

Siebel Analytics Installation and Configuration Guide > Integrating Siebel Analytics with Siebel Operational Applications > Process of Upgrading Siebel Analytics Seed Data >

Updating Previous Siebel Analytics Seed Data

---

This process is required for customers of Siebel Analytics version 7.0.3 only, who are upgrading to version 7.7 through intermediate versions of the software.

The file Analytics_seed_update and supporting utilities are available on the main Siebel operational application installation CD-ROM.

NOTE:  The seed data update should be done by your Siebel operational application administrators, who normally upgrade Siebel operational application seed data.

To update Siebel Analytics 7.0.3 seed data

• Open a command-line interface and enter the following command. Replace all variables (names that start with a $) with your installation-specific information shown in Table 11.

  $SiebelRoot\bin\odbcsql /s "$ODBCDataSource" /u $TableOwner /p $TablePassword /separator / /a /c rem /l $SiebelRoot/log/ seed_cleanup.log $DbsrvrRoot/$DatabasePlatform/ analytics_seed_update.sql /v

  NOTE:  UNIX users should replace the backslashes (\) with forward slashes (/).

  Table 11.  Variables for Updating Seeds

  Variable	Description
  $SiebelRoot	Siebel Server installation directory
  $ODBCDataSource	ODBC Data Source Name for the Siebel Transaction Database
  $TableOwner	Table owner's name
  $TablePassword	Table owner's password
  $DbsrvrRoot	Location of DbSrvr installation
  $DatabasePlatform	RDBMS you are using for Siebel operational applications

Bookshelf Home | Contents | Index | Search | PDF