This release of Data Warehouse works with TeamConnect 4.0.
Data Warehouse 4.0 is certified with Business Objects Enterprise XI 4.0.
Data Warehouse uses Pentaho tools (Pan, Kitchen, and Spoon). It has the following system requirements for installing and configuring:
•A source database. Data Warehouse uses the TeamConnect production database as its source database.
•A target database. Data Warehouse supports the same database brands and versions as TeamConnect. Refer to the TeamConnect Release Notes for Database Requirements.
oIf the target database uses an Oracle database server, the Data Warehouse login must have the CREATE MATERIALIZED VIEWS system privilege, in addition to the rights and privileges for Oracle.
oIf the target database uses an SQL Server database server, its configuration must also be altered as follows:
▪ALTER DATABASE <dbname> SET ALLOW SNAPSHOT_ISOLATION ON
▪ALTER DATABASE <dbname> SET READ_COMMITTED_SNAPSHOT ON
•The ability to use 150 simultaneous database connections on the target database and 60 connections on the source database.
•Java Runtime Environment version 1.6.
Important: TeamConnect Data Warehouse supersedes DataMart. Remove DataMart, following instructions in the DataMart Administration Guide, before installing Data Warehouse.