Case Study
Reduced Oracle BI Apps upgrade time leveraging Jade Global's InfatoODI
Download Case StudyAbout the client
Essilor USA is a France-based international ophthalmic optics company that designs, manufactures and markets lenses to correct or protect eyesight. It is headquartered at Charenton-le-Pont, France.
Oracle Cloud Used
- Oracle Cloud Infrastructure (OCI)
- OBIEE,
- Oracle Data Integrator,
- Oracle Essbase Cloud
Business Requirements
- Essilor USA was looking to upgrade their Oracle BI Applications from the de-supported version to the latest and greatest
- Migrate complex Informatica ETL mappings and relevant BI components to ODI ecosystem
- Enable business teams (Procurement, Finance, Projects Accounting, SCM, Sales & Marketing) with advanced BI dashboards
- Enable Self-Service capabilities to grant access of the enterprise data to the power users
Business Challenges
The migration from Oracle BI Applications 7.9 to 11.x requires re-implementation as there is no direct upgrade path possible
High dependencies on the upgrade with other critical in-flight projects like rollout to Florida hospitals
Lack of in-house ODI experts and longer migration path estimated
The Solution
- Implemented InfatoODI automated solution for migration and upgrade of OBIA reporting environment
- Enabled availability of newer modules made available in the latest versions of OBIA
- Extended out of the box ODI loads and mappings to augment the enterprise data warehouse required for business insights
- Implemented new role-based dashboards to meet the enterprise dashboarding
- Enabled self-service subject areas that augmented enterprise dashboards for ad-hoc analysis needs of the power users
Benefits
- Accelerated Oracle BI upgrade to 4 months from 10 months of original estimates
- Automated workflows reduced costs and risk, and increased the process quality by 60%
- Faster data and dashboards delivery, and increased end user productivity
Download Case Study
Related Section
