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 (10th)
WhereScape RED
Average Rating
8.2
Reviews Sentiment
7.2
Number of Reviews
15
Ranking in other categories
Data Integration (48th)
 

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.3%, up 2.4% compared to last year.
WhereScape RED, on the other hand, focuses on Data Integration, holds 1.0% mindshare, up 0.8% 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.
it_user584544 - PeerSpot reviewer
The ​architecture is based on metadata and documentation is automated.
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.

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."
"It has a built-in automatic scheduling environment."
"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."
"Support is absolutely excellent, efficient, and timely."
"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."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"I like the data vault implementations."
"Data transformations and rollups are easy to accomplish."
"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."
 

Cons

"There is room for improvement with respect to the connector and how to connect to the structured and unstructured database."
"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."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"Improve the object renaming ability (it works, but it could be more automated)."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"No support for change data capture or delta detection - that must be custom coded ."
"Technical support isn't the best."
"Customization could be better."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"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."
 

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."
"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."
"Speed to market of a warehouse solution at a relatively inexpensive price point."
"ROI is at least 10 times."
report
Use our free recommendation engine to learn which Metadata Management solutions are best for your needs.
847,772 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Government
12%
Computer Software Company
11%
Manufacturing Company
7%
Financial Services Firm
18%
Computer Software Company
10%
Insurance Company
8%
Healthcare 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: April 2025.
847,772 professionals have used our research since 2012.