Data Warehouse uses Pentaho tools (Pan, Kitchen, and Spoon). Pentaho tools formerly were known by the collective name "Kettle". It has the following system requirements for installation and configuration:

•TeamConnect Enterprise as the source database for Data Warehouse. Note: The versions listed below are the same in functionality; discrepancies in number exist only to pair each DW version to its respective TC version.

oData Warehouse 4.1 is for TCE 4.x users

oData Warehouse 3.5 is for TCE 3.4SP1 users

oData Warehouse 5.0 is for TCE 5.0 users

•A target database. Data Warehouse supports the same database servers that are supported for TeamConnect. The database type and version selected should be the same as the application server. For more information, see Application and Web Servers.

•Refer to the TeamConnect Release Notes for your respective version for further details.

•Java Runtime Environment version 1.7.

oOracle users will need the ojdbc6.jar file.

oSQL Server users will need the sqljdbc4.jar file.

Both of these .jar files need to be put in the \libext\JDBC\ directory. These files are available from their respective Oracle and Microsoft web sites.

•Ensure that the kettle.properties file has the WH_COMMIT_SIZE=5000 field present. Data Warehouse will not function without this field present.

•Extra disc space requirements for temporary tables. (Extra multiplier).

Note: Data Warehouse has been certified only with standard network authentication.