No more typing reviews! Try our Samantha, our new voice AI agent.
Matillion Data Productivity Cloud Logo

Matillion Data Productivity Cloud pros and cons

Vendor: Matillion
4.2 out of 5

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 Data Productivity Cloud enables non-technical users to load data into data warehouses without always requiring a technical expert.
It integrates well with Amazon Redshift and other AWS services and offers easy connectivity to cloud databases like Snowflake.
Matillion Data Productivity Cloud handles large data loads effectively, with scalability up to and beyond 5TB.
The platform offers a stable performance and supports multiple data types, including script models in Python.
Matillion Data Productivity Cloud features a Change Data Capture component, and its technical support is responsive and effective.

CONS

Matillion Data Productivity Cloud needs more database connections and integration with additional ecosystems, including Governance Tools and SAP systems.
There are limitations in performance efficiency, and integration with on-prem databases lacks improvement, which affects scalability.
Matillion Data Productivity Cloud relies on manual code writing for data extraction and pre-processing, which adds complexity to the workflow.
The tool's deployment is limited by its current virtual machine setup, restricting the execution of multiple processes simultaneously.
The cost of Matillion Data Productivity Cloud is high, and there is also a need for enhanced near-real-time data capture features.
 

Matillion Data Productivity Cloud Pros review quotes

Jitendra Jena - PeerSpot reviewer
Director Axtria - Ingenious Insights! at Axtria - Ingenious Insights
Aug 20, 2025
The predefined connectors eliminate the need to write code for connectivity; if you have a predefined connector, it is easy to use with plug and play functionality.
DE
Technology Transformation Specialist at SDG Group
Apr 14, 2025
Matillion's technical support is excellent.
Tomáš Hronek - PeerSpot reviewer
Data Engineer at Merck
Feb 2, 2024
The most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation.
Learn what your peers think about Matillion Data Productivity Cloud. Get advice and tips from experienced pros sharing their opinions. Updated: April 2026.
893,221 professionals have used our research since 2012.
reviewer2322996 - PeerSpot reviewer
Data Architect at a financial services firm with 10,001+ employees
Jan 23, 2024
It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth
reviewer2009835 - PeerSpot reviewer
Senior Solutions Architect at a tech consulting company with 201-500 employees
Aug 12, 2024
The solution's most valuable feature is the CDC (Change Data Capture) component.
Jacques Du Preez - PeerSpot reviewer
Chief Executive Officer at Intellinexus
Mar 5, 2024
The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand.
Shehab Saad - PeerSpot reviewer
Business Intelligence Manager & Data Analytics (Retail Business) at a retailer with 1,001-5,000 employees
Jul 25, 2023
The product has a good user interface.
David Carbery - PeerSpot reviewer
Data Analytics Consultant at Snap Analytics
Oct 2, 2023
The most valuable feature of Matillion ETL is its user-friendly graphical interface.
Chris Hastie - PeerSpot reviewer
Data Lead at InterWorks
Apr 27, 2023
Matillion ETL helps manage data movement, ingestion, and transformation through pipelines.
Sunny Kumar - PeerSpot reviewer
Specialist Programmer at Infosys
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.
 

Matillion Data Productivity Cloud Cons review quotes

Jitendra Jena - PeerSpot reviewer
Director Axtria - Ingenious Insights! at Axtria - Ingenious Insights
Aug 20, 2025
Scalability in Matillion Data Productivity Cloud has some limitations. Depending on the nature of data sets, volume, and mixture of different data, the scalability could be improved as manual code writing is still required.
DE
Technology Transformation Specialist at SDG Group
Apr 14, 2025
There are problems with GCP connectivity. Specifically, connections to BigQuery for extracting information are complex, and the optimization of the extraction process requires improvements.
Tomáš Hronek - PeerSpot reviewer
Data Engineer at Merck
Feb 2, 2024
Sometimes, we have issues with the solution's stability and need to restart it for three weeks or more.
Learn what your peers think about Matillion Data Productivity Cloud. Get advice and tips from experienced pros sharing their opinions. Updated: April 2026.
893,221 professionals have used our research since 2012.
reviewer2322996 - PeerSpot reviewer
Data Architect at a financial services firm with 10,001+ employees
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.
reviewer2009835 - PeerSpot reviewer
Senior Solutions Architect at a tech consulting company with 201-500 employees
Aug 12, 2024
Matillion ETL should include more enhanced capabilities for extracting data from the SAP systems.
Jacques Du Preez - PeerSpot reviewer
Chief Executive Officer at Intellinexus
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.
Shehab Saad - PeerSpot reviewer
Business Intelligence Manager & Data Analytics (Retail Business) at a retailer with 1,001-5,000 employees
Jul 25, 2023
The product must enhance its near-real-time data capture feature.
David Carbery - PeerSpot reviewer
Data Analytics Consultant at Snap Analytics
Oct 2, 2023
I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly.
Chris Hastie - PeerSpot reviewer
Data Lead at InterWorks
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.
Sunny Kumar - PeerSpot reviewer
Specialist Programmer at Infosys
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.