Overview
ProductRatingMost Used ByProduct SummaryStarting Price
AWS Glue
Score 7.9 out of 10
N/A
AWS Glue is a managed extract, transform, and load (ETL) service designed to make it easy for customers to prepare and load data for analytics. With it, users can create and run an ETL job in the AWS Management Console. Users point AWS Glue to data stored on AWS, and AWS Glue discovers data and stores the associated metadata (e.g. table definition and schema) in the AWS Glue Data Catalog. Once cataloged, data is immediately searchable, queryable, and available for ETL.
$0.44
billed per second, 1 minute minimum
Matillion
Score 6.9 out of 10
N/A
Matillion is a productivity platform for data teams. Matillion's Data Productivity Cloud helps data teams – coders and non-coders alike – to move, transform, and orchestrate data pipelines with the goal of empowering teams to deliver quality data at a speed and scale that matches the business’s data ambitions. The vendor states enterprises including Cisco,
$1,000
per month 500 prepaid credits (additional credits: $2.18/credit)
Pricing
AWS GlueMatillion
Editions & Modules
per DPU-Hour
$0.44
billed per second, 1 minute minimum
Basic
$1000
per month 500 prepaid credits (additional credits: $2.18/credit)
Advanced
$2000
per month 750 prepaid credits (additional credits: $2.73/credit)
Enterprise
Contact Sales
Offerings
Pricing Offerings
AWS GlueMatillion
Free Trial
NoYes
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoYes
Entry-level Setup FeeNo setup feeNo setup fee
Additional DetailsBilled directly via cloud marketplace on an hourly basis, with annual subscriptions available depending on the customer's cloud data warehouse provider.
More Pricing Information
Community Pulse
AWS GlueMatillion
Considered Both Products
AWS Glue

No answer on this topic

Matillion
Chose Matillion
Matillion provided much more flexibility than the other products we tested, at a much lower price point. Other products, in my view, had a cleaner/simpler UI but I also felt that they offered much less functionality. A key design pattern we had to deliver was to perform delta …
Chose Matillion
The Matillion selection was not my decision. But I think it's a good enough choice. It is especially valuable that the team can learn Matillion easily and that the project can be understood by the entire team with the visual environment instead of complex ETLs.
Chose Matillion
Removes most of the complexity around setting up and preparing things.
If you could describe with words what needs to be done to move data from A to B, the implementation in Matillion would probably be the most similar in terms of simplicity of understanding what you are doing …
Chose Matillion
Matillion is much easier to set up and easier to work for the team. Offers a lot more connections which are easier to set up. Environment variables make it easy to set up once and job creation is easy. We use Metadata tables to just loop through the list of tables that need to …
Chose Matillion
Overall had a better value for money
Chose Matillion
When compared with other technologies , Matillion was cost effective , more scalable and flexible in terms of complexity and components. The licensing cost of Matillion was also less and the flexibility with components helps in implementing complex business logics. The training …
Chose Matillion
Matillion has better documentation, is easier to pick up on, and is better supported. Glue doe shave pyspark though and might handle Big Data more effectively.
Chose Matillion
It is much easier to use in terms of GUI capabilities. The only reason we would use an ETL tool other than our own manually written SQL scripts, is to be able to allow other engineers to use it without having one domain expert stuck on the inner working of complex scripts. So …
Chose Matillion
At that time, ~3 years ago, none of the competitors were as easy to start using as Matillion. As our team was not so experienced with ETL, Matillion was the best and easiest way to get our hands dirty with defining pipelines.
Chose Matillion
It has a drag-&-drop graphical UI, which makes it easy to connect all the components together. It's very fast to set up from cloud marketplace. It supports many data sources and it also provides a customizable data source component.
Top Pros
Top Cons
TrustRadius Insights
AWS GlueMatillion
Highlights

TrustRadius
Research Team Insight
Published

AWS Glue and Matillion are both software designed to help organizations extract and transform business data. AWS Glue is a data preparation tool, designed to help businesses prepare data for analysis, bypassing a data warehouse when possible.  Matillion is a data integration tool designed to help businesses quickly pool together data from multiple sources such as SaaS applications.

Features

AWS Glue and Matillion both provide ETL features, but they also have a few unique features that set them apart from each other.

AWS Glue has support for data lakes, allowing businesses to prepare and integrate raw data and blob files with ease. Additionally, developers can create scripts to integrate data into AWS Glue that isn’t natively supported using Python or Scala. Lastly, AWS Glue helps businesses keep their business data compliant with regulatory guidelines including HIPAA and GDPR, making it a good choice for medical businesses.

Matillion provides built in support for over 40 SaaS applications.  This makes Matillion a good choice for businesses with many applications they need to pull data from, particularly if they lack the resources or ability to make custom integrations.  Additionally, Matillion provides features for data ingestion and business intelligence.

Limitations

Though AWS Glue and Matillion both help organizations transform data, they also have some limitations that are important to consider.

AWS Glue doesn’t provide built in integrations for SaaS application, though it is possible to build custom integrations.  For businesses with limited resources or without a dedicated development team, AWS Glue may not provide enough support for data integration.  Additionally, AWS Glue includes some analytics features, but ultimately provides limited business intelligence features.

Matillion offers support for SaaS applications, but doesn’t provide significant support for building out new integrations.  Businesses with niche applications that aren’t covered by Matillion may consider other options.  Additionally, Matillion offers support for ensuring regulatory compliance, but only for GDPR.  Businesses storing medical data may prefer other options that also ensure HIPAA compliance.

Pricing

AWS Glue pricing depends on the needs of the business and the amount of data processes performed.  Despite this, AWS does provide some pricing examples so businesses have an idea of what they might be spending, such as this: “$0.44 per DPU-Hour, billed per second, with a 1-minute minimum for each ETL job of type Python shell”.  Businesses looking for specific pricing information can reach out to the vendor for a quote.

Matillion pricing similarly depends on the needs of the business, but it starts as low as $1.37 an hour and offers support for Amazon Redshift, Google BigQuery, Azure Synapse Analytics, and Snowflake.

Features
AWS GlueMatillion
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
AWS Glue
-
Ratings
Matillion
7.7
132 Ratings
8% below category average
Connect to traditional data sources00 Ratings7.9131 Ratings
Connecto to Big Data and NoSQL00 Ratings7.491 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
AWS Glue
-
Ratings
Matillion
6.6
133 Ratings
21% below category average
Simple transformations00 Ratings7.1133 Ratings
Complex transformations00 Ratings6.1132 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
AWS Glue
-
Ratings
Matillion
7.4
125 Ratings
6% below category average
Data model creation00 Ratings9.133 Ratings
Metadata management00 Ratings9.140 Ratings
Business rules and workflow00 Ratings7.1117 Ratings
Collaboration00 Ratings5.2117 Ratings
Testing and debugging00 Ratings5.4118 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
AWS Glue
-
Ratings
Matillion
8.2
23 Ratings
1% above category average
Integration with data quality tools00 Ratings8.222 Ratings
Integration with MDM tools00 Ratings8.220 Ratings
Best Alternatives
AWS GlueMatillion
Small Businesses
IBM SPSS Modeler
IBM SPSS Modeler
Score 7.6 out of 10
Skyvia
Skyvia
Score 10.0 out of 10
Medium-sized Companies
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
Enterprises
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
AWS GlueMatillion
Likelihood to Recommend
7.0
(8 ratings)
6.4
(134 ratings)
Likelihood to Renew
-
(0 ratings)
8.6
(6 ratings)
Usability
7.0
(1 ratings)
5.9
(133 ratings)
Support Rating
7.0
(1 ratings)
7.4
(7 ratings)
Implementation Rating
-
(0 ratings)
8.2
(1 ratings)
Product Scalability
-
(0 ratings)
5.8
(127 ratings)
Vendor post-sale
-
(0 ratings)
9.1
(1 ratings)
Vendor pre-sale
-
(0 ratings)
9.1
(1 ratings)
User Testimonials
AWS GlueMatillion
Likelihood to Recommend
Amazon AWS
One of AWS Glue's most notable features that aid in the creation and transformation of data is its data catalog. Support, scheduling, and the automation of the data schema recognition make it superior to its competitors aside from that. It also integrates perfectly with other AWS tools. The main restriction may be integrated with systems outside of the AWS environment. It functions flawlessly with the current AWS services but not with other goods. Another potential restriction that comes to mind is that glue operates on a spark, which means the engineer needs to be conversant in the language.
Read full review
Matillion
When my team receives a request to import data in from a new place, it's great to have a tool where you can set up those imports in minutes, yet have the capabilities to create customized and complex orchestration as time allows. Because it's easy to send SFTP exports, my internal customers are sometimes surprised that it's not as easy to perform other exports such as e-mailed files or API integrations. If Matillion had output components as varied and excellent as the import components, it would be the perfect solution for so many things we do.
Read full review
Pros
Amazon AWS
  • It is extremely fast, easy, and self-intuitive. Though it is a suite of services, it requires pretty less time to get control over it.
  • As it is a managed service, one need not take care of a lot of underlying details. The identification of data schema, code generation, customization, and orchestration of the different job components allows the developers to focus on the core business problem without worrying about infrastructure issues.
  • It is a pay-as-you-go service. So, there is no need to provide any capacity in advance. So, it makes scheduling much easier.
Read full review
Matillion
  • Matillion has a rich transformation library. It provides multiple functionalities, such as join, group by, pivot, various sources, and sinks.
  • It provides the security capability as well. All the credentials can be securely stored in Matillion.
  • Reusable templates can be built which reduces the redundancy.
  • Time to production is very minimal.
Read full review
Cons
Amazon AWS
  • In-Stream schema registries feature people can not use this more efficiently
  • in Connections feature they can add more connectors as well
  • The crucial problem with AWS Glue is that it only works with AWS.
Read full review
Matillion
  • Static and monolithic, it will show its limits when running multiple concurrent jobs.
  • Github and versioning implementation is messy and broken. Don't use it.
  • There's not way to see/query the system resources, just wait for a server to crash due to out of memory. An admin panel would be appreciated + some env variables with updated info.
  • API implementation is cumbersome and limited.
  • There's no concept of hub and worker engine, everything happens of the same server (designing workflows and executing them). Having separate light ETL engines to run job could be better. (sort of docker/kubernetes/lambda functions).
  • Handling of variables is limited especially for returned values from sub components.
  • Some components could return more metadata at the end of their execution instead of the standard one.
  • Billing is badly designed not taking into account that the server is hosted by the client. Expensive.
  • We had several issue with migration where starting a new instance was required and then migrating the content. It was painful and time consuming also have to deal with support and engineering team on Matillion side.
  • CDC doesn't work as expected or it is not a mature product yet.
Read full review
Likelihood to Renew
Amazon AWS
No answers on this topic
Matillion
With the current experience of Matillion, we are likely to renew with the current feature option but will also look for improvement in various areas including scalability and dependability. 1. Connectors: It offers various connectors option but isn't full proof which we will be looking forward as we grow. 2. Scalability: As usage increase, we want Matillion system to be more stable.
Read full review
Usability
Amazon AWS
We give 7 rating because of usefulness in AWS world without worrying about infrastructure and services interaction, it’s pretty out of the box gives us the flexibility to interact with them and use them. we take the data source in s3 from external system and then transform it using other AWS services and putting it back for other external services to consume in S3 form.
Read full review
Matillion
We are able to bring on new resources and teach them how to use Matillion without having to invest a significant amount of time. We prefer looking for resources with any type of ETL skill-set and feel that they can learn Matillion without problem. In addition, the prebuilt objects cover more than 95% of our use cases and we do not have to build much from scratch.
Read full review
Support Rating
Amazon AWS
Amazon responds in good time once the ticket has been generated but needs to generate tickets frequent because very few sample codes are available, and it's not cover all the scenarios.
Read full review
Matillion
Overall, I've found Matillion to be responsive and considerate. I feel like they value us as a customer even when I know they have customers who spend more on the product than we do. That speaks to a motive higher than money. They want to make a good product and a good experience for their customers. If I have any complaint, it's that support sometimes feels community-oriented. It isn't always immediately clear to me that my support requests are going to a support engineer and not to the community at large. Usually, though, after a bit of conversation, it's clear that Matillion is watching and responding. And responses are generally quick in coming.
Read full review
Implementation Rating
Amazon AWS
No answers on this topic
Matillion
We were able to control on access and built various enviroment for implementation
Read full review
Alternatives Considered
Amazon AWS
AWS Glue is a fully managed ETL service that automates many ETL tasks, making it easier to set AWS Glue simplifies ETL through a visual interface and automated code generation.
Read full review
Matillion
Fivetran offers a managed service and pre-configured schemas/models for data loading, which means much less administrative work for initial setup and ongoing maintenance. But it comes at a much higher price tag. So, knowing where your sweet spot is in the build vs. buy spectrum is essential to deciding which tool fits better. For the transformation part, dbt is purely (SQL-) code-based. So, it is mainly whether your developers prefer a GUI or code-based approach.
Read full review
Scalability
Amazon AWS
No answers on this topic
Matillion
We're using Matillion on EC2 instances, and we have about 20 projects for our clients in the same instance. Sometimes, we're struggling to manage schedules for all projects because thread management is not visible, and we can't see the process at the instance level.
Read full review
Return on Investment
Amazon AWS
  • It had a positive impact on the way we build our data lake.
  • It is the single source of truth for data structure (schemas/tables/views).
Read full review
Matillion
  • Matillion has been the backbone of my company's analytical functionalities for 10+ years, so it has a good ROI.
  • The price is ok for what our company built with it, but it starts to be less competitive if the tool is not used at its fullest.
Read full review
ScreenShots

Matillion Screenshots

Screenshot of Matillion's GUI, used to orchestrate jobs with control data flow functionality, automating the ETL process.Screenshot of where structured and semi-structured data can be prepared to create clean data sets that can be used with any BI/reporting/visualization tool of choice. Matillion reads and combines data across a target warehouse external storage, such as S3 or Blob.Screenshot of Matillion's self-validating components, sample and row counts. If a job does fail, the warehouse queue services available with Matillion can be used get an alert to a connected email or Slack account.Screenshot of the SQL component used to run custom scripts from within Matillion. With hundreds of pre-built connectors out of the box, Matillion can handle complex transformation needs.