Datawarehouse Software

The software listed below is used to communicate with enterprise data warehouses. Installation instructions for each application have been posted on the datawarehouse support team website. If you experience technical difficulties please contact your departmental computer administrator (DCA) or the datawarehouse support group. You can reach the datawarehouse support group at 737-0616 (Patty Ross), 737-3375 (Joy Bautz), or 737-2671 (Carla Simonson).

Note: We strongly recommend that you back up customer datawarehouse models and the TNSNames.ora file prior to running any of these installers. When clicking on embedded links you may be prompted to authenticate to the server. Provide your domain login and password to access the files. If you require a CD with the applications please contact the datawarehouse support group directly.

Migration Overview

• Note: All automated and manual installers can be found on \\softdist2\Oracle or \\softdist2\DataWrhs.
• Step 1: Install BI Query 9
• Step 2: Install Sample Datamodels
• Step 3: Migrate GQLOSUDW and DWModels
• Step 4: Remove prior Oracle clients [optional]
• Step 5: Install Oracle 10 and test connection

Automatic Installation Instructions

Automatic Removal of Oracle 9.2.0.1 Client: ( Installation Documentation )

This batch file runs the Universal Installer in the background and silently removes Oracle 9.2.0.1 using a pre-filled out response file. If you have different versions of the Oracle client the same process will work with some additional minor changes to the response file. Browse to the install folder and review remove.rsp if you would like to remove a different version.

Automatic Install of Oracle 10.2.0.1: ( Installation Documentation )

This batch file launches the Universal Installer with a pre-defined response file. The TNSNames.ora file is backed up to C:\DW-Backup and then restored once the install has finished.

Automatic BI Query 9 Install: ( Installation Documentation )

The automatic installer for BI Query 9 will install the latest version of BI Query and prompt to remove prior versions installed on the system. The latest version is called 9.0.2 but will report as 9.0.1.0345 in the Help, About menu.

BI Query 9 Hotfix - Dual Core and Multi-Processor Hotfix: ( No Installation Documentation Necessary )

This hotfix has been provided by OpenText to resolve the random crashing problems that customers have been experiencing on dual core and multi-processor workstations while using BI Query 9. Please close BI Query prior to applying this patch. Your version will remain unchanged at '9.0.2' (9.0.1.0345).

Sample Datamodel Installation: ( Installation Documentation )

This will begin the setup of the sample RetailGolf data model. This will be used by customers when Enterprise Computing begins to offer web-training to campus customers.

Automated DWModels Migration Tool: ( Installation Documentation )

This batch file streamlines the migration from C:\GQLOSUDW to C:\DWModels. A backup is created at C:\DW-Backup by the batch file, but it is recommended that your models are backed up prior to doing this.

New DWModels Install Tool: - ( Installation Documentation )

The datawarehouse team is discontinuing the use of the C:\GQLOSUDW folder structure. A new folder structure will be created by this installer populated with the latest models and connection files in the new C:\DWModels location. This process will not backup current models or migrate an existing installation of C:\GQLOSUDW or C:\DWModels into the new structure. This should only be done on computers that do not currently have datawarehouse models installed. If you currently have models installed please use the Automated DWModels Migration tool, or manually configure the new C:\DWModels folder.

Manual Installation Instructions

Manual Oracle 9 Removal: ( Installation Documentation )

This document provides step-by-step instructions to manually remove Oracle 9.x.x.x.

Manual Oracle 10 Install: ( Installation Documentation )

This document provides step-by-step instructions to manually install Oracle 10.

Manual BI Query 9 Install: ( Installation Documentation )

This document provides step-by-step instructions to manually install BI Query 9 on a system with or without Hummingbird 8.x.x, 7.x.x, or 6.x.x.

BI Query 9 Hotfix - Dual Core and Multi-Processor Hotfix: ( No Installation Documentation Necessary )

This hotfix has been provided by OpenText to resolve the random crashing problems that customers have been experiencing on dual core and multi-processor workstations while using BI Query 9. Please close BI Query prior to applying this patch. Your version will remain unchanged at '9.0.2' (9.0.1.0345).

Manual Sample Datamodel Installation: ( Installation Documentation )

This will begin the setup of the sample RetailGolf data model. This will be used by customers when Enterprise Computing begins to offer web-training to campus customers.

DWModels Manual Migration - ( Documentation )

This document will take you through the steps of manually migrating from C:\GQLOSUDW to the new structure.

Other / Troubleshooting Section

Troubleshooting Document

This document contains several common error messages that customers may experience installing, configuring, or using Oracle and BI Query. If you need additional help, please contact your DCA or the datwarehouse support team.

Oracle 10.x.x.x and BI Query 8.x.x

The datawarehouse team has discovered some inconsistencies when using Oracle 10.x.x.x and the older Hummingbird BI Query 8.x.x clients. Please upgrade BI Query 9.x first during your migration or simultaneously with Oracle 10.x.x.x.