At the end of 2010, the database "UWSDB" is being retired and the institutional information it provides will instead be sourced from the Enterprise Data Warehouse (EDW) via UWSDBDatastore and Student Web Services. The matrix below helps campus consumers and developers of data determine how best to find the information and data they need to help the University perform at its best.
Needs institutional information to answer questions and gain insight
Great! You can search or browse a complete list of available reports at the Decision Support website's Report Catalog.
Sweet! Learn how to connect to the data you need with step-by-step instructions for your preferred software and operating system.
Now that's getting fancy. Establish a connection through Microsoft's SQL Server Management Studio to write your own SQL queries.
Creates reports and applications for others to use and integrates institutional info
Sounds like you're building something cool. For maximum flexibility with the data you will want to leverage the UW's web services initiative.
Sweet! Get all the details on how to build a report with Microsoft Reporting Services at the Decision Support website's Create and Publish reports page. And hey: the web services initiative fits the read-only bill, too!
You must be building something really cool. The web services initiative is what you'll need because most WS resources reflect data just minutes after it's been changed in the source system (like the SDB).
* Well, some caching goes on; see the docs for details