OBIA 7.9.6.4 Migration Plan To OBIA 11g Assessment

1-Overview

OBIA 7.9.6.4 is the current Decision Support System integrating with Oracle Financials , reservation (Databases) using :

1. Informatica PowerCenter – Top Market Leader Gartner Report 08-2022

– Setup over 10 years ago

– Integrates with 4 databases

– Now daily runs our 577 workflows , DAC setup over 10 years ago( Controls Informatica ) – Now daily runs our 577 Inforamtica workflows

3. Oracle Enterprise & OLAP Data warehousing Database.

4. Weblogic Fusion Middleware Server (supported ver) – secured by 137 internal Roles & SSL Certificate (till 25-07-2024) -> Same release used with OBIA 11.1.1.10.3

5. OBIEE (Dashboarding ) (supported ver) -> Same release used with OBIA 11.1.1.10.3

6. BI Publisher (Reporting ) (supported ver) -> Same release used with OBIA 11.1.1.10.3

2-System in Numbers

 

3-Current Challenge

Although the following installed components versions that are running with no major issues ,they become out of support :

-Informatica (9.5.1 most of tech articles have been removed / archived )

-OBIA

-Metadata & Datawarehouse Database

4-Action Plan

1-Upgrade IBM AIX Operating System from Ver. 7.1 to 7.2TL0

2-Upgrade OBIEE Metadata & Informatica Metadata schemas and target Oracle DB to the supported version 19c

3-Upgrade Informatica 9.5.1 HF2 to Ver. 10.4.1 (Updated : 12-2022)

4-Upgrade DAC to Ver. 11.1.1.7.0

5-Apply latest Critical Patchset Updates (CPU) ,for OBIEE and Weblogic server (Critical Patch Update – July 2023 – Rev 1, 18 July 2023)

 

5-Development Plan Benefits / System Enhancements / Moving to Supported Versions

References

1-https://www.ibm.com/support/pages/why-upgrade-aix-71-aix-72

2-https://community.oracle.com/mosc/discussion/3704926/support-date-update-oracle-business-intelligence-applications-7-9-6-4

3-OBIA 7x: What is the latest Cumulative Patch for DAC 11.1.1.6.4? (Doc ID 1616861.1)

4-https://docs.informatica.com/content/dam/source/GUID-B/GUID-B7717433-A952-44DA-8833-25878E76FE40/1/en/IN_1040_ReleaseNotes_en.pdf

5-https://knowledge.informatica.com/s/article/FAQ-Does-PowerCenter-source-targets-support-Oracle-19C-running-12C-in-compatibility-Mode

6-https://community.oracle.com/mosc/discussion/4314571/confirm-that-the-obiee-12c-and-obia-7-9-6-4-is-compatible-with-18c-and-19c-database

7-oracle 19c certification with 7964 : statement by Gianni Ceresa Managing Director | Oracle ACE Director

https://community.oracle.com/mosc/discussion/4314571/confirm-that-the-obiee-12c-and-obia-7-9-6-4-is-compatible-with-18c-and-19c-database

8-OB1A 7.9.6.4 Certification Matrix:

https://www.oracle.com/technetwork/middleware/bi-applications/biapps7964cert-matrix-1891451.xls

9-Magic Quadrant For Data Integration Tools (Gartner – 08-2022) :

https://www.informatica.com/data-integration-magic-quadrant.html

10-Oracle E-Delivery Site :

https://edelivery.oracle.com/osdc/faces/SoftwareDelivery