Presentation Summary
Derek Messie; Cornell UniversityCornell University Institutional Data Warehouse Technical Architecture and Process Overview
Cornell University’s Institutional Data Warehouse (IDW) sources data from multiple ERP systems (PeopleSoft, Workday, Kuali), as well as a variety of other campus community sources. The challenge for the Institutional Intelligence (I-squared) project at Cornell is to integrate data from these various heterogeneous sources and deliver consistent, accurate and secure, cross-functional reporting to senior university leadership. This presentation will detail the technical architecture and processes involved, from source data replication, to an integrated subject-oriented Institutional Data Store (IDS), through to the IDW star-schemas and conformed dimensions used for executive cross-functional reporting using OBIEE. Many of the challenges encountered in this project will also be discussed.
Presentation Speaker(s)
Derek Messie
Presentation Files
You must be a registered member of the HEDW and properly logged in to view this content