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

Upgrading Older Analytics Repositories (UNIX)

If you have an older version of the Siebel Analytics Server running under UNIX (for example, version 7.0.4), you must run the following upgrade steps; otherwise, parts of the repository may be invalid when you upgrade to Siebel Analytics 7.7.

In the repository, the Date, Time, and Timestamp data types are not transferable between 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 Server Administration Tool running on a Windows machine, the LAST_REFRESH_DT appear to be garbage—for example, it has a negative number for the year.

If you are running under 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

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.