University of Illinois System

Download Data

The Data Warehouse can be used as a data source for internal departmental applications and databases.  The information provided in this section will assist you in using the Data Warehouse as a data download source.

Establish A Connection

Find out how to establish an ODBC connection to the Data Warehouse, using a variety of query and reporting tools 

Set/Change Application Account Data Warehouse Password

Set or change an Application account's password used for connecting directly to the data warehouse.

Application IDs

Find out more about Application accounts and how to request an application account for use by your department 

Find Data

Before you begin using the Data Warehouse as a source for your local applications, you'll want to know technical details about the data structures, indexes, and data meanings relevant to your application or internal database.  Metadata documentation provides specific technical information about the data structures comprising the Data Warehouse.  Review relevant Metadata to help you plan and implement your data download application or query.

Metadata important for ODBC queries and data download programs includes:

Metadata Type Purpose
Physical Data Models Documents the data structures, table names, and data relationships within a specified data collection (e.g., Finance).  Shows primary keys, cardinality, and table contents (columns).
Source-to-Target Mappings Provides definitions for tables and columns, and documents where data originates in the source system (e.g., Banner, P-Card, etc.). 
Data Dictionary  List of all Data Warehouse tables,including the table definition.
Universe Mapping Documents which Data Warehouse tables are used in specific universe architectures.  Helpful to review if you wish to replicate universe-like functionality with your download, or if you would like to know how to retrieve data elements that you have used previously in universes.
Table Index Information Documents the indexes that are placed on Data Warehouse tables for performance optimization.  Helpful to review to construct efficient queries.
View Information Documents Data Warehouse security views and how they are populated. 
ODBC Data Education Materials Provides instructional information about the Data Warehouse structure specific to ODBC queries.