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

FME vs Matillion ETL comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

FME
Average Rating
8.6
Number of Reviews
5
Ranking in other categories
Data Integration (26th)
Matillion ETL
Average Rating
8.4
Number of Reviews
26
Ranking in other categories
Cloud Data Integration (5th)
 

Featured Reviews

Alan Bloor - PeerSpot reviewer
Nov 8, 2023
Great for handling large volumes of data, but it is priced a bit high
When I do coding, I think about every single function. Some of these functions can be very elementary, like doing a substring or some capitalization. But FME removes all that coding because it's a transformer, so the time to develop an application to get to a point where you're producing results is decreased massively. It used to take weeks and months to develop software, and now I can use something like FME, and within one day, we get results. We can look at and validate data. We make minor subtle changes to the workbenches to improve it. We can share the workbenches. We don't have to use GitHub or anything else.
AntonHaupt - PeerSpot reviewer
Jan 23, 2024
Efficient data integration and transformation with seamless cloud-native integration
In our small business unit, we currently have around four users, with two of them utilizing Matillion within our organization. Considering our growing needs, we're contemplating transitioning to an enterprise SaaS solution where we would share the same instance. Currently, each user is billed individually, but consolidating to a shared instance seems more efficient. Scalability is excellent when using the SaaS solution, easily reaching a rating of ten out of ten. Each data pipeline request is encapsulated within a Docker container and spun off, allowing for instant scalability. Overall, I would rate it a nine out of ten in terms of performance and scalability.

Quotes from Members

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

Pros

"We make minor subtle changes to the workbenches to improve it. We can share the workbenches. We don't have to use GitHub or anything else."
"It has a very friendly user interface. You don't need to use a lot of code. For us that's the most important aspect about it. Also, it has a lot of connectors and few forms. It has a strong facial aspect. It can do a lot of facial analysis."
"It has standard plug-ins available for different data sources."
"The most valuable feature of FME is the graphical user interface. There is nothing better. It is very easy to debug because you can see all steps where there are failures. Overall the software is easy to optimize a process."
"All spatial features are unrivaled, and the possibility to execute them based on a scheduled trigger, manual, e-mail, Websocket, tweet, file/directory change or virtually any trigger is most valuable."
"The tool's middle-dimensional structure significantly simplifies obtaining the right data at the appropriate level. This feature makes deploying our applications easier since we utilize a single source without publishing data from various sources."
"The technical support treats us well. They already have a support portal, and they are responsive, which helps."
"It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."
"The loading of data is the most valuable feature of Matillion ETL."
"It's been able to do everything we require."
"It can scale to a great extent. It can handle the load that we are putting on it, which is about 5TBs."
"Matillion ETL helps manage data movement, ingestion, and transformation through pipelines."
"It is pretty user-friendly, even for people who aren't super technical."
 

Cons

"FME can improve the geographical transformation. I've had some problems with the geographical transformations, but it's probably mostly because I'm not the most skilled geographer in-house. The solution requires some in-depth knowledge to perform some functions."
"The one thing that always appears in the community is the ability to make really easy loops to loop through data efficiently. That needs to be added at some point."
"FME's price needs improvement for the African market."
"Improvements could be made to mapping presentations."
"To get a higher rating, it would have to improve the price and the associated scalability. These are the main issues."
"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 needs integration with more data sources."
"Ideally, I would like it to integrate with Secrets Manager as well as the AWS."
"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."
"I am looking forward to seeing the expansion of the source range for their data loader product."
"To complete the pipeline, they might want to include some connectors which would put the data into different platforms. This would be helpful."
"In the next release, we would like to have connections to more databases."
"The product must enhance its near-real-time data capture feature."
 

Pricing and Cost Advice

"We used the standard licensing for our use of FME. The cost was approximately €15,000 annually. We always welcome less expensive solutions, if the solution could be less expensive it would be helpful."
"The product's price is reasonable."
"FME Server used to cost £10,000; now it can cost over £100,000."
"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."
"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 cost of the solution is high and could be reduced."
"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."
"The pricing depends on what edition the customer opts for. For example, the standard edition is priced at $2.00 per credit. And you are only charged when you use it. You're not charged when it's idle."
"I think it is cost conscious. It used to be very cheap and they have more recently bumped up the pricing, so it is competitive now."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
814,649 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Government
30%
Energy/Utilities Company
12%
Computer Software Company
8%
Manufacturing Company
5%
Financial Services Firm
16%
Computer Software Company
15%
Manufacturing Company
9%
Government
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What do you like most about FME?
We make minor subtle changes to the workbenches to improve it. We can share the workbenches. We don't have to use GitHub or anything else.
What is your experience regarding pricing and costs for FME?
The pricing is really bad. Last year, they rebranded the whole pricing structure. It used to be moderately priced at about £400 per user per year. Now they've changed the whole thing, and it's expe...
What needs improvement with FME?
The one thing that always appears in the community is the ability to make really easy loops to loop through data efficiently. That needs to be added at some point. There must be a technical or comm...
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?
The solution's pricing is not based on the licensing cost but on the running hours when the Matillion instance is up and running. Its pricing model is different from the traditional pricing models ...
What needs improvement with Matillion ETL?
Depending on the use case, the solution's pricing could be improved. Matillion ETL should include more enhanced capabilities for extracting data from the SAP systems.
 

Comparisons

 

Also Known As

No data available
Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery
 

Overview

 

Sample Customers

Shell, US Department of Commerce, PG&E, BC Hydro, City of Vancouver, Enel, Iowa DoT, San Antonio Water System
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 FME vs. Matillion ETL and other solutions. Updated: October 2024.
814,649 professionals have used our research since 2012.