If you have a version of Data Warehouse earlier than 4.0, you have must remove your existing Data Warehouse (see Removing the Data Warehouse), then recreate it using the instructions in the New Installations section of the Data Warehouse guide.

Important: Data Warehouse should not be upgraded until TeamConnect is already at your desired version. Ensure that the TeamConnect version is correct before proceeding.

To upgrade from version 4.0 (or later 4.0.x update), from the installation media, unzip the contents of the ZIP file to a target directory on your hard drive. (For purposes of this documentation, we will presume that your target directory is named datawarehouse and it is a subdirectory of your hard drive's root directory.)

1.Ensure that file kettle.properties contains the correct connection information for your Data Warehouse database. Details about connection properties are found in step 3 on New Installations.

2.Modify kettle.properties, as described in step 3 on New Installations. The shared.xml file is configured for Oracle by default. When using MSSQL, please use the shared-MSSQL.xml file. It is best practice to rename the original (Oracle-configured) file to "shared.xml.ORACLE" and then rename the shared-MSSQL.xml file to shared.xml. Then return to this procedural.

3. Run the WH_upgrade.bat upgrade scripts in a command line for your version and operating system (.bat for Windows users and .sh for Linux users). The upgrade tool will display the current version of TeamConnect and Data Warehouse, as well as the newest available update. After accepting to install, the tool will display the upgrade process and confirm once the upgrade is complete.

4.Run the correct WH_install.bat or WH_install.sh file depending upon your operating system. These files are in the datawarehouse target directory.