Siebel Business Analytics Applications Upgrade Guide > Upgrading Siebel Business Analytics Applications >

Upgrading the DAC Metadata Repository

Follow this procedure to upgrade the DAC metadata repository.

To upgrade the DAC metadata repository

1. Make sure you have backed up and renamed your existing DAC metadata repository.
2. If you are upgrading from Analytics 7.7, navigate to the SiebelAnalytics\DAC directory, and run the script UpgradeFromAn77ToAN771.sql.

   This step is required only for upgrades from Analytics 7.7.

3. Upgrade the DAC metadata to the latest Analytics format by merging your current DAC metadata repository with the new version received from Siebel Systems.
   1. In the DAC, set up database connections for the current and new repositories by navigating to Setup > Database Connections and entering the following information:

      Field	Enter
      Logical Name	A logical name for the connection.
      Type	DAC Repository.
      Connection Type	Type of database connection.
      Dynamically changes based on Connection Type	If you are using one of the following: Oracle (OCI8), enter the TNS name. Oracle (Thin), enter the instance name. SQL Server, enter the database name. DB2-UDB, enter the connect string as defined in the DB2 configuration.
      Table Owner	Name of the table owner.
      Table Owner Password	Password for the table owner.
      Max Num Connections	The maximum number of connections to the database that the DAC server maintains.
      DB Host	Host machine where the database resides. Required for Oracle (Thin) and MSSQL databases. Not required for Oracle (OCI8), DB2, and DB2-390.
      Port	Port where the database receives requests. Required for Oracle (Thin) and MSSQL databases. Not required for Oracle (OCI8), DB2, and DB2-390.

   2. From the DAC toolbar, choose Tools > DAC Repository Management > Compare and Merge Repositories.
   3. In the Compare and Merge Repositories dialog box, select the source (current) and target (new) repositories that you want to compare.
   4. To import from the source repository into the target the objects that are missing, select the Import Missing Objects check box.

      NOTE:  Modifications made to objects in the source repository must be entered manually in the target repository.

      The Difference report is automatically created.

   5. To view the Difference report, navigate to SiebelAnalytics\DAC\diff\html, and double-click index.html.

      For more information about comparing and merging DAC repositories, see the Siebel Business Analytics Applications Installation and Administration Guide.