Office of Policy Analysis & Research

CDR Database Views

Data submitted through the Central Data Request (CDR) are stored in a data warehouse maintained by the University of Wisconsin System Administration (UWSA). Authorized staff at UW institutions may access the data warehouse through several database views.

Authorization

As data custodian, OPAR reserves the right to grant or deny access to CDR database views. Because the CDR contains individual student records subject to federal privacy laws, access to CDR database views is granted only to UW staff whose assigned duties include working with equivalent student records at their UW institution. Contact Eric Durkee , CDR Technical Coordinator, to request a network authorization form.

Accessing the Views

Authorized users can access CDR database views in several ways.

  • Use a web browser to access CDR database views through the Hyperion web client:
    • Go to the UW System Authentication Hub: https://authhub.wisconsin.edu/
    • Select the UW institution where you work, choose the Hyperion application, and log in with the appropriate credentials
    • (First-time users may be prompted to install the Hyperion web client at this point.)
    • In Hyperion, use the folder tree on the left to browse to the following folder: Fastar, System Administration, CDR
    • Choose CDR Analytical Warehouse (CDR3) for the most commonly-used tables and views, including all retention and graduation views
    • For additional help with the Hyperion application, contact the Hyperion support staff listed for your institution: http://kb.wisc.edu/helpdesk/page.php?id=6363
  • Use the CEUS or IAIS applications, if you already have them installed
  • Use other database and statistical software packages, once an Oracle connection client is installed. For assistance, contact David Winter in the UWSA Office of Information Services.

Tips for Using CDR Database Views

The CDR database is very large. It contains student and curricular data from all institutions starting in 1973-74 and financial aid data from 1977-78. Here are some tips to make access go more smoothly:

  • Filter or aggregate data before you download it. Many client tools typically retrieve all the data to the local computer before running an analysis. Since the CDR is a very large database, use the WHERE or GROUP BY clauses of the initial SQL retrieval statement to filter or aggregate the data before downloading it to your local computer.
  • Test your queries on a single year. Some queries - even those that filter or aggregate data - may take as long as 30 minutes to run if they select many years of data. Before querying all years of interest, test your query on a single year.

Documentation

return to top