OBIA 7.9.6.4 Migration Plan To OBIA 11g Assessment

OBIA 7.9.6.4 Migration: Quick Summary

The OBIA 7.9.6.4 Migration Plan outlines the upgrade path from the legacy Decision Support System, which has been running for over a decade using Informatica PowerCenter 9.5.1, DAC, OBIEE, BI Publisher, WebLogic, and Oracle databases, to a fully supported and modernized OBIA 11g environment. The current setup integrates multiple databases and runs 577 workflows daily but faces end-of-support risks for its older components. The proposed action plan includes upgrading AIX from 7.1 to 7.2, moving Oracle databases to 19c, updating Informatica to 10.4.1, DAC to 11.1.1.7.0, and applying the latest WebLogic and OBIEE security patches, ensuring compliance, improved performance, better supportability, and enhanced system stability.

1-Overview

OBIA 7.9.6.4 Migration 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

4. OBIA 7.9.6.4 Migration: Addressing Key Challenges in Upgrading

4-OBIA 7.9.6.4 Migration Challenges and Solutions

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

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

FAQ

1. What is Oracle OBIA 7.9.6.4, and why migrate to OBIA 11g?

Oracle OBIA 7.9.6.4 is a legacy analytics platform using Informatica and OBIEE. Migration to OBIA 11g is needed to move to supported, secure, and high-performance BI infrastructure.
Keywords: Oracle OBIA migration, OBIA 11g upgrade, legacy BI modernization.

2. What are the main challenges in upgrading from OBIA 7.9.6.4?

Challenges include outdated Informatica and DAC versions, unsupported AIX 7.1 OS, and ensuring Oracle 19c compatibility.
Keywords: OBIA migration challenges, Informatica upgrade issues, Oracle 19c support.

3. Which core components are upgraded in the OBIA migration plan?

Upgrades include AIX 7.2, Oracle DB 19c, Informatica 10.4.1, DAC 11.1.1.7.0, and latest OBIEE/WebLogic patches.
Keywords: OBIA upgrade plan, Informatica 10.4.1, Oracle 19c migration.

4. How does migration improve system performance and reliability?

It improves ETL speed, security, and stability with modern OBIEE, BI Publisher, and Informatica features.
Keywords: OBIA performance benefits, ETL optimization, BI reliability.

5. What benefits does upgrading to Oracle Database 19c provide?

Oracle 19c offers long-term support, performance enhancements, and better BI tool integration.
Keywords: Oracle 19c benefits, OBIA database upgrade, Oracle BI support.

6. Is Informatica PowerCenter 10.4.1 certified with Oracle 19c?

Yes. Informatica 10.4.1 fully supports Oracle 19c as both source and target.
Keywords: Informatica 10.4.1 compatibility, Oracle 19c certification, ETL upgrade.

7. What are the main outcomes of the OBIA 7.9.6.4 to 11g migration?

You gain improved reliability, better security, and full vendor support across all BI components.
Keywords: OBIA migration outcomes, BI modernization results, Oracle analytics upgrade.

8. Where can I find official documentation and certification details?

Official sources include the Oracle Certification Matrix, Informatica 10.4.1 Release Notes, and Oracle E-Delivery.

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