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. The repository can be accessed with SAS Enterprise Guide (EG), the SAS Add-in for Excel, Microsoft Access, and the SAS Web Application.
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.
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.
Download and install SAS Enterprise Guide (EG) for accessing Data Warehouse.
Run standardized Data Warehouse reports of historical BASIS data using SAS Enterprise Guide (EG).
The SAS driver for ODBC connects your computer to Data Warehouse reports when using MS Access.
IT Services recommends using MS Access or SAS EG for accessing BI/Data Warehouse.
Download and install the SAS Add-in for accessing Data Warehouse with Excel.
Run standardized Data Warehouse reports of historical BASIS data using the SAS Add-in for Excel. Data Warehouse access is required before running reports, and the SAS Add-in and ODBC driver must be installed.
Troubleshooting tips when using the Data Warehouse