WhereScape RED

WhereScape RED represents a whole new generation of Data Warehouse software – it is a Data Warehouse Lifecycle Management Toolset – a developer workbench which allows customers to build, manage and maintain data warehouses 10-100 times faster than using traditional methods. RED is fast, simple to use, simple to manage and vastly reduces the complexity of building and managing successful, long term Data Warehouses.

Designing and building successful data warehouses has traditionally been a very manual exercise comprising many complex steps and requiring extensive knowledge, capability and experience to do it well. There are many tools on the market to address each of the steps, such as ETL tools, data modelling tools, but only now has the data warehousing market matured to the point where the new generation of software products don’t just address individual steps – they represent a new and consolidated approach addressing the entire lifecycle of data warehousing. This new approach encapsulates and automates most of the data warehousing methodologies, principles and processes that cause these implementations to succeed for the long term, which traditionally have only been available from the heads of highly experienced practitioners. These new generation tools bring fast, successful data warehousing to everyone, delivering quick results, lowering risk and providing flexibility for growth and change management that embody the value of a successful data warehouse.

RED integrates source system exploration, schema design, metadata management, ETL/ELT, warehouse scheduling, and enhancement into a single, simple integrated design. Much more than a traditional ETL or EDW tool, RED manages the entire process from design through extraction of data, designing and building the data warehouse, building cubes, scheduling, documenting and managing the environment.

Unlike traditional ETL tools, WhereScape RED is tightly integrated with the underlying DW database, including SQLServer, Oracle, DB2 & Teradata. It leverages the power of the database platform to perform transformations, rather than using an expensive external engine, and enables customers to utilise existing RDBMS skills and knowledge.

WhereScape RED’s Live Prototyping™ facilities allow small teams of designers to prototype data warehouses, in dimensional or normalized form, and work with business analysts in real time using design choices populated with real source data.

WhereScape RED’s scheduling and data warehouse management tools can transition tested designs into production in a few hours or days, with complete, automated end-user and administrator documentation. RED also automatically produces end to end data lineage tracking and full impact analysis to understand and manage the impact of changes to any component of the implementation. And a complete data dictionary is automatically produced describing and documenting every entity and attribute in the warehouse.

The WhereScape RED Repository™ provides complete and transparent design and operational metadata, with full version control, allowing administrators to enhance in-production warehouses, roll back design changes to previous states, and automatically produce relevant data warehouse documentation.

RED Customers

There are over 300 customers worldwide using RED, distributed between Europe, the USA and Asia Pacific. There are over 100 customers in Australia / New Zealand including companies such as :

Vodafone Australia, ASB Bank, AirServices Australia, Beiersdorf Bank, Fonterra, Air New Zealand, Australian Defence Service, Perpetual, Optus, Edith Cowan University, Department of Housing, Families, Community Services & Indigenous Affairs, Department of Education, Employment and Workplace Relations, and many others.

“As I looked at the available options from various vendors and consulting companies, it became clear that my best chance of building my data warehouse in-house was with MIP and WhereScape RED ”

Divisional Manager
Federal Government Department, Canberra

Refer to www.wherescape.com for further details