The only direct upgrade path to version 4.1 is from Data Warehouse version 4.0. 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 New Installations.

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, from the installation media, open directory TeamConnect_DataWarehouse and copy the contents 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 shared.xml and kettle.properties, as described in step 3 on New Installations. Then return to this procedural.

3.For SQL Server and NTLM authentication only, add two new attributes to each affected connection element in file shared.xml. See the highlighted text in the example below. This example deals with the source database connection, but NTLM can be used on source and/or target database connections.

<connection>

<name>Source_TeamConnect_data</name>

<server>${jdbc.source_TC_hostname}</server>

<type>MSSQL</type>

<access>Native</access>

<database>${jdbc.source_TC_dbname}</database>

<port>${jdbc.source_TC_portnumber}</port>

<username>${jdbc.source_TC_username}</username>

<password>${jdbc.source_TC_userpassword}</password>

<servername/>

<data_tablespace/>

<index_tablespace/>

<attributes>

<attribute><code>EXTRA_OPTION_MSSQL.domain</code>

<attribute>DOMAIN_NAME</attribute>

</attribute>

</attributes>

</connection>

 For DOMAIN_NAME, substitute the actual Windows domain name that will be doing the authentication.

 

4. Run the upgrade scripts for your version and operating system (.bat for Windows users and .sh for Linux users).

a.Data Warehouse 4.0:

Run WH_upgrade40U1.bat or WH_upgrade40U1.sh

Run WH_upgrade402.bat or WH_upgrade402.sh

Run WH_upgrade41.bat or WH_upgrade41.sh

 

b.Data Warehouse 4.0 Update 1:

Run WH_upgrade402.bat or WH_upgrade402.sh

Run WH_upgrade41.bat or WH_upgrade41.sh

 

c.Data Warehouse 4.0 Update 2:

Run WH_upgrade41.bat or WH_upgrade41.sh

 

 

5.Run the correct WH_install.bat or WH_install.sh file depending upon your operating system. These files are in the datawarehouse target directory. Note: The upgrade scripts for 4.0.x users must be completed prior to this step for a successful installation.