It's easy to deploy. Everything is metadata-based and we can do work by location also. It's easy to segregate between teams.

WhereScape is really helpful in terms of architecture data. Everything is one of automation. Two people can do thousands of tables in one day or two. It saves a lot of time.

The solution is very stable. 

It's compatible even with old methodologies.

The solution is able to automatically generate code for you for managing procedures. 

The product is very flexible. 

You are able to easily create statements.

The initial setup is quick and easy.

Documentation (both user and technical): With so many moving parts, it is hard to keep track of the gazillion databases, tables, columns, and sources. RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation (quickly indicating where and what objects derive from and where they are consumed downstream).

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

Documentation has excellent potential as it provides the capability to generate data lineage and a complete set of rich documentation and output in multiple formats.

The tool supports multiple target update methods.

Support for multiple design methodologies including Data Vault.

Automated creation of documentation, quick time to market, ease of use, code standardization and support for Data Vault 2.0.

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.

The most valuable feature is the metadata generated code and data structures and that it is a fully integrated environment. This has many benefits. It allows for rapid generation of ELT without writing code thus less errors, tracking consequences of changes, tracking transforms, improved ease of maintenance, it uses the data structures directly, it is drag and drop with dialogue entered information. It also automatically includes full audit capabilities.

I like the data vault implementations. It's useful. I also like the ELT feature. I also like the automatic generation of logic as it saves time. I like anything from the beta world, and that's why I took a look at this product.

• It does all the code generation for you. It has very easy code to read, and it is efficient.
• Auto documentation feature
• Plenty of additional custom documentation features
• It has a built-in automatic scheduling environment.
• Naturally produces a way to easily debug your DW data solutions.

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.

WhereScape's deployment package is a fantastic feature. The application allows for selecting specific objects that you would like to deploy from one environment to another rather than deploying the entire database. This allows us to easily work as an agile team. At deployment time, WhereScape determines how to make the objects in the selected destination match the objects in the deployment application (through create and drop, then create and alter, etc.). Therefore, regardless of the state of the destination, we can be confident that the deployed objects will match the objects that we intended to deploy without disturbing anything else in the database. This is a huge benefit to our process because we can quickly create these packages, handing them off to teams who will be deployed to testing and production environments. All they have to do is deploy the package as-is.

Documentation and the ability to track back/forward from fields, processes, etc. Data transformations and rollups are easy to accomplish.

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

Among the features I found most valuable is its support for Kimball Methodology and data warehousing best practices.

• 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