EDW Databases and Resources Available to Support Finance Transformation
The Enterprise Data Warehouse (EDW) is a secure central repository that integrates data from many sources across the University. 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 and faster data-informed decision making. For more information about the EDW and how it fits within the Enterprise Data Platform, refer to Enterprise Data Platform.
EDW and UW Finance Transformation (UWFT)
UW Finance Transformation (UWFT) is much more than a system update – it is a redesign of our finance-related policies and processes, with the help of new technology. The EDW is supporting UWFT with the introduction of two new databases: UWODS and WDFinDataMart. These databases, which are under development and provision data from Workday, are currently available to help users prepare for UWFT go live.
For more information on how the EDW is supporting Finance Transformation, including planned dispositions for affected databases, refer to EDW for Finance Transformation.
New UWODS Database
When UWFT goes live, the EDW’s current state Operational Data Store (ODS) will freeze, and the new UW Operational Data Store (UWODS) will be introduced. This new database reflects the Foundation Data Model (FDM), which is the technical framework that organizes financial data in Workday. This new database will support reporting for the following:
- Workday Foundation Data Model (FDM) and Financial Reference Data
- Remediated HR/Payroll Data
To learn more about UWODS, request access, or get support, refer to the UWODS Customer Portal.
New WDFinDataMart Database
When UWFT goes live, the EDW’s current state FinancialSumMart will freeze, and the new Workday Financial Data Mart (WDFinDataMart) will be introduced. This new database will support reporting for the following:
- Accounting & Operational Journal Transactions
- Grant & Financial Budgets
- Current Budget Balances
- Payroll Journal Line Detail
To learn more about WDFinDataMart, request access, or get support, refer to the WDFinDataMart Customer Portal.
Additional Resources for Support
In addition to the customer portals noted above, there are a number of resources available to help users stay informed, ask questions, and get support with these new databases.
Reach Out to UWFT
Reach out to your FT Unit Readiness Lead or submit a request to uwftask@uw.edu for guidance.
Tip: To identify your Unit Readiness Lead, go to the UWFT System Remediation & Retirement Portal, locate your unit, and then click the information icon next to the unit name. For example,  .
An Information/Overview page displays for your unit, which includes the name of your assigned Unit Readiness Lead. |
Join Us for Office Hours
EDW Subject Matter Experts are now available during the Enterprise Reporting and Analytics (ERA) Office Hours every Friday from 9 to 10. Please drop in to ask your UWODS and WDFinDataMart questions.
You can either sign up ahead of time or drop by during the session:
Drop by – Zoom (During session only)
Subscribe to Our Email Lists
When you request access to UWODS or WDFinDataMart, you are automatically added to the respective mailman list(s) to receive periodic communications related to these databases.
If you are not ready to get access, but want to stay in the loop, we encourage you to sign up for the following lists today:
Email Us
If you have questions or would like to provide feedback, please write to edw-help@uw.edu with “UWODS” or “WDFinDataMart” in the subject line.