Cornell previously used IBM Cognos Data Manager to transform and merge data into its Oracle data warehouse, but support for the product will be discontinued prompting the University’s search for a new solution. Cornell sought a solution that could format the data into dimensional models and perform the data transformations. Cornell also wanted an open metadata-based solution so in the future we could do data lineage-type extractions for analytics and reporting.
Cornell felt a proof of concept with its own data set was crucial to the decision-making process. For the proof-of-concept, Cornell was able to quickly convert one its core data model load processes in its financial data mart from Data Manager to WhereScape RED. Based on the success of the proof-of-concept, Cornell selected WhereScape RED and migrated from IBM Cognos Data Manager to WhereScape. WhereScape RED is providing Cornell automated data integration for its Oracle data warehouses that manage crucial student, constituent and financial data.
Cornell is nearing the successful completion of its financial data warehouse conversion using WhereScape RED. The largest table converted was 5.5 million rows. Cornell is polishing and fine-tuning its conversion processes before undertaking the conversion of other subject areas which will happen late this year. Using WhereScape RED, Cornell quickly developed and deployed a new subject area for tracking employee position history from WorkDay. The University has also been using RED to develop a new research administration data mart.
We have been very pleased with the automated data integration capabilities and intuitive nature that WhereScape RED provides. We plan to move our entire core data mart processes over to WhereScape RED over the next calendar year.
Cornell is a privately endowed research university and a partner of the State University of New York. As the federal land-grant institution in New York State, we have a responsibility—unique within the Ivy League—to make contributions in all fields of knowledge in a manner that prioritizes public engagement to help improve the quality of life in our state, the nation, the world. Cornell counts more than 245,000 living alumni, 34 Marshall Scholars, 29 Rhodes Scholars and 44 Nobel Laureates as affiliated with the university. Cornell is made up of 14 colleges and schools with a student body consisting of nearly 14,000 undergraduate and 7,000 graduate students from all 50 American states and 122 countries.To find out more, watch this video with Jeff Christen, Cornell Data Warehouse Manager at Cornell, detailing how Cornell uses WhereScape RED to:
- Automate and standardize much of their Oracle data warehouse development
- Leverage WhereScape ELT architecture and the Oracle database for improved performance
- Use WhereScape to move data into Cornell’s four crucial Oracle data marts
- Reduce costs due to WhereScape’s developer-based pricing model