Siebel Data Warehouse Installation and Administration Guide > Upgrading the DAC Platform to Release 7.7.1 >

Upgrading the DAC Platform to Release 7.7.1


If you are upgrading from Siebel Analytics 7.7 to Siebel Analytics 7.7.1, you need to complete the following steps to upgrade the DAC platform after installing Siebel Analytics 7.7.1.

If you have multiple DAC environments, some of the steps need to be repeated for each environment; these steps are noted in the procedure. You also need to deploy the DAC repository to the additional environments after you have upgraded the platform.

Upgrading the DAC Platform to Release 7.7.1

Follow this procedure to upgrade the DAC platform to Release 7.7.1.

To upgrade the DAC platform to Release 7.7.1

  1. Back up the existing DAC installation for each environment.
    1. Export your current DAC configuration. In the DAC client, navigate to Tools > Repository Management > Export.
    2. Back up the DAC environment by copying the DAC directory to a different location.
  2. Uninstall Siebel Analytics 7.7 for each environment. Navigate to Programs > Control Panel > Add or Remove Programs.
  3. Restart the machine.
  4. Install the DAC client and server for each environment. For instructions, see Installing Siebel Data Warehouse-Related Software on Windows and Installing and Configuring the Informatica Server and Repository Server on UNIX.

    NOTE:  Do not install the Console Client Utilities option.

  5. Run the script UpgradeFromAN77ToAN771.sql, which is located in the SiebelAnalytics\DAC directory, for each DAC repository and database.

    This step upgrades the DAC metadata to the Analytics 7.7.1 format.

  6. Replace the configuration files with the backup files for each environment. Copy the following files from the back up location to the newly installed DAC location.
    File
    Comments

    DAC\conf\login.xml

    This file preserves the connection information the DAC client was using.

    DAC\lib\*.*

    These files are the JDBC libraries required for the DAC to talk to databases.

    DAC\config.bat

    This file contains the configuration for where the Java SDK is installed and for the DAC_HOME variable.

  7. Set up the DAC server connection information. For instructions, see Configuring the DAC Server.

    To set up the DAC server connection information in a UNIX environment, run the script ServerSetupPrompt.sh.

  8. Export the DAC metadata from the upgraded DAC repository environment (completed in Step 5).
    1. In the DAC client, select Tools > DAC Repository Management > Export.
    2. In the Export dialog box, select Export Categories, and then select Logical.

      This step generates a set of XML files in the DAC\export folder.

Deploying the DAC 7.7.1 Repository to Other Environments

If you have multiple DAC environments, you need to deploy the upgraded DAC 7.7.1 repository to the additional environments.

To deploy the DAC 7.7.1 repository to other environments

  1. Copy all the XML files in the DAC\export folder in the upgraded DAC repository environment to the DAC\export folder in the additional environments.
  2. Import the DAC metadata into the additional environments.
    1. In the DAC client, select Tools > DAC Repository Management > Import.
    2. In the Import dialog box, select Import Categories > Logical.

Siebel Data Warehouse Installation and Administration Guide