University of Oregon

Data Warehouse (DWHS) - Installation


Use of the Data Warehouse (DWHS) requires the installation of three components:

  • Oracle SQL*Net / 11gR2 Client
  • Cisco AnyConnect VPN
  • OpenText BI Query software

This webpage will guide you through installing these three components.

Important Install Notes

All Users:

If you are running an Operating System which manages local accounts (i.e., XP, Win 7 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.

You may need to log in to Active Directory during this installation:
During this installation you may be prompted to login onto Active Directory in order to access certain installation files.  When you are prompted to log in, enter your Duck ID prefixed with 'ad\', then enter your Duck ID password as you nomally do, as shown here:


    Software Requirements for BI Query

    • Windows XP Pro SP2 or later, Windows Vista Enterprise, Windows 7
    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 required

    Oracle 11gR2 Client Installation

    The Oracle 11g Client software provides connectivity to the Data Warehouse. This software allows you to retrieve data from the Data Warehouse onto your computer.

    Follow the Instructions on the following link    

    Oracle 11gR2 Client - Click here for instructions

    VPN (Virtual Private Network) Installation

    The VPN Client provides the security required for you to use the Data Warehouse.  It encrypts the information transmitted between your computer and the UO network.

    Follow the Instructions in the following link:

    Anyconnect VPN - Click here for instructions

    BI Query 10 Installation

    The BI Query software provides the interface for you to report on, retrieve, and manipulate data from the Data Warehouse.

    Follow the Instructions on the following link:

    BI Query - Click here for instructions