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
We look forward to working with the Jade Global team on other initiatives as this initial engagement has demonstrated their ability to deliver to schedule, budget and quality.