Try our new research platform with insights from 80,000+ expert users

ETL Solutions Transformation Manager vs Matillion Data Productivity Cloud comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Mar 31, 2025

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 (33rd)
Matillion Data Productivity...
Average Rating
8.4
Reviews Sentiment
7.4
Number of Reviews
27
Ranking in other categories
Cloud Data Integration (8th)
 

Featured Reviews

Vijayraj Amin - PeerSpot reviewer
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.
Tomáš Hronek - PeerSpot reviewer
Used for wrangling or transforming data from sources like S3 and Databricks
I use Matillion ETL for wrangling or transforming data from sources like S3 and Databricks The most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation. Sometimes, we have issues with the solution's stability and need to restart it for…

Quotes from Members

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

Pros

"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 a reliable solution."
"It is among the best, even if not widely known."
"It has good integrations with Amazon Redshift and other AWS services."
"We allow non-technical people to use Matillion to load data into our data warehouse for reporting. Thus, it is easy enough to use that we don't always have to get a technical person involved in setting up a data movement (ETL)."
"The most valuable feature of Matillion ETL is its user-friendly graphical interface."
"Matillion ETL helps manage data movement, ingestion, and transformation through pipelines."
"The most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation."
"The loading of data is the most valuable feature of Matillion ETL."
"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 is pretty user-friendly, even for people who aren't super technical."
 

Cons

"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."
"They should build a functional architecture based on queuing."
"There is room for improvement in the solution's visualization tool."
"One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems."
"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."
"Matillion ETL should include more enhanced capabilities for extracting data from the SAP systems."
"While the UI is good, it could be improved in its efficiency and made easier to use."
"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."
"I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly."
"There are problems with GCP connectivity. Specifically, connections to BigQuery for extracting information are complex, and the optimization of the extraction process requires improvements."
 

Pricing and Cost Advice

"It is an expensive solution."
"It was procured through the AWS Marketplace because it keeps things simple. They offer retail-like checkout and bill through your existing Amazon Web Services account."
"The AWS pricing and licensing are a cost-effective solution for data integration needs."
"Its price depends on what you expect. You pay on a monthly basis, but there is a possibility to have special contracts depending on the installation."
"It is not necessarily a cheap solution. However, it's reasonable priced, especially with the smaller machines that we run it on."
"The absence of licensing commitments makes it easy to experiment with the tool, and if we decide it's not suitable, we can simply stop the ETL instance and cease incurring charges."
"Matillion ETL is expensive."
"The solution is very cheap. You're paying $2.50 an hour and if you set your service up, which you can do, you're not getting charged. Currently, our ETL process is just an overnight process that runs for about an hour. I can start and stop my server just for an hour if I want to and spent $2.50 a day for an ETL solution. There are no additional costs."
"A rough estimation of the cost is around 20,000 dollars a month, however, this is dependent on the machine used and how Matillion ETL is used."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
859,533 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
27%
Financial Services Firm
18%
Healthcare Company
7%
Educational Organization
6%
Financial Services Firm
19%
Computer Software Company
15%
Manufacturing Company
8%
Energy/Utilities Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What is your experience regarding pricing and costs for ETL Solutions Transformation Manager?
ETL Solutions Transformation Manager is much more affordable than other solutions like AWS, Blue, or Informatica. Even though some competitors may offer seemingly economical pricing, the resource c...
What needs improvement with ETL Solutions Transformation Manager?
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 anal...
What do you like most about Matillion ETL?
The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand.
What is your experience regarding pricing and costs for Matillion ETL?
While pricing can be an issue compared to other solutions, Matillion Data Productivity Cloud offers discounts and special deals, especially when dealing with high-volume clients or fewer existing c...
What needs improvement with Matillion ETL?
There are problems with GCP connectivity. Specifically, connections to BigQuery for extracting information are complex, and the optimization of the extraction process requires improvements. I raise...
 

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 ETL Solutions Transformation Manager vs. Matillion Data Productivity Cloud and other solutions. Updated: June 2025.
859,533 professionals have used our research since 2012.