SAS Data Warehouse

Data Warehouse is a repository made up of over 270 tables of financial (purchasing, payroll, general ledger, etc.), academic (UAConnect), and historical BASIS data. Data is copied from live production systems at regular intervals so that data users with appropriate access can run queries and reports of university data. 

The repository can be accessed with SAS Enterprise Guide (EG), the SAS Add-in for Excel, Microsoft Access, and SAS Web Application. 

Requests:

  • Access to Data Warehouse
  • Data design and management
 
Request Data Warehouse Service

Related Articles (7)

Installing SAS EG for Data Warehouse
Download and install SAS Enterprise Guide (EG) for accessing Data Warehouse.
Installing SAS ODBC Driver to Use MS Access with Data Warehouse
The SAS driver for ODBC connects your computer to Data Warehouse reports when using MS Access.
Running Data Warehouse Reports in SAS EG
Run standardized Data Warehouse reports of historical BASIS data using SAS Enterprise Guide (EG).
Running Data Warehouse Reports Using MS Access
IT Services recommends using MS Access or SAS EG for accessing BI/Data Warehouse.
Running Data Warehouse Reports Using the SAS Web Application
The SAS Stored Processes Web Application allows access to U of A Standardized Reports to run historical BASIS data reports from Data Warehouse using a web browser.
Running Reports from Data Warehouse
Data Warehouse is a repository made up of over 270 tables of financial (purchasing, payroll, general ledger, etc.), academic (UAConnect) and historical BASIS data copied from live production systems at regular intervals where staff and faculty with appropriate access can run queries and reports of university data.
Troubleshooting Data Warehouse
Troubleshooting tips when using the Data Warehouse