Experience / Case Studies

Case Study: Ellucian - OWB to ODI 12c Migration

About EllucianEllucian Case Study

Ellucian is the world’s leading provider of software and services for higher education institutions. More than 2400 institutions in 40 countries rely on Ellucian to deliver higher education for over 18 million students. Ellucian provides student information systems (SIS), finance and HR, recruiting, retention, analytics, and advancement software solutions.

Customer Need / Business Driver

Ellucian Analytics (BPRA) solutions (ODS and EDW) use Oracle Warehouse Builder (OWB) as the data integration tool to load their data warehouse. As OWB was reaching its end of life, Ellucian wanted to identify a suitable replacement ETL tool and rebuild the ETL adaptors for their analytical solutions.

Ellucian Case Study - Download PDF

Why Was KPI Partners Chosen?

After an exhaustive search for a replacement, Ellucian picked Oracle Data Integrator (ODI) as their data integration tool.

Ellucian chose KPI as their implementation partner due to KPI’s proven track record, vast number of successful ODI implementations, and KPI’s past experience in the higher education industry.

Project Summary

KPI Partners analyzed existing ODS and EDW architectures and proposed a revised architecture with ODI 12c replacing the existing OWB integration tool.

More than 3000 OWB mappings from existing products were converted and validated successfully in the ODI 12c repository. Oracle Migration Utility for OWB to ODI 12c was used whenever possible and manual conversions were performed for complex OWB mappings.

The migration process and regression test scenarios were executed on time and Ellucian was able to keep up with the product’s release dates. The solution passed Ellucian’s stringent testing criteria and was launched successfully.


  • Accelerated ODI adoption by engaging ODI experts
  • Improved performance by incorporating ODI best practices in Ellucian's new product architecture

Tags: ODI, Oracle, Higher Education BI, Education, Oracle Data Integrator (ODI), Oracle Warehouse Builder, Ellucian, OWB to ODI 12c Migration

Subscribe to the Case Studies