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 (Oracle 11g or Oracle 12c; SQL Server 2008 or SQL Server 2012). The database type and version selected should be the same as what's used for the respective TeamConnect database.

•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).

More information can be found here.

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