Wherescape Red - An Overview

In the Overview slide of the WhereScape RED training course, the very first line we see states that “WhereScape’s flagship data warehouse automation software, WhereScape RED, dramatically saves time and money when building data warehouse or big data solutions”.

WhereScape also estimates that, using RED, data warehouses can be built 10-100 times faster than using traditional approaches!

Having never built my own data warehouse prior to this training, I can’t comment on that claim – but I can say that I found the whole process very straightforward. Coming from someone who is much more comfortable in the front end of a BI solution, this is high praise! The data I used was more than likely purpose-built for the training course. To get a more “real-life” feel for the product, I am currently installing RED on one of our VMs in order to test it out with more challenging data.


WhereScape RED was created because of a mounting frustration with lengthy data warehouse developments. As you probably know, the longer a data warehouse delivery takes, the more chance there is that requirements have drastically changed by the time of completion. RED was created to not only achieve a quicker delivery to alleviate this, but also to support an ever-changing set of requirements. RED is designed to: 

  • Enable dimensional modelling: As an example, RED recognises and understands slowly changing dimensions. It enables you to select a data source and specify that you want to create a slowly changing dimension from the data.  It then automatically creates the SQL needed for this.
  • Support agile: With an agile delivery you usually want to quickly have some results to show your business user, they can give you feedback, and you can then refine based on this; RED is designed to support this methodology.

Support change:  With RED you work at the data model level and it then automatically creates the necessary SQL and stored procedures, saving you the time and effort.  If you then change the business data model at a later date due to evolving requirements, the underlying SQL is also automatically updated.


One of the features of RED that really impressed me was that it automatically generates documentation – let’s be honest… who really enjoys creating documentation?! It always seems to be one of those things that sits at the bottom of the priority list and so is left to do at the end of the project. By this time, colleagues could have rolled off the project taking vital undocumented information with them, or you might’ve forgotten the reasons behind doing things a certain way. RED takes the tedium out of documentation.

For practically everything you create, you will see a “Description” and / or “Notes” section as shown below – you can use these to add information on tables, connections, schedules, and so on. RED takes all of this information that you have entered as you make changes and creates documentation with it.

You also get full data lineage; including track back, track forward, and impact analysis out-of-the-box. As you can imagine this saves a lot of time and effort!

If you would like to explore the opportunities presented by our partner Wherescape get in touch to discuss setting up a demo and let's start the conversation and unlock your business's potential.

Subscribe to our Newsletter

If you enjoyed this article why not get great insights straight to your inbox

Leave a comment