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

AWS Glue vs WhereScape RED comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

AWS Glue
Average Rating
7.8
Reviews Sentiment
7.1
Number of Reviews
43
Ranking in other categories
Cloud Data Integration (1st)
WhereScape RED
Average Rating
8.2
Number of Reviews
15
Ranking in other categories
Data Integration (49th)
 

Featured Reviews

Ajaykumar Myana - PeerSpot reviewer
Jul 31, 2023
Provides serverless mechanism, easy data transformation and automated infrastructure management
I had the source data, which was unstructured and non-fixable, and my responsibility was to convert it into structured data. For this task, I used PySpark as the programming language. With Python, I implemented the creation of a data frame using Glue jobs. Since Glue jobs are a serverless…
SM
Jul 9, 2021
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 most valuable feature of AWS Glue is that it provides a GUI format with a drag-and-drop feature."
"AWS Glue is a stable and easy-to-use solution."
"The two features I find most valuable in AWS Glue are its user interface and ease of use."
"The facility to integrate with S3 and the possibility to use Jupyter Notebook inside the pipeline are the most valuable features."
"The most valuable features currently are glue studio, jobs, and triggers."
"We have found it beneficial when moving data from one source to another."
"The most valuable feature of AWS Glue is its ease of use and good documentation. Additionally, we can do all the transformations that we need."
"We no longer had to worry much about infrastructure management because AWS Glue is serverless, and Amazon takes care of the underlying infrastructure."
"Naturally produces a way to easily debug your DW data solutions."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"The most valuable feature is the metadata generated code."
"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."
"I found the initial setup very easy."
 

Cons

"The solution’s technical support could be improved."
"While working on AWS Glue, I could not find any training material for it."
"I would like to see a more robust interface on the no-code side. This would be nice to be able to split cells."
"In terms of improvement, the performance of AWS Glue could be faster."
"One area that could be improved is the ETL view. The drag-and-drop interface is not as user-friendly as some other ETL tools."
"The product is expensive for data streaming. This area needs improvement."
"Only people who can code, either in Java or Python, can use the product freely. Those who don't know Java or Python might find using AWS Glue difficult."
"The price of the solution could improve."
"Technical support isn't the best."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"No support for change data capture or delta detection - that must be custom coded ."
"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)."
"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

"It is an expensive product. I rate its pricing a nine out of ten."
"I rate the tool's pricing a four out of ten."
"Technical support is a paid service, and which subscription you have is dependent on that. You must pay one of them, and it ranges from $15,000 to $25,000 per year."
"The solution's pricing is based on DPUs so it is a good idea to optimize use or it can get expensive."
"I rate pricing an eight out of ten."
"AWS Glue is quite costly, especially for small organizations."
"AWS Glue follows a pay-as-you-go model, wherein the cost of the data you use will be counted as a monthly bill."
"AWS Glue uses a pay-as-you-go approach which is helpful. The price of the overall solution is low and is a great advantage."
"Speed to market of a warehouse solution at a relatively inexpensive price point."
"Our company purchased a corporate unlimited license."
"Factor in the price of specialized consulting who know this product. They're hard to find and expensive."
"ROI is at least 10 times."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
814,649 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
21%
Computer Software Company
14%
Manufacturing Company
8%
Insurance Company
6%
Financial Services Firm
17%
Government
10%
Insurance Company
9%
Manufacturing Company
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

How do you select the right cloud ETL tool?
AWS Glue and Azure Data factory for ELT best performance cloud services.
How does Talend Open Studio compare with AWS Glue?
We reviewed AWS Glue before choosing Talend Open Studio. AWS Glue is the managed ETL (extract, transform, and load) from Amazon Web Services. AWS Glue enables AWS users to create and manage jobs in...
What are the most common use cases for AWS Glue?
AWS Glue's main use case is for allowing users to discover, prepare, move, and integrate data from multiple sources. The product lets you use this data for analytics, application development, or ma...
Ask a question
Earn 20 points
 

Learn More

 

Overview

 

Sample Customers

bp, Cerner, Expedia, Finra, HESS, intuit, Kellog's, Philips, TIME, workday
British American Tobacco, Cornell University, Allianz Benelux, Finnair, Solarwinds and many more.
Find out what your peers are saying about AWS Glue vs. WhereScape RED and other solutions. Updated: October 2024.
814,649 professionals have used our research since 2012.