Upgrading OBIA 10.2 to OBIA 10.3

Development

1.  Installations & Configurations of OBIA 10.3
   • Install OBIEE, ODI & OBIA (setup OBIA 10.3)
   • Install ODI 12c client
   • Migrate BIACM Configuration
2.  Import ODI customizations using migration utility
3. Manually migrate ODI customizations not covered by utility (create/change of interfaces)
4. DDL creation – adding custom columns & tables to database
   • Through ODI generate DDL script
   • manually which is not covered by the above
5. Snapshot restore scripts – scripts to restore snapshot data from old warehouse to new warehouse
6. Migrate load plan dev & system components
7. Load Plan Generation

Things to check

1. Tables deffered as part of OBIA 10.3 
2.  Manually maintained tables or static tables
3. how to handle soft deletes & source deleted records
4. is there any requirement to migrate snapshot data or scd type 2 tables

Testing Components

• Data Testing
  • sql testing (rowcounts, spot checks, integration_ids…)
  • Through reports (all the reports should match)
• Perfomance Testing
  • LoadPlan performance testing
  • Report performance testing

Things to remember

1.  all the out of scope items should be clearly defined which covers:
   •  any existing issue from older system
   • data mismatch due to source deleted records
   • reports not matching because of no history in snapshot tables or scd type 2 tables.
2. any pending issue after upgrade should be clearly highlighted
3. Code Freeze/Sync – strategy to move from current running system to this new system

References:

• https://www.oracle.com/a/otn/docs/oracle-bi-applications-release-announcement.pdf
• https://docs.oracle.com/en/applications/business-intelligence-applications/103/index.html
• https://blogs.oracle.com/analytics/post/obia-12c-odi-customizations-migration-utility
• https://blogs.oracle.com/analytics/post/restoring-snapshot-data-when-upgrading-to-bi-apps-103

Let me know in comments if you want to know more on any specific topic. Happy coding 🙂

Parikshit Agarwal