No more typing reviews! Try our Samantha, our new voice AI agent.
WhereScape RED Logo

WhereScape RED pros and cons

Vendor: WhereScape
4.1 out of 5

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

WhereScape RED automates data warehousing processes, significantly enhancing speed and efficiency.
It provides exceptional support, with staff who are knowledgeable, courteous, and professional.
The tool generates comprehensive documentation, allowing for easy ETL and data warehouse changes.
WhereScape RED offers robust deployment features, allowing selective object deployment across environments.
Its automation capabilities allow small teams to manage large data sets quickly and efficiently.

CONS

WhereScape RED lacks support for change data capture or delta detection, requiring custom code for these functions.
It could benefit from a diagnostic tool to identify missing components necessary for successful installation.
Job management in WhereScape RED is problematic; jobs cannot be deleted via deployment packages and require manual removal from target environments.
The WhereScape scheduler's scheduled jobs seem disconnected as they cannot be added or removed using WhereScape deployment applications.
Technical support in WhereScape RED needs improvement, making it challenging to find out-of-the-box problem solutions.
 

WhereScape RED Pros review quotes

GM
Data Architect at World Vision
Dec 29, 2017
The tool supports multiple target update methods.
it_user364260 - PeerSpot reviewer
Sr. Research Analyst - Data Management Practice Head at a tech consulting company with 51-200 employees
Dec 2, 2016
Embedding of standards and design patterns into the tool yields substantial quality and consistency gains.
it_user572313 - PeerSpot reviewer
BI Architect at a healthcare company with 5,001-10,000 employees
Jul 7, 2017
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.
Learn what your peers think about WhereScape RED. Get advice and tips from experienced pros sharing their opinions. Updated: March 2026.
886,011 professionals have used our research since 2012.
it_user585969 - PeerSpot reviewer
Business Intelligence Architect at a university with 1,001-5,000 employees
Jun 13, 2017
The product takes on much of the painful, time-consuming, manual and repetitive tasks, allowing you to focus on meeting business requirements.
it_user584544 - PeerSpot reviewer
Manager Data Warehousing at a university with 10,001+ employees
Feb 2, 2017
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.
it_user688914 - PeerSpot reviewer
Data Technology Analyst at a tech services company with 1,001-5,000 employees
Jun 21, 2017
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.
JM
Sr. Technical Consultant/Architect with 11-50 employees
Jan 19, 2018
This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW.
AJ
Director, Corporate Systems at a hospitality company with 5,001-10,000 employees
Jan 24, 2018
Data transformations and rollups are easy to accomplish.
DS
Director Information Systems & Software Development at HealthRIGHT 360
May 22, 2018
Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied.
Chris S - PeerSpot reviewer
Software Developer at HealthRIGHT 360
May 21, 2018
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 Cons review quotes

GM
Data Architect at World Vision
Dec 29, 2017
No support for change data capture or delta detection - that must be custom coded .
it_user364260 - PeerSpot reviewer
Sr. Research Analyst - Data Management Practice Head at a tech consulting company with 51-200 employees
Dec 2, 2016
Data discovery would be more powerful with machine learning features.
it_user572313 - PeerSpot reviewer
BI Architect at a healthcare company with 5,001-10,000 employees
Jul 7, 2017
The only other thing I would note is that the IDE isn’t as intuitive as I would like.
Learn what your peers think about WhereScape RED. Get advice and tips from experienced pros sharing their opinions. Updated: March 2026.
886,011 professionals have used our research since 2012.
it_user585969 - PeerSpot reviewer
Business Intelligence Architect at a university with 1,001-5,000 employees
Jun 13, 2017
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.
it_user584544 - PeerSpot reviewer
Manager Data Warehousing at a university with 10,001+ employees
Feb 2, 2017
I would love to see a GUI interface for defining dependencies between build processes.
it_user688914 - PeerSpot reviewer
Data Technology Analyst at a tech services company with 1,001-5,000 employees
Jun 21, 2017
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).
JM
Sr. Technical Consultant/Architect with 11-50 employees
Jan 19, 2018
It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully.
AJ
Director, Corporate Systems at a hospitality company with 5,001-10,000 employees
Jan 24, 2018
The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate.
DS
Director Information Systems & Software Development at HealthRIGHT 360
May 22, 2018
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.
Chris S - PeerSpot reviewer
Software Developer at HealthRIGHT 360
May 21, 2018
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.