Try our new research platform with insights from 80,000+ expert users

WhereScape RED vs erwin Data Catalog by Quest comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

erwin Data Catalog by Quest
Average Rating
7.6
Reviews Sentiment
5.1
Number of Reviews
2
Ranking in other categories
Metadata Management (14th)
WhereScape RED
Average Rating
8.2
Reviews Sentiment
7.2
Number of Reviews
15
Ranking in other categories
Data Integration (45th)
 

Mindshare comparison

erwin Data Catalog by Quest and WhereScape RED aren’t in the same category and serve different purposes. erwin Data Catalog by Quest is designed for Metadata Management and holds a mindshare of 3.6%, up 2.8% compared to last year.
WhereScape RED, on the other hand, focuses on Data Integration, holds 1.1% mindshare, up 0.9% since last year.
Metadata Management
Data Integration
 

Featured Reviews

Andres-Martinez - PeerSpot reviewer
Helps with metadata management, saves time, and allows us to do impact analysis on any changes
There are always ways to improve things. For example, we can use AI to be able to find out something. When we are typing something, if we don't know the exact term, Artificial Intelligence would be useful to find terms that are phonetically or syntactically similar. Instead of having to type in the exact name, they can provide those in the list. So, they can provide AI support for the search because when you have thousands and thousands of terms, it is hard to remember all the names. There were some issues when drawing the data models. If you have more than 500 or 600 tables, it takes a long time to display those in the right position on the screen. That can also be improved. They need some caching and some parallel pipelines working on the backend in order to divide it into sections.
reviewer1618884 - PeerSpot reviewer
Quick to set up, flexible, and stable
The scheduling part I don't like due to the fact that it allows you to schedule as a parent and child and other things, however, the error trackability has to be a little more user-friendly. It's also not user-friendly in the sense that it loads all the jobs and there are not enough filters so that it doesn't need to load everything. If the job fails, you don't get any type of alert or email. It would be ideal if there was some sort of automated alert message. Technical support isn't the best. It would be ideal if we understood how to do it in a card exception regarding exclusion, where the card is captured separately rather than filling the whole process on the data inbound side. Certain workloads like this are organized in such a way where you seem to be doubling the work as opposed to streamlining the process.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The data catalog feature is pretty good."
"When you combine it with data lineage, every time you need to make a change, it allows you to do impact analysis on any changes and then connect to the end-users or data stewards so that they can be aware that a change is coming. That's one of the main benefits we use it for."
"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."
"The tool supports multiple target update methods."
"The most valuable feature is the metadata generated code."
"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."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"Data transformations and rollups are easy to accomplish."
"Naturally produces a way to easily debug your DW data solutions."
 

Cons

"There are always ways to improve things. For example, we can use AI to be able to find out something. When we are typing something, if we don't know the exact term, Artificial Intelligence would be useful to find terms that are phonetically or syntactically similar. Instead of having to type in the exact name, they can provide those in the list. So, they can provide AI support for the search because when you have thousands and thousands of terms, it is hard to remember all the names."
"There is room for improvement with respect to the connector and how to connect to the structured and unstructured database."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"Technical support isn't the best."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"No support for change data capture or delta detection - that must be custom coded ."
"Improve the object renaming ability (it works, but it could be more automated)."
"Customization could be better."
 

Pricing and Cost Advice

"I am not very familiar with its pricing. I know it is not cheap, but it is also not super expensive. It depends on the company size. For a company making $1 million, it is very expensive. For a company making 10 million and above, it might be okay."
"Erwin Data Catalog is very expensive."
"Speed to market of a warehouse solution at a relatively inexpensive price point."
"Factor in the price of specialized consulting who know this product. They're hard to find and expensive."
"Our company purchased a corporate unlimited license."
"ROI is at least 10 times."
report
Use our free recommendation engine to learn which Metadata Management solutions are best for your needs.
860,592 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Manufacturing Company
8%
Government
8%
Real Estate/Law Firm
6%
Financial Services Firm
15%
Computer Software Company
11%
Healthcare Company
9%
Insurance Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

Which ETL tool would you recommend to populate data from OLTP to OLAP?
There are two products I know about * TimeXtender : Microsoft based, Transformation logic is quiet good and can easily be extended with T-SQL , Has a semantic layer that generates metat data for cu...
Ask a question
Earn 20 points
 

Overview

 

Sample Customers

Balfour Beatty Construction, Banco de México, BFSI Canada, CenturyLink, Daktronics
British American Tobacco, Cornell University, Allianz Benelux, Finnair, Solarwinds and many more.
Find out what your peers are saying about Informatica, Alation, Collibra and others in Metadata Management. Updated: June 2025.
860,592 professionals have used our research since 2012.