Find the right guide for your EDW needs. For questions not covered in these resources, contact edw-help@uw.edu.

Getting Started

• What is the Enterprise Data Warehouse? - Overview of the EDW and what it contains
• Check Your EDW Access in ASTRA - How to confirm your permissions
• Connect to the EDW - Step-by-step instructions for getting started

Access & Connections

• Set Up a Windows Connection (RunAs Command) - Remote connection setup on Windows
• Set Up a Mac Connection (Kerberos Authentication) - Mac connection configuration
• Find EDW Servers and Databases - Complete list of servers, databases, and environments
• Troubleshooting EDW Connection Issues - Common connection problems and solutions

Working with EDW Data

• Query Secured (.sec) Views - Syntax and structure for querying EDW secured views
• EDW Roles and Access Matrix - What data each role can see
• Understand EDW Data Models - Data architecture and structure

Tools & Interfaces

• BI Portal - Run reports and dashboards connected to the EDW
• Getting Started with UWODS (Operational Data Store) - Overview of the UW Operational Data Store

Monitoring & Support

• EDW Data Load Status - Real-time data loading status and schedules
• Breaking Changes in the EDW - Upcoming and recent system updates
• Policies & Compliance
  • DMC Guideline #1017: Access to Enterprise Data Warehouse Data by Applications - Application access requirements and protocols