The data warehouse requires the use of Hummingbird's BI/Query software and Oracle's SQL*Net.

Important Install Notes

All Users:
If you are running an Operating System which manages local accounts (i.e., XP, NT, Win 2000, etc.):
Your user account must have the appropriate privileges in order to update the registry and system directories. Generally, the best results are achieved when the user account which accesses the DWHS is given administrative rights before running the DWHS Installation program. Administrative rights can be revoked after the installation has successfully completed. Talk with your Computer Support Specialist regarding this before attempting installation.

Software Requirements for BI/Query
Windows 2000 Pro SP4 or later Windows XP Pro SP2 or later

Hardware Requirements for BI/Query
CPU - PIII 1GHz Recommended (PIII 350 MHz Minimum)
Memory: 512 MB RAM recommended (256 MB Minimum)
256-color, VGA-compatible display recommended
500 MB free disk space recommended

BiQuery 9 Overview - (Click Here)

Follow the steps below:

Download and Run the Install Program

1. Click on the file below. When asked to Save As..., select a convenient location and Click Save.
   

dwhsinst.exe


2. Close all other applications.
   
3. Run the file you saved by double clicking on it.
   
4. Carefully follow the on screen instructions, making sure to select the appropriate data model--"FIS" for Finance, "HRIS" for Human Resources, "SIS" for Student, or "FinAid" for Financial Aid--when prompted.

Start Using the Warehouse

DWHS Module	Data Module File	Default User Directory
FIS	fis.gqu	C:\gql\FIS\User
HRIS	hris.gqu	C:\gql\HRIS\User
Student	student.gqu	C:\gql\Student\User

1. First start up the VPN Client:
   Start Menu -> Programs -> Cisco Systems VPN Client -> VPN Client

2. Connect to the "UofO Database VPN" using your Duck ID username and password. This will allow you access to the Data Warehouse.
3. Click on the Start button on the Windows Taskbar.
4. Point to Programs, then Hummingbird BI Suite. Click BI-Query User.

BiQuery 9 Setup Instructions
To make sure that no one loses their custom queries and reports, the
data models are still being stored in the older C:\GQL directory structure. 
Because of this, you will have to tell the new BiQuery 9 version where to find your
DWHS.CON connection file, and the data models themselves.  Here is how:

1. After starting BiQuery 9 chose Local Data Model.
   
   
   
   
2. Browse to your Data Model which will be in one of the following locations:
   
   C:\GQL\FINAID\USER
   C:\GQL\FIS\USER
   C:\GQL\HRIS\USER
   C:\GQL\STUDENT\USER
   
   
3. You will probably receive the following error message - Click OK:
   
   
   
   
4. From the Host menu chose Connections…
   
   The following dialog will come up:
   
   
   
   
5. In the bottom of the dialog box chose the biq.ini radio button, and then using the […] button to its right, browse to your DWHS.CON directory:
   • If you only have one data model installed, then browse to its directory, which will be one of the following:
     C:\GQL\FINAID
     C:\GQL\FIS
     C:\GQL\HRIS
     C:\GQL\STUDENT
     
   • If you have more than one model installed then browse to C:\GQL
   • Click OK
6. After you have located and selected the DWHS.CON directory, but before leaving the Connections dialog, press the Edit button which will bring up the following dialog:
   
   
   
   
7. Type in your User Name in the User name field and then press Save.

This should complete your connection setup.  You should now be able to connect to the database using the Data Model of your choice.