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
Back to Top ↑