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.