Data Warehouse Query Access

Data Warehouse query access is a "do it yourself" way of creating reports from the data warehouse. A data warehouse is defined as a subject-oriented data base designed for access by end users. In order to use the data warehouse, you access the data through a software package known as a SQL-based query tool like BrioQuery, Microsoft Access or Microsoft Excel using the Microsoft Query extension. There is also a piece of software called an ODBC driver that also needs to be installed on the PC. This access gives you more freedom of creating reports from the data that your security level grants you access to, but it also requires more knowledge about the data - both its content and its structure.

Currently, there are two campus-wide data warehouses that are maintained by Information Technology: the SIS Data Warehouse containing student information and the Payroll/Personnel Data Warehouse containing employee, payroll, lien, staffing and expense data.

How to Get Application Forms

SIS Data Warehouse

1. Call the Registrar's Office at (530) 752-2984 and request the form titled "Extract Database Form".
2. For more information, see the Registrars Office Banner Information web site at http://registrar.ucdavis.edu/html/banner.html.

Payroll/Personnel Data Warehouse

1. Download a copy of the PPS Data Warehouse application for access form.
2. Complete the application form - be sure to get the approval signature from an authorizing person (your supervisor, department MSO, dean's office - someone who has the authority to grant you access to the data you are requesting).

NOTE: There are also pre-defined reports available through the PPS Decision Support reports menu.

See How to Get Data Warehouse Query Access for a more detailed step-by-step list of how to set up access to one or more of the data warehouses.