Skip to content

OWB to ODI 12c Migration

Case Studies

About Technology Company

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


  • Oracle KPI Partners-Mar-18-2022-07-14-25-00-AM
  • ODI KPI Partners

Business Driver

Client 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, the client wanted to identify a suitable replacement ETL tool and rebuild the ETL adaptors for their analytical solutions.


Why Was KPI Partners Chosen?

After an exhaustive search for a replacement, the client picked Oracle Data Integrator (ODI) as their data integration tool. The client chose KPI as their implementation partner due to KPI's proven track record, a 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 the client was able to keep up with the product's release dates. The solution passed client's stringent testing criteria and was launched successfully.



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


Comments not added yet!

Your future starts today. Ready?