Try our new research platform with insights from 80,000+ expert users
Matillion Data Productivity Cloud Logo

Matillion Data Productivity Cloud pros and cons

Vendor: Matillion
4.2 out of 5
596 followers
Start review

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

Matillion enables non-technical users to efficiently load data into data warehouses without requiring technical assistance.
It seamlessly integrates with Amazon Redshift and other AWS services, offering quick cloud onboarding.
Matillion is open-source, supports three data types, and allows scripting in Python, providing high performance and efficiency.
The tool's scalability is impressive, handling extensive data loads, such as 5TB, with ease.
Matillion offers excellent technical support with a responsive support portal and effective Git integration.

CONS

Matillion Data Productivity Cloud needs improvement in integration with more databases and support for additional data sources.
Performance efficiency and speed should be enhanced, along with better support for multi-environment deployment.
Custom job functionalities and improved pipeline completion with varied connectors are desired to meet complex data handling requirements.
Integration with Secrets Manager, AWS, and scaling on-premises capabilities are significant areas for enhancement.
GCP connectivity and BigQuery extraction require optimization, along with better support for SAP system processing.
 

Matillion Data Productivity Cloud Pros review quotes

Chris Hastie - PeerSpot reviewer
Apr 27, 2023
Matillion ETL helps manage data movement, ingestion, and transformation through pipelines.
PH
Mar 5, 2023
Matillion ETL has great Git integration that is perfect and convenient to use.
it_user987312 - PeerSpot reviewer
Sep 3, 2019
It's highly scalable. It takes upon itself the Redshift scalability, so it's very good.
Learn what your peers think about Matillion Data Productivity Cloud. Get advice and tips from experienced pros sharing their opinions. Updated: April 2025.
849,686 professionals have used our research since 2012.
reviewer2322996 - PeerSpot reviewer
Jan 23, 2024
It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth
MG
Feb 21, 2023
It's been able to do everything we require.
HS
Dec 11, 2018
It has helped us to get onto the cloud quickly.
Jacques Du Preez - PeerSpot reviewer
Mar 5, 2024
The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand.
Sunny Kumar - PeerSpot reviewer
Feb 27, 2023
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.
AS
Apr 4, 2024
The product's initial setup phase was easy.
SeniorIn7f6d - PeerSpot reviewer
Dec 11, 2018
It is pretty user-friendly, even for people who aren't super technical.
 

Matillion Data Productivity Cloud Cons review quotes

Chris Hastie - PeerSpot reviewer
Apr 27, 2023
The current version is a bit more limited because it's on a virtual machine, and everything executes on that one virtual machine.
PH
Mar 5, 2023
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.
it_user987312 - PeerSpot reviewer
Sep 3, 2019
Ideally, I would like it to integrate with Secrets Manager as well as the AWS.
Learn what your peers think about Matillion Data Productivity Cloud. Get advice and tips from experienced pros sharing their opinions. Updated: April 2025.
849,686 professionals have used our research since 2012.
reviewer2322996 - PeerSpot reviewer
Jan 23, 2024
Our main challenge currently is that Matillion runs on an EC2 instance, limiting us to running only two processes simultaneously at the entry level.
MG
Feb 21, 2023
Matillion’s on-premises capabilities don’t allow you to build something customized.
HS
Dec 11, 2018
To complete the pipeline, they might want to include some connectors which would put the data into different platforms. This would be helpful.
Jacques Du Preez - PeerSpot reviewer
Mar 5, 2024
One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems.
Sunny Kumar - PeerSpot reviewer
Feb 27, 2023
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.
AS
Apr 4, 2024
The improvement area could be possible if the tool provides better integration capabilities with other ecosystems, including governance tools or data cataloging tools, as it is currently an area where the solution is lacking.
SeniorIn7f6d - PeerSpot reviewer
Dec 11, 2018
Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion.