The Enterprise Data Warehouse (EDW) is a secure, central system of reference that integrates data from many sources across UW so faculty, staff, and students can make data-informed decisions. It stores current and historical data that are used to support operational reporting and strategic analysis.
The goal of the EDW is to support better, faster, data-informed decision making. Sometimes what you seek is available among the scores of off-the-shelf reports and analytics. But when it’s not, you can query the data directly in the EDW.
Learn more about the EDW and check out our Case Study
Get access to the data
You need to be authorized via ASTRA with an EDW role to access EDW data. Follow this link to review or update your access.
Understand the data
If you’re a query-writer, you know one of the biggest challenges to success is understanding the meaning of the data and how to apply the business rules to get the correct information. These resources can help you get started.
Connect to the data
In order to query EDW data, you need to first connect to it using your UW NetID credentials. The process to connect to EDW data can vary depending on:
- Your computer’s operating system
- The type and version of your query tool
- The network domain in which your computer resides
If you are unable to connect after following our recommended steps, please contact help@uw.edu.
Query the data
No matter which query tool you use, you will be querying secured views rather than tables. Learn where to find the views and how to refer to them in your query.
Find out more about the EDW
Got more questions about using the EDW? Our FAQ has answers!
EDW News
EDW for Finance Transformation Release 20 is Now Available
May. 02, 2023
Enterprise Data Warehouse (EDW) has released an update in UWODS and WDFinDataMart in support of UW Finance…
EDW for Finance Transformation Release 19 is Now Available
Apr. 04, 2023
Enterprise Data Warehouse (EDW) has released an update in UWODS and WDFinDataMart in support of UW Finance…
Important Notice – Upcoming Data Tenant Changes in EDP for Finance Transformation Environments
Mar. 29, 2023
Updated April 19, 2023 Some EDP environments will be subject to multiple data tenant switches…