Bookshelf Home | Contents | Index | PDF     

Siebel Analytics Applications Installation and Administration Guide > Upgrading Siebel Analytics Applications and Data Warehouse >

Upgrading Data in the Siebel Data Warehouse

Follow this procedure to upgrade the data in the Siebel Data Warehouse.

To upgrade data in the Siebel Data Warehouse

  1. Configure the DAC:
    1. In the DAC, navigate to Setup > Database Connections.
    2. In the Tables subtab, set the Refresh Date as null for the source tables S_SRC and S_SRC_DCP.
  2. Execute the Upgrade 7.7 DW to 7.8 DW execution plan:
    1. Navigate to the Execute view.
    2. In the Execution Plans tab, select Upgrade 7.7 DW to 7.8.2 DW.
    3. Click Run Now.
  3. In Informatica Workflow Manager, navigate to the appropriate folder and run the upgrade workflows in the Workflows folder.
    • If you are upgrading from version 7.5.3 to version 7.8.2, run the workflows in the folder Upgrade_7.5.XtoINCA and then run the workflows in the folder Upgrade_INCA_to_7.8.
    • If you are upgrading from version 7.7. to version 7.8.2, run the workflows in the folder Upgrade_INCA_to_7.8.
    • If you are upgrading from version 7.7.1 to version 7.8.2, run the workflows in the folder Upgrade_7.7.1_to_7.8.
  4. If the Usage Accelerator subject area is part of the data warehouse, run the Upgrade_From77_to78_for_UsageAccelerator workflow that is in the Upgrade_INCA_to_7.8 folder.
  5. In the DAC, run the Complete ETL execution plan as a refresh (to populate new data warehouse entities).

To upgrade Siebel Data Warehouse for Siebel Industry Applications

  1. Configure the DAC.
    1. In the DAC, navigate to Setup > Database Connections.
    2. In the Tables subtab, set the Refresh Date as null for the source tables S_SRC and S_SRC_DCP.
  2. Execute the Upgrade 7.7 DW to 7.8 DW execution plan.
    1. Navigate to the Execute view.
    2. In the Execution Plans tab, select Upgrade 7.7 DW to 7.8 DW.
    3. Click Run Now.
  3. In Informatica Workflow Manager, navigate to the appropriate folder and run the upgrade workflows in the Workflows folder.
    • If you are upgrading from version 7.5.3 to version 7.8.2, run the workflows in the folder Upgrade_7.5.XtoINCA and then run the workflows in the folder Upgrade_INCA_to_7.8.
    • If you are upgrading from version 7.7. to version 7.8.2, run the workflows in the folder Upgrade_INCA_to_7.8.
    • If you are upgrading from version 7.7.1 to version 7.8.2, run the workflows in the folder Upgrade_7.7.1_to_7.8.
  4. If the Usage Accelerator subject area is part of the data warehouse, run the workflows in the folder Upgrade_From77_to78_for_UsageAccelerator.
  5. In the Informatica Workflow Manager, navigate to the folder Upgrade_INCA_to_7.7.1_2 and run the SIA_Upgrade_From7_7_to7_7_1 workflow.
  6. In the DAC, run the Complete ETL execution plan as a refresh (to populate new data warehouse entities).
    
Siebel Analytics Applications Installation and Administration Guide