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