Data Warehouse Technical Instructions & Documents

Hardware Requirements for Client Machines

Hummingbird BI Query should run on all modern Windows computers. See the Hardware Requirements page for details.

Data Warehouse Installation Instructions

Typically, Departmental Computing Administrators (DCAs) install relevant software on networks and individual workstations in their departments. All of the software is available free of charge to OUS/OSU departments and consists of three major components.

  • The BI Query User application software
  • The Oracle connection software
  • The data model representation of data that the user sees and interacts with

Please access the Data Warehouse Installation Instructions page for more information.

BI Query Handouts & Manuals

Hummingbird BI Query handouts and manuals provide instructions and troubleshooting tips for both new and advanced users.

BI Query Handouts & Manuals

Handouts

Hummingbird BI Query Manuals & User Guides

Hummingbird BI Query Version 9

Hummingbird BI Query Version 8

Advanced Report Building Training Manual (from Hummingbird BI Query Version 6)

The Hummingbird BI Query Version 6 Advanced Report Building handouts still have relevant explanations of BI Query Reports functionality and are useful as the basis for training materials, even though more recent versions have different icons and some additional features.

Data Warehouse Installation Instructions

Software to access the OUS/OSU Data Warehouses is available for DCAs (Departmental Computing Administrators) to install on networks and individual workstations in their departments. All of the software is available free of charge to OUS/OSU departments.

The software to access the Data Warehouse consists of three major components.

  • The BI Query User application software
  • The Oracle connection software
  • The data model representation of data that the user sees and interacts with

The software and links to these installation instructions are available on the software distribution server located at \\TSS-SoftStore.tss.oregonstate.edu\

Installation instructions for the default configuration of the software are available here. Automated installation packages are also available for almost every step of the process. If you prefer or need to walk through the installations manually, instructions are provided as well.

Windows 7 / Vista Installation Instructions (.PDF format)

Install BI Query 10 & Oracle 11 Automated Manual
BI 10 Troubleshooting Tips

Windows XP Installation Instructions (.PDF format)

Install BI Query 9 & Sample Data Models Automated Manual
Migrate Existing Models
OR
Install New Data Models
Automated Manual
Automated
Uninstall Oracle 9.2 (Optional) Automated Manual
Install and Test Oracle 10 Automated Manual
User Setup & Overview of BI Query 9
Troubleshooting Tips
Miscellaneous Instructions:
Manual Installation of Sample Data Models
Uninstall BI Query 9 and Oracle 10 Automated Manual

Hardware Requirements for BI Query Version 9

  Minimum Recommended
CPU PIII 350 MHz Intel Core i Series
RAM 256 MB 4 GB
Free HD Space 500MB Required*
Operating System Windows XP Pro SP 2 Windows 7 Professional

*After installation on our test machine, Hummingbird BI Query plus the Oracle connectivity software was less than 100MB.

In addition, users must have:
  • A 256-Color, VGA-compatable display
  • A CD-ROM drive (required only for installation if using CDs)
  • A campus network connection with TCP/IP access, or from home you must use a VPN to connect to campus.
  • BI Query User and Oracle Net Client installed. See the installation instructions for more information.
In addition to hardware and software, OSU users must have: