We performed a comparison between AWS Glue and Matillion ETL based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It is a stable and scalable solution."
"AWS Glue's most valuable features are the data catalog, including crawlers and tables, and Glue Studio, which means you don't have to use custom code."
"I like that it's flexible, powerful, and allows you to write your own queries and scripts to get the needed transformations."
"I appreciate AWS Glue for its cost-effectiveness."
"Transformations are valuable because you can modify or override complex data logic from an open source or Spark to solve issues."
"Glue is a NoSQL-based data ETL tool that has some advantages over IIS and ISAs."
"We have found it beneficial when moving data from one source to another."
"Its user interface is quite good. You just need to choose some options to create a job in AWS Glue. The code-generation feature is also useful. If you don't want to customize it and simply want to read a file and store the data in the database, it can generate the code for you."
"It has good integrations with Amazon Redshift and other AWS services."
"The simplicity of this tool is nice. It has a good graphical user interface. You can also do a lot of generic stuff in the tool. If there is good connectivity to a cloud database, such as Snowflake, and you can have a lot of Snowflake functionality in the tool."
"It's been able to do everything we require."
"The most valuable feature of Matillion ETL is its ease of use. If you have had some experience with other solutions, such as Snowflake, the use of this solution will be simple."
"It has helped us to get onto the cloud quickly."
"It's highly scalable. It takes upon itself the Redshift scalability, so it's very good."
"The tool's middle-dimensional structure significantly simplifies obtaining the right data at the appropriate level. This feature makes deploying our applications easier since we utilize a single source without publishing data from various sources."
"The most valuable feature of Matillion ETL is the ETL. The solution is open-source which provides advantages, such as good performance and high efficiency. Additionally, it supports three data types which eliminates predefining the data, and we can write script models in Python."
"In terms of performance, if they can further optimize the execution time for serverless jobs, it would be a welcome improvement."
"I haven't looked into Glue in terms of seeking out flaws. I've not come across missing features."
"Glue could perform better. It sometimes takes too long to test a Glue job. Google Cloud Platform offers more Python scripts than AWS."
"The product is expensive for data streaming. This area needs improvement."
"Cost-wise, AWS Glue is expensive, so that's an area for improvement. The process for setting up the solution was also complex, which is another area for improvement."
"The solution’s stability could be improved."
"Currently, it supports only two languages in the background: Python and Scala. From our customization point of view, it would be helpful if it can also support Java in the background."
"It fails to handle massive databases acquired from various sources."
"Unlike Snowflake which automatically takes care of upgrading to the latest version and includes additional features, with Matillion ETL we need to do this ourselves."
"When using the SQL loader type there were not a lot of pre-processing features for the data. For example, if there is a table with twenty columns, but we only want to load ten columns. In that case, we can use a security script to select the specific columns needed. However, if we want to perform extensive pre-processing of the data, I faced some challenges with Matillion ETL. I did not encounter many challenges, but my overall experience is limited as I only have three years of experience."
"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."
"Performance can be improved for efficiency, and it can be made faster."
"I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly."
"The cost of the solution is high and could be reduced."
"The tool's lineage is very weak."
"To complete the pipeline, they might want to include some connectors which would put the data into different platforms. This would be helpful."
AWS Glue is ranked 1st in Cloud Data Integration with 37 reviews while Matillion ETL is ranked 4th in Cloud Data Integration with 24 reviews. AWS Glue is rated 7.8, while Matillion ETL is rated 8.6. The top reviewer of AWS Glue writes "Provides serverless mechanism, easy data transformation and automated infrastructure management". On the other hand, the top reviewer of Matillion ETL writes "Efficient data integration and transformation with seamless cloud-native integration". AWS Glue is most compared with AWS Database Migration Service, Informatica PowerCenter, SSIS, Informatica Cloud Data Integration and Palantir Foundry, whereas Matillion ETL is most compared with Snowflake, Azure Data Factory, Informatica PowerCenter, SSIS and Informatica Cloud Data Integration. See our AWS Glue vs. Matillion ETL report.
See our list of best Cloud Data Integration vendors.
We monitor all Cloud Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.