We were a division base for the department under the warehousing team, and have been moving to the centralizing and standardizing of some aspects, and combining all the individuals doing warehouses into one centralized enterprise-level warehousing team. The solution allows us to streamline users so that fewer people are needed to do the warehousing for the entire company.

RED has provided us the ability to integrate, stage, and transform data from diverse sources into an enterprise-grade data warehouse which meets the needs of my organization, but it also enables us to easily and quickly make ETL or DW changes. It also integrates new data sources that the business requires.  

While there is a learning curve, (just as there is with any software), once you get the hang of RED, it is a breeze. It enables us to focus on the business requirements at hand than the tool that we are using to solve the problem.

The biggest win for my organization are the great improvements we have seen in load / refresh processing time over our legacy ETL tool. I was skeptical of the ELT architecture going into our Proof of Concept with WhereScape. I had believed that a more traditional ETL architecture of dedicated ETL servers and applications doing the transformations in memory, then writing to the database, would be faster. It turned out that the ELT approach of using the muscle of the RDBMS was significantly faster than our legacy ETL tool. We are now 2.5 years into using WhereScape and all warehouse code we have converted from our old tool to WhereScape has performed faster; anywhere from 20-80% reduction in processing time. This was huge for us, as increased demand for the warehouse and increased upstream operational system batch processing has really shrunk our batch window. We now have room in our batch window to add more content to the warehouse. In addition to improved performance, we no longer need dedicated ETL servers in our warehouse environment.

The documentation WhereScape provides has also been great. We have always struggled with maintaining documentation on our ETL. It is very nice to get source-to-target mappings, table diagrams, and dependency diagrams, which are up to date, with the click of a button.

Finally, the use of RED has resulted in a much more standardized, easier to support warehousing environment, from what we had prior.

It did not pass usability, reliability, sustainability or performance tests so there was no potential benefit other than minor documentation advantages over the current automated documentation solution.

We can focus on the data itself (data quality, MDM, metrics) instead of spending time building code to move and transform the data. During the POC myself and one WS resource were able to deliver a project in 3 days that had been in development by other resources for 6 months and still hadn't been delivered.

We were more productive from the moment we started using RED but that X-factor has only improved as we have become more comfortable with the toolset and as RED adds new features with each successive release.

Previously, our data warehouse codebase was homegrown, hand-written stored procedures that made scheduling, administration and tracing problems extremely time-consuming and sub-optimal. Now with RED we have much better control over our codebase and processes.

Using this solution sped up development and allowed for easy maintenance.

It has allowed us to produce consistently created, well-documented, easy to maintain DW solutions for our clients.

This is a fantastically, robust DW tool that will make you at least 10 times faster in producing a DW.

We are able to build data models much faster than previously and much faster than using a traditional ETL tool. It allows us to focus on the most important aspect of a data warehouse--business requirements--instead of focusing on the low-level details of the development platform.

WhereScape RED has improved our business's ability to generate needed reporting without requiring a large team of developers to manually code all of the necessary plumbing. WhereScape does a good job of handling this on its own.

Speed to market of a warehouse solution at a relatively inexpensive price point.  We used a consultant to get us started, but the tutorials offered by product were very helpful as well.

The development speed was greatly improved by using WhereScape. It saves time in virtually every aspect of building a Data Warehouse. It provides a great overview of everything you've created which makes trouble-shooting much easier as well.

WhereScape Red helps to speed things up. It has many useful features and version 8 is  reliable. When I first started using it after having worked with Cognos Data Manager, I didn't really find it to be an enterprise-level tool because it was still very flaky. In fact, it had quite a number of bugs. It would fail on every second thing. If you are using it for some basic tasks, it will work fine, but as soon as you try some of the more complex features it would fail. I've seen a lot of improvement in the new versions.

• Agility
• Speed of deployment
• Quick response to changes in requirements and changes in source data
• Skilled people no longer burdened with repetitive low-value tasks