Service News Category: Enterprise Data Warehouse

UWSDBDataStore Reorg on June 5, 2021

The student database (SDB) will go through a reorganization on June 5, 2021 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on June 7, 2021. However, data on the new objects will be available as soon as the Data Custodians submit…

New PAS Data Enhancement in the EDW

Procurement Credit Card Spend Data Now Matched to True Supplier In October of 2018, a project was initiated to capture all suppliers from the University’s Procurement Accounting System (PAS) in the Enterprise Data Warehouse (EDW). The project was comprised of three major steps: First, to capture all existing Suppliers from the PAS system in EDW …

How To: Finance Date Functions in EDW

Do you ever get tired of building complicated date logic in your EDW queries? The EDW now supports several finance date functions to help you simplify your queries! These functions help enterprise data users to easily convert calendar dates, months, and years to UW fiscal calendar objects. These functions are most helpful to SQL developers…

EDW Upgrade to SQL Server 2019 Complete

The EDW successfully upgraded our user-facing servers (EDWPub.s.uw.edu) to SQL Server 2019.  We believe you will experience minimal impact, however, if you do experience any issues, please reference our IT Connect article titled, “Preview available for upcoming EDW server upgrade” which contains a list of known issues. Reporting issues If you experience any issues you…

Upcoming changes on EDW process dates for WorkerPosition-related views

Update on 2/12/2021: EDW team is going to deploy this change on Saturday February 27th to give room for our Payroll data processing to take place in the week of March 1st.  If you have any concerns with the 2/27 deployment, please let us know as soon as possible by emailing help@uw.edu with the subject: “EDW WorkerPosition Changes”….

EDW Customer Survey: The Results Are In

If you participated in the EDW’s Customer Survey, thank you! Understanding how you use the EDW helps us improve our services and enhances our ability to support you now and in the future. Over One Million You queried the EDW over one million times from August 2019 to August 2020. By Popular Demand By far,…

UWSDBDataStore Reorg on January 30, 2021

The student database (SDB) will go through a reorganization on January 30, 2021 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on February 1, 2021. However, data on the new objects will be available as soon as the Data Custodians submit…

Preview available for upcoming EDW server upgrade

On the evening of February 9, 2021, the EDW will be upgrading our user-facing servers (EDWPub.s.uw.edu) to SQL Server 2019. This upgrade will position the EDW to take advantage of modern SQL features, as well as allow for greater flexibility as computing and technology needs evolve.  Impact We believe this upgrade will have minimal impact…

ASTRA 2.1 auto-deprovisioning feature now available in the EDW

The Data Platform uses ASTRA to manage access to Enterprise Data Warehouse (EDW) data. The recent release of ASTRA 2.1 includes a new auto-deprovisioning feature that will monitor and automatically remove access for terminated employees. As of December 7, 2020, the EDW is now using ASTRA 2.1 and taking advantage of its new features. The…

Knowledge Navigator Expands Meta Tag Feature

The meta tag feature in Knowledge Navigator (KN) https://metadata.uw.edu has been expanded to provide one more tool to help you search for categorized metadata objects.   What are meta tags? Just like the categories on a blog or keywords in a search tool, meta tags help you find all content that is related by that category…

Next Page »