Siebel Analytics Installation and Configuration Guide > Siebel Analytics Applications Overview > Siebel Analytics Applications Installation Overview >

Updating Seed Data

This process is required for customers of Siebel Analytics version 7.0.3 who are upgrading to version 7.5 by way of version 7.0.4.

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

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

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

    $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 14.  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

Upgrading Older Repositories in UNIX

If you have an older version of the Siebel Analytics Server running on UNIX, you must run the following upgrade steps, otherwise parts of the repository may be invalid when you upgrade to Siebel Analytics 7.5.

In the repository, the Date, Time and Timestamp data types are not portable across UNIX and Windows. You can see this in the SiebelAnaltyics.rpd on HP-UX. When you navigate to Manage > Variables > LAST_REFRESH_DT in the Administration Tool running on Windows, the LAST_REFRESH_DT appear to be garbage—for example, it has a negative number for the year.

If you are running on UNIX, there are some additional configuration steps to run. Unless these steps are run, you may have compatibility problems for repositories with Date, Time, and Timestamp columns. The general process is to convert your 7.0.4 repository or repositories to text format, then convert them back to repository format before you use the repository.

To upgrade a 7.0.4 repository in UNIX

  1. Using binary mode, FTP the repository to a Windows 2000 or Windows NT machine.
  2. Convert the repository to text.

    nqudmlgen -U administrator -P SADMIN -R SiebelAnalytics.rpd -O SiebelAnalytics.txt

  3. Convert the text back to repository format.

    nqudmlexec -U administrator -P SADMIN -I SiebelAnalytics.txt -O SiebelAnalytics.rpd

  4. FTP the repository back to the UNIX machine.

Using an Older Repository While Upgrading the Siebel Analytics Platform

You can upgrade to a newer version of the Siebel Analytics platform, while keeping your current version of the Siebel operational application.

When Siebel Analytics is integrated with the Siebel operational application, the Analytics repository version must correspond to the transactional database and data warehouse database versions, but versions of Siebel Analytics and the Siebel operational application do not have to match. For example, to use the Siebel Analytics version 7.5 repository and Web catalog in an integrated environment, the Siebel operational application repository must also be version 7.5, but the Siebel Analytics software can be version 7.7.

The process for using an older repository with a newer version of Siebel Analytics is described in Siebel FAQ (Frequently Asked Questions) 2032 on SupportWeb.


 Siebel Analytics Installation and Configuration Guide
 Published: 09 September 2004