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 as the source database

•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 what's used for the respective TeamConnect database.
For TeamConnect 5.1 and TeamConnect 5.2, users are not able to utilize Data Warehouse on the following technology stack: SQL Server 2016, Websphere 8.5.5

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

•Java Runtime Environment version 1.8.

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.

Important: TeamConnect Data Warehouse supersedes DataMart. Remove DataMart, following instructions in the DataMart Administration Guide, before installing Data Warehouse.

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