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
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
Hardware Requirements for BI Query
- Windows XP Pro SP2 or later, Windows Vista Enterprise, Windows 7
- 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
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:
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: