Data Warehouse provides an Extract-Transform-Load (ETL) solution to extract TeamConnect operational data, transform it, and load it into a simplified database schema to use for your business intelligence tasks. This allows end users who are familiar with standard reporting or business intelligence tools, such as Business Objects, Cognos, WebFocus, etc., to extract information for decision making. Data Warehouse is also used by the built-in reporting features in TeamConnect. Data Warehouse contains a set of automated scripts that read your custom TeamConnect design, then create a secondary simplified, denormalized database schema, and move the data from the operational TeamConnect database to this secondary database. This process of simplification and denormalization of the operational data transforms it into database tables with more intuitive column names.

The ETL tools are set up to process on a pre-defined schedule, and they capture all data changes between the previous invocation of the tools and the current time of execution. These changes are migrated to the warehouse, keeping the two databases synchronized.