Menu Request Demo

White Paper: Wherescape RED Technical Architecture

Author: WhereScape

Architectural Overview

WhereScape RED is an integrated development environment (IDE) for developing and managing data warehouses. It can be used to build SQL Server, Teradata, Oracle or DB2 data warehouses. The output from a WhereScape RED project is a data warehouse built in a supported database platform – the Target Data Warehouse.

The output from a WhereScape RED project is a data warehouse built in a supported database platform – the Target Data Warehouse. The WhereScape RED Desktop reads from and writes to a set of database metadata tables (WhereScape RED RepositoryTM) that are stored in the Target Data Warehouse.

A WhereScape RED RepositoryTM is installed in each target data warehouse environment – development, test, production etc.

WhereScape RED generates database specific objects (such as tables, indexes and cubes) as well as procedural code and scripts to move and process data.

All the objects are native database objects that can be viewed and modified by standard third party tools. Code can be changed, tables can be altered, and indexes can be added, changed or removed. They can also be scheduled through the integrated WhereScape RED scheduler and edited, versioned and backed up through the WhereScape RED Desktop. The integrated metadata can also be used to automatically generate data warehouse documentation, diagrams and lineage information.

To read more please download the full White Paper below.