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.