WhereScape RED Reviews

• The automatic generation of all scripts allows for a very agile development process.
• Wherescape also generates very thorough documentation automatically.

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.

There are some newer features that haven't been included in the training materials yet so they're a little outdated (although the help documentation is very good).

There are also some more complex data transformations that aren't supported and so need to be done in multiple steps.

We are two months into an enterprise-wide data warehousing project using Wherescape as the primary tool.

No deployment issues noticed.

No.

No.

In our experience they are happy to help and quick to reply with development solutions whenever needed.

No, this was a ground-up Data Warehouse build.

The initial setup is very easy and we were able to begin development almost immediately.

We are a data analytics consultancy that is implementing WhereScape for one of our clients.

Two months into the project we are currently 50% under budget due to how quickly it's possible to develop large-scale solutions in WhereScape. We were able to train a team with no prior WhereScape experience and begin development in much less time than if we built a standard data-warehouse, while writing procedures and creating our own documentation.

WhereScape pays for itself very quickly.

We considered many alternatives including only using SSIS and SQL Server to build the entire warehouse.

Automation, Automation, Automation....

Automation of Data Warehouse Tasks - Traditional ETL tools are a one-size-fits-all solution. They can often be like a programming language--you can do anything you could ever imagine, but you have to manually create each and every instruction. This leads to a total lack of agility because you have to manually create each and every step. WhereScape, on the other hand, is meant for the specific task of building data warehouses. The product takes on much of the painful, time-consuming, manual and repetitive tasks, allowing you to focus on meeting business requirements.

Automation of Documentation - This is perhaps the best feature of the product. Based on your design, it creates two sets of documentation--one for your technical teams and one for end-users--which show the data model, metadata, and just about anything else you’d want to know about the model.

Impact Analysis - During the lifetime of a data warehouse, there is regularly a need to enhance and extend the warehouse, but it can often be difficult to understand how changes will impact other things downstream. In WhereScape, you can simply click on an object and perform an impact analysis to see how changes to that object will impact other objects. You can also do the reverse of this, looking at an object and “tracking back” to see what objects are used to build it.

Code Runs on the Database - When you build objects in WhereScape (through a point-and-click GUI), the product automatically generates target-specific code. So, for instance, if your target platform is SQL Server, it will generate T-SQL stored procedures for updating your warehouse objects. When jobs are run, this code gets executed on the target database. This essentially means that the ETL is serverless. You do not need a massively sized ETL server to handle the ETL code because it’s simply code being handled by the database, which in my experience, is much more efficient.

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.

As with any product, there are things that can be improved, but most are fairly minor, including things like greater flexibility in ordering job tasks. I’d also like to see increased support for NoSQL data sources.

We have been using the product for about 5 months.

None yet. Because there is no server component, other than a lightweight job scheduler, it’s really just the installation of the software and some basic initial setup. Couldn’t be easier.

No.

No.

Very good customer service. Kind, helpful, and knowledgeable.

This is another area where WhereScape shines. They are not a huge organization, so you get very prompt and personalized care. My support tickets are always answered very quickly and they listen to my suggestions. And, perhaps most importantly, their support team knows the product inside and out. You will not deal with inexperienced first-level support techs.

They also made experts available to help us quickly answer any questions about best practices, how to accomplish specific tasks, etc.

Our purchase of WhereScape was part of a larger re-architecture of our data warehouse. We chose to move away from other products for a variety of reasons, but our choice of WhereScape was largely based on its ability to speed up the development process through automation.

As noted previously, the software generates database code for the target platform and runs that code on the database server itself, so it’s very lightweight. The only components are 1) Client Software and 2) A Lightweight Scheduler. The installation of these two components is very quick and easy.

In-house, although we did get some help from their professional services group, largely for advice on best practices, how to handle complex data transformations, etc. The team is very knowledgeable and seems to have answers to just about every complex question we could think of.

Probably a bit too early to report on this but we expect a good ROI.

The product is much less expensive than traditional ETL tools. Licensing is very simple to understand.

Yes, we looked at various traditional ETL packages as well as other Data Warehouse automation tools. We chose WhereScape over traditional ETL for reasons noted previously and chose WhereScape over other automation tools because it appeared to be the most mature of these solutions.

As other reviewers have noted, data warehouse automation requires you to change your thinking and perspective somewhat. If you are looking at this product as a simple replacement for your existing ETL and try to use it exactly the way you used ETL, then you will not fully realize the functional benefits (the cost benefits will still be there though). You need to think more in terms of agile data warehouse design. For those new to this concept, I recommend a book called “Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema” by Lawrence Corr and Jim Stagnitto. WhereScape fits very nicely into the concepts presented in the book.

• Metadata-based architecture
• Ability to prototype solutions quickly
• Automated documentation
• Great performance

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.

I would love to see a GUI interface for defining dependencies between build processes. RED provides a spreadsheet like interface for defining the dependencies between builds. Once the dependencies are defined, RED can produce a nice dependency diagram to give a visualization of the dependency tree. It would be easier to define complex dependency relationships if the dependency diagram were interactive. Our legacy ETL tool provided this GUI dependency definition via a drag and drop diagram which was very useful. The solution provided by WhereScape does work, and the dependency diagrams generated are helpful. It would just be nice to have the ability to define dependencies via a diagram, since dependencies relationships are much easier to understand via a diagram.

I have used it for 2.5 years.

We have not encountered any deployment issues.

We have not encountered any stability issues.

We have not run into any scalability issues. As mentioned elsewhere, we have seen significant improvements in our “ETL” processing times as we have converted our ETL logic and processing from our legacy ETL tool to WhereScape RED. Here is a little information about our warehousing environment:

• Oracle RDBMS
• 4 ETL developers
• 15 subject area dimensional data marts
• 905 tables (production presentation tables only)
• 1,160,393,098 records (production presentation tables as of 1/31/2017)
• 1.2 Terabytes of used database space (production only)

Customer service is great. Our interactions with WhereScape staff have all been very positive.

Technical support is great. Two-and-a-half years in, we have not encountered a question we could not answer via a simple search on the Customer Support Portal. There has not been a need to open a support ticket yet.

We previously had a traditional ETL tool, which was being sunset by the vendor.

WhereScape RED has a very straightforward, easy-to-understand architecture, so setup was easy.

The learning curve is relatively mild, so the implementation team was the existing ETL team of four developers. The team did go through a couple-day WhereScape RED onsite training session. We also worked with WhereScape’s professional services on a short engagement to evaluate our legacy ETL environment and come up with an approach for conversion of the legacy code to WhereScape.

ROI is hard to measure, but faster time to market for new subject areas, and increased development with existing staff would be two areas we have seen improvements due to our purchase of RED.

An additional influencing factor in our decision to purchase RED is their licensing model. The other products we evaluated were all CPU-based licensing. The license quotes came in very high for the vendor-estimated CPU needs for our existing data warehouse; this did not include future expansion as our warehouse environment should grow as we add more subject areas.

WhereScape RED licensing is based on developer seat. This is great for us. We purchased a four-seat license and we do not need to worry about architecting our warehouse around CPU licensing restrictions. We can size our Warehousing databases to meet the performance needs of our batch processing and user queries. We can also build and support a lot with four developers.

• Oracle Data Integrator ODI
• Informatica Power Center
• IBM InfoSphere DataStage

WhereScape RED has been a great fit for my organization.

The most valuable feature of WhereScape RED is its metadata-driven approach to data warehouse ETL development, although its scheduling and administration capabilities are also a huge plus. Our Teradata data warehouse codebase is over 2000 stored procedures and counting. RED makes administering, enhancing and maintaining this codebase as painless as can be reasonably expected.

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.

Self-Documentation capabilities while good, are an area we would like to see continued improvement.

6 years.

No issues with deployment have been encountered.

No issues with stability have been encountered.

No issues with scalability have been encountered, in fact we continue to do more and more with RED.

Excellent.

Very good. We have even requested troubleshooting or help with tricky problems and the RED engineering team has consistently been available to consult and even collaborate with us on solutions.

Previously, we did a great deal of MS SQL Server stored procedure and SSIS package development. We knew we did not want to manage the development of an enterprise class data warehouse and ETL codebase with handwritten procedures and SSIS packages.

Yes, the installation and configuration was very straight-forward, although we engaged several WhereScape RED service consultants to ensure that it was. I highly recommend leveraging their service offerings to smooth/expedite initial setup.

We used an in-house team, but engaged 2-3 WhereScape service consultants during first year of the initiative.

ROI has been huge. We have very large healthcare data warehouse and the amount of ETL code we have produced and continue to maintain would not be possible without a tool as cost effective as RED.

WhereScape was very fair during pricing and licensing. We were an early adopter of the tool in the US almost 6 years ago, and WhereScape offered very attractive pricing compared to comparable/competitive offerings from other vendors.

Yes, we evaluated Ab Initio and Informatica as well, but chose RED for its ease of use and the portability it offered. Several members of our team had a wealth of Ab Initio experience, and yet still recommended selection of WhereScape RED for our project.

I highly recommend engaging with WhereScape service consultants during adoption of RED. Learn the best practices they promote, and live by them to get the best results.

• Good fit with agile development including requirements discovery and data discovery
• Embedding of standards and design patterns into the tool yields substantial quality and consistency gains
• Schema generation
• Source-to-target mapping automation
• Code/script generation
• Test automation
• Versioning at multiple levels from objects to entire data warehouse
• Scheduling / runtime management functions

• 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

• Data discovery would be more powerful with machine learning features
• Big data functions could include some of the features of the advanced self-service data preparation tools

Excellent

Excellent.

Reviewed several other solutions and chose WhereScape because:

(1) It is built by practitioners, for practitioners

(2) It is a "white box" solution. You can see (and even modify) everything that is generated. It doesn't lock you in like the "black box" proprietary products.

Don't confuse data warehouse automation with ETL automation. DWA automates the entire data warehousing life cycle. Change your approach (think agile), change your processes (think end-to-end ... source data to business impact), and change your perspective (think cyclic, not linear). Without these changes you miss out on many of the benefits of automation.