The Data Warehouse is a stable, read-only database that combines information from separate systems into one, easy-to-access location.
Key features
The MIT Data Warehouse is a central data source which combines data from various Institute administrative systems. Access to the data is controlled by authorizations maintained within the ROLES Database. Community members with appropriate authorizations can access data via SQL or any SQL-based tool. They have the ability to export the results to other software programs (e.g., FileMaker, Microsoft Excel) and manipulate the data locally. The results may also be joined with local data.
- Catalog of Brio reports
- Catalog of Warehouse schemas and table groups
- Catalog of all tables in alphabetical order
- Cognos reports (requires Touchstone authentication)
- Cognos Quick Reference Card
Announcements
- March telephone data has been loaded (3/28/2013)
- February 2013 Pool A unit values have been loaded (3/27/2013)
- See other news items in the Data Warehouse.
Tip of the Day
The Outliner may be detached and resized to view more items. Click on the raised 3-D bar at the left edge of the Outliner, drag it to a new position, move the cursor to the bottom right corner, drag to resize. Doubleclick the title bar to redock the Outliner.
Getting started
- Request Warehouse access
- Getting started and getting help with the Warehouse
- Join the Warehouse-Announce email list
Getting help
- Warehouse use and troubleshooting: warehouse-help@mit.edu
- Administrative matters and authorization requests: warehouse-admin@mit.edu
- Data administration issues: data-admin@mit.edu
- Change your password
Data Warehouse hours of operation
The Data Warehouse is available seven days a week, except for Saturdays from 3 - 3:10 PM during the weekly backup.
- 8 AM - 8 PM: Normal user hours. The Warehouse is stable, and no data are being loaded.
- 8 PM - 7 AM: Data loads. Although the Warehouse can be accessed, the data are in an inconsistent state because they are being refreshed.
- 7 AM - 8 AM: Data extract processing. Data are loaded and stable. Users may access the Warehouse during this time, but the response time might be slow.