AAUDE Data Warehouse Guide
The list below contains many useful links about using the AAUDE Data Warehouse

Connection

• Information on how to establish a connection to the AAUDE Data Warehouse.

[Top]

General Information about the Data Warehouse

• General information about the tables and data models in the Data Warehouse.
  • star schemas
  • fact and dimension tables
  • rules about joins
  • how to apply limits (search criteria)
  • guidelines to produce efficient queries and
  • what to do when things go wrong.

[Top]

BrioQuery

• Download the OCE (Open Catalog Extension) BrioQuery 6 to connet to the Data Warehouse.
• Download the OCE (Open Catalog Extension) for BrioQuery 5.5 to connect to the Data Warehouse.
• Building the OCE (Open Catalog Extension) for BrioQuery 6 to connect to the Data Warehouse. (MS Word Document)
• Training Manuals:
  • AAUDE Data Warehouse BrioQuery 6 Basics Class Manual
• Using and learning BrioQuery to access data in the Data Warehouse:
  • Introduction: about BrioQuery
  • Customize BrioQuery on your desktop
  • How to create a basic query
  • Tips on using BrioQuery

[Top]

Microsoft Access

• ODBC Connection to the AAUDE Data Warehouse (MS Word document)
  How to Link Up the AAUDE Data Warehouse as an ODBC Data Resource in Microsoft Access
  Prepared by Bruce Beck, University of Wisconsin - Madison.

[Top]

FileMaker

• Using FileMaker to access the Data Warehouse. Including ODBC setup to connect to the Data Warehouse.

[Top]

Oracle Common Error Messages

• Some of the common problems and solutions related to Oracle.

[Top]

e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home
Last updated: