Bookshelf Home | Contents | Index | PDF     

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

Migrating Data for Siebel Industry Applications

In this task, you run an upgrade execution plan to populate data in the new Siebel Data Warehouse schema.

NOTE:  If you do not have historical data, such as slowly changing dimensions or accumulated snap shots, such as pipeline facts, you can perform a full load ETL to populate 7.8.x data. If you perform a full load ETL, do not perform the data migration steps listed in the following sections.

This section includes information on migrating data for the following upgrade scenarios:

Migrating Data Warehouse Data from Version 7.5.x to 7.8.x for Industry Applications

Follow this procedure to migrate data for Siebel Industry Applications from the Siebel Data Warehouse version 7.5.3 to version 7.8.x.

To migrate data warehouse data from version 7.5.x to 7.8.x for Industry Applications

  1. In the Informatica Workflow Manager, navigate to the folder, Upgrade_7.5.XtoINCA_1, and run the following workflows in the following order:
    1. Upgrade_DAW
    2. Upgrade_R_Image
    3. Upgrade_Unspecifieds
    4. Upgrade_Agree
    5. Upgrade_Asset
    6. Upgrade_Opty
    7. Upgrade_Order
    8. Upgrade_Quote
    9. Upgrade_Response
    10. Upgrade_ServiceRequest
    11. Upgrade_Others
    12. Upgrade_Visibility
    13. UpgradeSlowlyChangingDimensionStartDates
  2. In the Informatica Workflow Manager, navigate to the folder, Upgrade_7.5.XtoINCA_2, and run the following workflows in the following order:
    1. SIA_Upgrade_R_Image
    2. SIA_Upgrade_Unspecifieds
    3. LS_Upgrade_ActivityProduct
    4. LS_Upgrade_Others
    5. SIA_Upgrade_Household
    6. FINS_Upgrade_Visibility
    7. SIA_UpgradeSlowlyChangingDimensionStartDates
  3. Configure the DAC:
    1. In the DAC, navigate to Setup > Database Connections.
    2. In the Tables subtab, set the Refresh Date to null for the source tables S_SRC and S_SRC_DCP.

      This step performs a full load on the S_SRC and S_SRC_DCP tables. This step is required because the image tables corresponding to these tables were used in a previous release, and, therefore, need to be refreshed.

  4. 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.
  5. In Informatica Workflow Manager, navigate to the folder, Upgrade_INCA_to_7.8._1, and run the workflows in the order listed in the folder.
  6. If the Usage Accelerator subject area is part of the data warehouse, run the workflows in the folder, Upgrade_From77_to78_for_UsageAccelerator.
  7. In the DAC, run the Complete ETL execution plan as a refresh (to populate the new data warehouse entities).
  8. To verify that the data migrated successfully, make sure the new tables and columns in the schema are populated.

Migrating Data Warehouse Data from Version 7.7 to 7.8.x for Industry Applications

Follow this procedure to migrate data for Siebel Industry Applications from the Siebel Data Warehouse version 7.7 to version 7.8.x.

To migrate data warehouse data from version 7.7 to 7.8.x for Industry Applications

  1. Configure the DAC:
    1. In the DAC, navigate to Setup > Database Connections.
    2. In the Tables subtab, set the Refresh Date to null for the source tables S_SRC and S_SRC_DCP.

      This step performs a full load on the S_SRC and S_SRC_DCP tables. This step is required because the image tables corresponding to these tables were used in a previous release, and, therefore, need to be refreshed.

  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 folder, Upgrade_INCA_to_7.8.1, and run the workflows in the order listed in the folder.
  4. Navigate to the folder, Upgrade_INCA_to_7.8.2, and run the workflows in the order listed in the folder.
  5. In the DAC, run the Complete ETL execution plan as a refresh (to populate the new data warehouse entities).
  6. To verify that the data migrated successfully, make sure the new tables and columns in the schema are populated.

Migrating Data Warehouse Data from Version 7.7.1.x to 7.8.x for Industry Applications

Follow this procedure to migrate data for Siebel Industry Applications from the Siebel Data Warehouse version 7.7.1.x to version 7.8.x.

To migrate data warehouse data from version 7.7.1.x to 7.8.x for Industry Applications

  1. In Informatica Workflow Manager, navigate to the folder, Upgrade_INCA_to_7.8.1, and run the workflows in the order listed in the folder.
  2. Navigate to the folder, Upgrade_INCA_to_7.8.2, and run the workflows in the order listed in the folder.
  3. In the DAC, run the Complete ETL execution plan as a refresh (to populate new data warehouse entities).
  4. To verify that the data migrated successfully, make sure the new tables and columns in the schema are populated.
  
Siebel Business Analytics Applications Upgrade Guide