About 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
Download Case Study

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


  • 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.