WhereScape RED Pros and Cons

The tool supports multiple target update methods.

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

It has a built-in automatic scheduling environment.

Naturally produces a way to easily debug your DW data solutions.

Support is absolutely excellent, efficient, and timely.

Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied.

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.

RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation.

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.

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.

Data transformations and rollups are easy to accomplish.

Quickly develops a data warehouse for our organization with documentation and can track back/forward features.

No support for change data capture or delta detection - that must be custom coded .

It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully.

Improve the object renaming ability (it works, but it could be more automated).

Jobs cannot be deleted via the deployment package. When deploying from dev to QA or production, a job has to be retired. The job has to be manually removed from the target environment.

The scheduled jobs which are run by the WhereScape scheduler seem to be a strangely separate animal. Unlike all other WhereScape objects, jobs cannot be added to WhereScape projects. Also, unlike all other objects, jobs also cannot be deleted using a WhereScape deployment application.

The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate.

They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box.