No more typing reviews! Try our Samantha, our new voice AI agent.

ETL Solutions Transformation Manager vs Matillion Data Productivity Cloud comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 18, 2026

Review summaries and opinions

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

Categories and Ranking

ETL Solutions Transformatio...
Average Rating
9.0
Reviews Sentiment
6.8
Number of Reviews
3
Ranking in other categories
Data Integration (53rd)
Matillion Data Productivity...
Average Rating
8.4
Reviews Sentiment
7.4
Number of Reviews
28
Ranking in other categories
Cloud Data Integration (13th), AI Data Analysis (23rd)
 

Featured Reviews

Vijayraj Amin - PeerSpot reviewer
Global Growth Strategist at MAIORA
User-friendly and accessible for anyone with computer knowledge and logical thinking
There is room for improvement in the solution's visualization tool. Currently, it provides basic reports and the ability to create graphs and dashboards, but I'm looking forward to more robust analytics. The plan is to enhance this feature in 2024, around Q2 or Q3, which would save us from relying on external tools like Power BI for insights.
Jitendra Jena - PeerSpot reviewer
Director Axtria - Ingenious Insights! at Axtria - Ingenious Insights
Easy integration and workflow proposals streamline processes
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. The processing time and ease of use are significant benefits. As everyone is moving into AI integration, it will definitely help. When creating workflows, they can propose solutions directly.

Quotes from Members

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

Pros

"It is a reliable solution."
"Back in the day, we could only get reports and analyze what happened after the fact, but today now we can generate real-time insights. Transformation Manager feeds your data science projects. We generate models and then give them to the clients, so they can come up with real-time predictions and recommendations in addition to reporting."
"It is among the best, even if not widely known."
"Transformation Manager is the backbone of every data pipeline these days because the solution has been on the market for 20 to 30 years, and we use it for various industries, including financial services, manufacturing, healthcare, etc."
"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."
"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."
"It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."
"On a new project using Matillion, it took me 10 minutes to set up and begin importing data from Safesforce.com."
"I would recommend Matillion ETL for any cloud-based operations."
"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 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 improved the costs of managing my customer’s data."
 

Cons

"They should build a functional architecture based on queuing."
"We get decent support. It's okay but not great."
"Transformation Manager reporting could be better. There are better options for reporting tools these days. We use Microsoft BI sometimes, but Tableau is becoming too expensive. Microsoft BI's visualization features are maturing."
"There is room for improvement in the solution's visualization tool."
"Ideally, I would like it to integrate with Secrets Manager as well as the AWS."
"One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems."
"The tool's lineage is very weak."
"Our main challenge currently is that Matillion runs on an EC2 instance, limiting us to running only two processes simultaneously at the entry level."
"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."
"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."
"More frequent releases are needed, due to API changes from Google, Marketo, and Facebook."
"Matillion ETL should include more enhanced capabilities for extracting data from the SAP systems."
 

Pricing and Cost Advice

"It is an expensive solution."
"The product must improve its pricing."
"The solution's pricing is not based on the licensing cost but on the running hours when the Matillion instance is up and running."
"Matillion ETL is expensive."
"It is not necessarily a cheap solution. However, it's reasonable priced, especially with the smaller machines that we run it on."
"It is cost-effective. Based on our use case, it's efficient and cheap. It saves a lot of money and our upfront costs are less."
"Purchasing it through the AWS Marketplace is pretty convenient. There is a little bit of back and forth in terms of the licensing based on the machine size, but it seems to have worked out well. it is convenient to have it all as part of our AWS billing."
"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."
"The AWS pricing and licensing are a cost-effective solution for data integration needs."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
909,948 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Outsourcing Company
13%
Construction Company
13%
Computer Software Company
10%
Performing Arts
7%
Construction Company
11%
Financial Services Firm
9%
Computer Software Company
9%
Manufacturing Company
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business6
Midsize Enterprise10
Large Enterprise11
 

Questions from the Community

Ask a question
Earn 20 points
What is your experience regarding pricing and costs for Matillion ETL?
The pricing is managed by the tooling team. The pricing is moderate, neither expensive nor cheap.
What needs improvement with Matillion ETL?
The main areas for improvement are AI features and scalability.
What is your primary use case for Matillion ETL?
For the ETL, we are using Matillion Data Productivity Cloud. We have skilled resources for Matillion Data Productivity Cloud, which is why we are using it. The infrastructure is provided by the cus...
 

Also Known As

Transformation Manager
Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery
 

Overview

 

Sample Customers

Honda, BNP Paribas, RBS, JPMorgan, Volkswagen, Thorn Lighting, OpenSpirit, Rolls-Royce, Ulster Bank
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 Amazon Web Services (AWS), Informatica, Palantir and others in Cloud Data Integration. Updated: August 2026.
909,948 professionals have used our research since 2012.