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.3
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 2.8%, down 2.8% compared to last year.
WhereScape RED, on the other hand, focuses on Data Integration, holds 1.1% mindshare, up 1.0% 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

"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."
"The data catalog feature is pretty good."
"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 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."
"Data transformations and rollups are easy to accomplish."
"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."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
 

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."
"No support for change data capture or delta detection - that must be custom coded ."
"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."
"Improve the object renaming ability (it works, but it could be more automated)."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"Customization could be better."
"Technical support isn't the best."
 

Pricing and Cost Advice

"Erwin Data Catalog is very expensive."
"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."
"Speed to market of a warehouse solution at a relatively inexpensive price point."
"Our company purchased a corporate unlimited license."
"ROI is at least 10 times."
"Factor in the price of specialized consulting who know this product. They're hard to find and expensive."
report
Use our free recommendation engine to learn which Metadata Management solutions are best for your needs.
831,265 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Government
14%
Manufacturing Company
10%
Computer Software Company
8%
Financial Services Firm
19%
Insurance Company
9%
Government
9%
Computer Software 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
 

Learn More

Video not available
 

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: December 2024.
831,265 professionals have used our research since 2012.