Table 2. Detailed Task List for Upgrading Oracle Business Intelligence Applications
|
Instructions for Task Corresponding to Step |
Stage 1: Upgrade the Platform |
- Upgrade the Siebel Business Analytics Platform to Oracle BI Infrastructure.
|
Oracle Business Intelligence Infrastructure Upgrade Guide. |
Stage 2: Upgrade the Applications |
- Upgrade the Siebel Business Analytics Applications to Oracle Business Intelligence Applications.
|
Oracle Business Intelligence Applications Installation and Configuration Guide. |
Stage 3: Upgrade the DAC and Informatica Repositories |
- Upgrade the Data Warehouse Administration Console (DAC) repository.
|
Upgrading the DAC Repository. |
- Upgrade the Informatica platform.
|
Upgrading to Informatica Version 7.1.4 |
- Upgrade the Informatica repository.
|
Upgrading the Informatica Repository |
Stage 4: Upgrade the Data Warehouse Schema |
- Upgrade the data warehouse schema.
|
Upgrading the Data Warehouse Schema |
Stage 5: Upgrade Siebel Transactional Database Schema |
- Upgrade the Siebel Transactional Database Schema
|
Process of Upgrading the Siebel Transactional Database Schema |
- Import new schema definitions into the Siebel transactional Database.
|
|
- Verify the Siebel transactional database upgrade.
|
|
Stage 6: Migrate Data |
- Migrate data into the upgraded data warehouse.
|
Process of Upgrading the Siebel Analytics Repository |
- Verify ETL customizations.
|
Verifying ETL Customizations. |
Stage 7: Upgrade the Siebel Analytics Repository |
- Upgrade the Siebel Analytics repository to the Oracle BI repository.
|
Process of Upgrading the Siebel Analytics Repository. |
- Prepare for the Analytics repository upgrade.
|
|
- Equalize the Analytics repositories.
|
|
- Compare the Analytics repositories
|
|
- Merge the Analytics repositories.
|
|
- Regression test the Analytics repository merge.
|
|
Stage 8: Upgrade the Web Catalog |
- Upgrade the Siebel Business Analytics Web Catalog to the Oracle BI Presentation Catalog.
|
Process of Upgrading the Analytics Web Catalog |
- Trim the Web Catalog.
|
|
- Upgrade the Analytics Web Catalog to the Oracle BI Presentation Catalog.
|
|
- Test the results of the Presentation Catalog upgrade.
|
|