Integrated Data and Reporting (IDR) is the enterprise-wide data warehouse, business intelligence and data visualization service. We provide reporting, dashboards, data integration and other features utilizing the IBM Cognos Analytics solution.
For more information about IDR, like how to get access or assistance, visit the UO Service Portal site.
History of IDR
Integrated Data and Reporting at the University of Oregon initially came about as a means to modernize and upgrade methods of data storage and reporting on campus in 2011. IDR’s primary goals included the following:
- To reduce data storage redundancy
- To make the data reporting process on campus more efficient and accessible.
- To more fully integrate data storage and reporting into one comprehensive solution.
Prior to the launch of IDR, the University had a large redundancy of data stores and a slow, manual reporting process. There were multiple shadow databases creating and duplicating information that needed to be accessed, and most of these disparate systems were being maintained at the expense of their respective departments. At the same time, data reports on campus were generated manually by the IS department through hand-coded SQL requests to the database. It became clear that this would not be a viable practice in the long term because there was a high degree of unnecessary data storage redundancy and the reporting process was centralized and limited in scope.