Siebel Analytics Installation and Configuration Guide > Integrating Analytics Dashboards and Operational Applications Data >

Updating Older Analytics Seed Data

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

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

NOTE:  The seed data update should be done by 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 the following table of variables for updating seeds.

  $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 (/).

  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