Build Data Warehouses. Now.

We can take you through it.

Guided Tour

View more videos

"Because of WhereScape RED’s capabilities, ongoing maintenance of the data warehouse takes much less of our time, and involves significantly less cost."
John Williams, MIS Manager, General Cable NZ.
You want to deliver faster. The value is there. The requirements are known. The source data has been identified. Every day, or week or month it takes to build or extend the data warehouse is frustrating. The team is good, they are doing their best. They want to deliver faster, but they know all about technical debt – they want to deliver a well designed, well engineered, well documented, easily changed, easily supported solution.

WhereScape RED is data warehouse software to help build data warehouses faster. But it is more than that. It also helps you to build data warehouses that are easy to support, change and extend. It is an integrated development environment, or IDE, especially designed to build great data warehouses faster in SQL Server, Teradata, DB2 and Oracle.

This is not toy software, designed for automating the simple tasks. WhereScape RED is used by some of the largest companies on the planet to build data warehouses faster.

It goes far beyond the traditional development silos. The time you spend building doesn’t stop at the fact or dimension or model table level. You also needed to create other objects such as cubes and feeds for downstream systems. You have built data warehouses before so you appreciated that we added surrogate keys for you in the right places, and gave you wizards for creating different types of code generation such as slowly changing dimensions. You are intrigued that we have added the indexes we think should be useful, but you can’t help yourself and are relieved that we also gave you complete control to do it your own way. When it came to large tables you were pleasantly surprised there was a wizard there for partitioning. And when you got something wrong (hey, it happens to all of us) you loved how quick and easy it was to do impact analysis and regenerate everything with the new fix. We also added in the code for scheduling and job control, but you can see this – we generated SQL code that was native for your data warehouse platform that is accessible, visible, even editable. When you wanted to take your development into production, WhereScape RED was there too. We gave you an easy way to package up changes, and then even more importantly, you could see, line by line, what we suggested for the promotion (and of course you could change that too).

With WhereScape RED you can rapidly build data warehouses in your database of choice, you can easily extend existing data warehouses, and you can simplify management and on going support of your data warehouse or data marts.

What the other folks say.

“WhereScape RED automates lots of the repetitive and labour-intensive work usually associated with data warehouse projects – and that has saved IT a lot of build time.” Richard Ridge, IT Manager, First Data

"WhereScape has completed a data mart implementation for Vodafone New Zealand that lets staff access financial and Key Performance Indicator reports from their desktops."
John Tombleson,GM of Business Planning and Support,Vodafone

“Traditionally, this job would have required a very experienced data warehousing person and might take months, if not years to develop. We believe WhereScape allows us to scale that learning curve much more rapidly.”
Tho Dao, IT Manager, City of Shoreline

“Our investment in WhereScape RED has been offset by getting new and more accurate reporting, and spending less time managing the data warehouse.” John Williams, MIS Manager, General Cable NZ

WhereScape RED can be used together with WhereScape 3D - our industry-leading planning software. 


With WhereScape RED, data warehouse developers can:

  • Automate the entire data warehousing life cycle, from design, through implementation, operation and renovation. We provide ELT facilities, but we’re the market’s first and best IDE for the data warehouse build process, end to end.
  • Utilize the integrated team-aware metadata repository for all code, audit and workflow components, with full versioning, code promotion, impact analysis tools (trackback and track-forward features), metadata search and automated documentation production.
  • Support agile as well as traditional project approaches, including Live Prototyping™ - rapid prototyped and fully functional data warehouses in hours, for user reviews and feasibility testing.
  • Provide industry best practices out-of-the-box, including generation of surrogate keys, time dimensions, and target indices.
  • Deliver full extraction, load and transformation (ELT) facilities, with integrated dependency management and scheduling.
  • Generate code automatically, with complete editing freedom post-generation.

Use Cases

WhereScape RED customers - more than 500, worldwide - use the software in a wide variety of BI-related situations, including:

Agile Data Warehousing and Business Intelligence

WhereScape customers committed to implementing using agile methods and practices find WhereScape RED ideally suited to their needs. Agility is built into WhereScape RED.

Rapid Prototyping

WhereScape customers use RED’s Live Prototyping™ facilities to build, populate and test target schema, with users, in rapid iteration cycles, before implementing manually or using WhereScape RED.

Production-Ready Enterprise Data Warehouse

Using both purchased enterprise data models and manually-designed normal-form enterprise data warehouse schema, our customers have used WhereScape RED to build, deploy and operate full-scale enterprise data warehouses, with small project teams, in months, rather than years.

Production-Ready Data Mart

Using WhereScape RED’s market-leading dimensional data modeling and implementation capabilities, WhereScape customers routinely use WhereScape RED to build independent data marts and reporting systems, from multiple source systems, moving from first test extraction to working data mart in weeks.

User Access Layer or Tier of Dependent Marts

In environments where existing enterprise data warehouses require a user access layer, or a tier of independent data marts, to protect the enterprise data warehouse from rapidly changing or volatile end-user requirements, WhereScape customers use WhereScape RED to create user access layers and tiers of dimensional data marts from normal-form enterprise data warehouses, quickly transforming corporate information assets into user-ready dimensional data sets.

Warehouse Renovation or Replacement

When an existing legacy data warehouse or mart requires extension, renovation or replacement, WhereScape customers use WhereScape RED to replicate the existing warehouse or mart in a new target environment, with enhancements as appropriate.

Corporate Performance Management System

When rigorous corporate performance management or business activity monitoring initiatives require high-performance, highly summarized and pre-calculated federated star schema to drive sophisticated reporting, the power of WhereScape RED to quickly build sophisticated analytic structures is highly appreciated.

Analytics Workstation

WhereScape RED’s compact footprint makes it ideal for WhereScape customers seeking to implement large-scale workstation-based personal data marts, for database marketing, statistical analysis and data mining. Powerful multi-core workstations running Windows-based operating systems, SQL Server, and WhereScape RED make, our customers find, ideal and affordable analytical workstations.