AWS Glue vs Matillion ETL comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

AWS Glue
Ranking in Cloud Data Integration
1st
Average Rating
7.8
Number of Reviews
37
Ranking in other categories
No ranking in other categories
Matillion ETL
Ranking in Cloud Data Integration
4th
Average Rating
8.4
Number of Reviews
25
Ranking in other categories
No ranking in other categories
 

Market share comparison

As of June 2024, in the Cloud Data Integration category, the market share of AWS Glue is 27.9% and it increased by 15.0% compared to the previous year. The market share of Matillion ETL is 2.7% and it decreased by 60.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Integration
Unique Categories:
No other categories found
No other categories found
 

Featured Reviews

ParamShah - PeerSpot reviewer
Jan 16, 2024
A cloud solution with easy configuration with output limitation
There are output limitations and configuration of its three parts. There was a lot of trial and error that we had to go through. It is not clear how the partition discovery would have been affected by more data coming in. We've made some expensive mistakes, which, if there were any tutorials available or if there was easy documentation available with FAQs, could have been avoided. There is documentation, but it doesn't cover all. There are three specific partition changes, and AWS Glue is tightly tied to Athena. We don't have much flexibility in managing the Athena. AWS Glue could integrate with an AI model or a more advanced version that processes chat-based inputs rather than configuration. This would align it more closely with the functionalities of chat-based interfaces, making it easier to adopt.
DB
May 23, 2024
Helps us monitor real-time data, but the scalability needs improvement
In a project where we migrated from on-prem solutions to the cloud, we used Matillion and Snowflake, which streamlined the process significantly Matillion ETL's ability to conduct end-to-end data migration is valuable. We can create jobs, monitor them, and manage workflows effectively. The…

Quotes from Members

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

Pros

"Data catalog and triggers are the two best features for me. AWS Glue has its own data catalog, which makes it great and really easy to use. Triggers are also really good for scheduling the ETL process."
"The most valuable feature of AWS Glue is that it provides a GUI format with a drag-and-drop feature."
"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."
"I like the fact that AWS Glue works with Python scripts."
"It is AWS-integrated. There is end-to-end integration with the other AWS services. It is also user-friendly."
"The most valuable feature for me is the visual interface of AWS Glue."
"Glue is a NoSQL-based data ETL tool that has some advantages over IIS and ISAs."
"I also like that you can add custom libraries like JAR files and use them. So, the ability to use a fast processing engine and embed basic jobs easily are significant advantages."
"It is pretty user-friendly, even for people who aren't super technical."
"Matillion ETL is one hundred percent stable."
"Matillion ETL has great Git integration that is perfect and convenient to use."
"It has good integrations with Amazon Redshift and other AWS services."
"It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."
"The technical support treats us well. They already have a support portal, and they are responsive, which helps."
"The most valuable feature of Matillion ETL is its user-friendly graphical interface."
"It can scale to a great extent. It can handle the load that we are putting on it, which is about 5TBs."
 

Cons

"There should be more connectors for different databases."
"The setup and installation is a bit complex without advanced knowledge or training."
"The monitoring is not that good."
"The technical support for this solution could be improved. In future, we would like to connect more services like Athena or Kinesis to help control more loads of data."
"The interface for AWS Glue could improve, they do not put a lot of details. You can write the code, in PySpark or in Scala, which is a big advantage, it is only easy to use for a developer. It will be difficult for new users to enter the cloud environment."
"The solution should offer features for streaming data in addition to batching data."
"The product has only a few built-in transformations."
"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's scalability needs improvement. Perhaps adding more connectors would be beneficial."
"Matillion’s on-premises capabilities don’t allow you to build something customized."
"Our main challenge currently is that Matillion runs on an EC2 instance, limiting us to running only two processes simultaneously at the entry level."
"It can have multi-environment support. We should be able to deploy it in different environments. Its integration with SAP connection is not so nice, which should be improved. It can also support an on-prem database."
"There are certain functions that are available in other ETL tools which are still not present in Matillion ETL. It would be good to have more features."
"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."
"The cost of the solution is high and could be reduced."
"The current version is a bit more limited because it's on a virtual machine, and everything executes on that one virtual machine."
 

Pricing and Cost Advice

"If you are using the solution for an enterprise business, it will be expensive."
"AWS Glue is a high-priced solution that bills the client $150,000 to $250,000 annually."
"Its price is good. We pay as we go or based on the usage, which is a good thing for us because it is simple to forecast for the tool. It is good in terms of the financial planning of the company, and it is a good way to estimate the cost. It is also simple for our clients. In my opinion, it is one of the best tools in the market for ETL processes because of the fact that you pay as you use, which separates it from other big tools such as PowerCenter, Pentaho Data Integration, and Talend."
"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 is quite costly, especially for small organizations."
"It is not expensive. AWS Glue works on the serverless architecture. We get charged for the time the server is up. For our use case, we have to use it once in a day, and it is not expensive for us."
"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."
"I rate the product's pricing a five on a scale of one to ten, where one is a high price, and ten is a low price."
"It is not necessarily a cheap solution. However, it's reasonable priced, especially with the smaller machines that we run it on."
"Matillion ETL is expensive."
"The absence of licensing commitments makes it easy to experiment with the tool, and if we decide it's not suitable, we can simply stop the ETL instance and cease incurring charges."
"The prices needs to be lower."
"It was procured through the AWS Marketplace because it keeps things simple. They offer retail-like checkout and bill through your existing Amazon Web Services account."
"The solution is very cheap. You're paying $2.50 an hour and if you set your service up, which you can do, you're not getting charged. Currently, our ETL process is just an overnight process that runs for about an hour. I can start and stop my server just for an hour if I want to and spent $2.50 a day for an ETL solution. There are no additional costs."
"It was very easy to purchase through the AWS Marketplace, but it was also expensive."
"I have heard from my manager and other higher ups, "This product is cheaper than other things on the market," and they have done the research."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
787,061 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Computer Software Company
14%
Manufacturing Company
8%
Insurance Company
7%
Computer Software Company
16%
Financial Services Firm
14%
Manufacturing Company
9%
Government
8%
 

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...
What do you like most about Matillion ETL?
The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand.
What is your experience regarding pricing and costs for Matillion ETL?
The pricing depends on what edition the customer opts for. For example, a standard edition and then business critical of different editions. Each of those has a different cost per unit, which is It...
What needs improvement with Matillion ETL?
One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems.
 

Also Known As

No data available
Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery
 

Overview

 

Sample Customers

bp, Cerner, Expedia, Finra, HESS, intuit, Kellog's, Philips, TIME, workday
Thrive Market, MarketBot, PWC, Axtria, Field Nation, GE, Superdry, Quantcast, Lightbox, EDF Energy, Finn Air, IPRO, Twist, Penn National Gaming Inc
Find out what your peers are saying about AWS Glue vs. Matillion ETL and other solutions. Updated: March 2024.
787,061 professionals have used our research since 2012.