Compare Matillion ETL vs. Pentaho Data Integration

Cancel
You must select at least 2 products to compare!
Most Helpful Review
Find out what your peers are saying about Informatica, Microsoft, Talend and others in Data Integration Tools. Updated: July 2021.
521,690 professionals have used our research since 2012.
Quotes From Members

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

Pros
"It's highly scalable. It takes upon itself the Redshift scalability, so it's very good.""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."

More Matillion ETL Pros »

"The solution has a free to use community version.""The amount of data that it loads and processes is good.""Pentaho Data Integration is quite simple to learn, and there is a lot of information available online.""It's my understanding that the product can scale."

More Pentaho Data Integration Pros »

Cons
"Ideally, I would like it to integrate with Secrets Manager as well as the AWS.""It can have multi-environment support. We should be able to deploy it in different environments. Its integration with SAP connection is not so nice, which should be improved. It can also support an on-prem database."

More Matillion ETL Cons »

"It's not very stable, at least not in the case of the community edition. I'm working with the community edition right now and I think perhaps it is because of that it is not very stable, it causes the system to sometimes hang. I'm not sure if this is the case for pair tiers.""I would like to see improvements made for real-time data processing.""I'm still in the very recent stage concerning Pentaho Data Integration, but it can't really handle what I describe as "extreme data processing" i.e. when there is a huge amount of data to process. That is one area where Pentaho is still lacking.""The product needs more plugins."

More Pentaho Data Integration Cons »

Pricing and Cost Advice
"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.""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."

More Matillion ETL Pricing and Cost Advice »

"The price of the regular version is not reasonable and it should be lower.""Sometimes we provide the licenses or the customer can procure their own licenses. Previously, we had an enterprise license. Currently, we are on a community license as this is adequate for our needs."

More Pentaho Data Integration Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
521,690 professionals have used our research since 2012.
Questions from the Community
Top Answer: 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… more »
Top Answer: 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.
Top Answer: It can have multi-environment support. We should be able to deploy it in different environments. Its integration with SAP connection is not so nice, which should be improved. It can also support an… more »
Top Answer: Hi Rajneesh, yes here is the feature comparison between the community and enterprise edition :… more »
Top Answer: Depends upon the technologies being used. If you're using Oracle for both OLTP and OLAP then you'll get a lot of value from an Oracle solution. The other question is how up to date do you want your… more »
Top Answer: Pentaho Data Integration is quite simple to learn, and there is a lot of information available online.
Ranking
6th
Views
9,944
Comparisons
6,978
Reviews
2
Average Words per Review
678
Rating
8.5
16th
Views
9,073
Comparisons
7,460
Reviews
3
Average Words per Review
652
Rating
7.7
Popular Comparisons
Also Known As
Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery
Kettle
Learn More
Overview

Matillion ETL for Redshift is a fast, modern, easy-to-use and powerful ETL/ELT tool that makes it simple and productive to load and transform data on Amazon Redshift.  100 x faster than traditional ETL technology, up and running in under 5 minutes and prices from $1.37 per hour, with no commitments or up-front costs.

Pentaho data integration prepares and blends data to create a complete picture of your business that drives actionable insights. The complete data integration platform delivers accurate, "analytics ready" data to end users from any source. With visual tools to eliminate coding and complexity, Pentaho puts big data and all data sources at the fingertips of business and IT users alike.

Offer
Learn more about Matillion ETL
Learn more about Pentaho Data Integration
Sample Customers
Thrive Market, MarketBot, PWC, Axtria, Field Nation, GE, Superdry, Quantcast, Lightbox, EDF Energy, Finn Air, IPRO, Twist, Penn National Gaming Inc
66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute
Top Industries
VISITORS READING REVIEWS
Computer Software Company32%
Comms Service Provider12%
Energy/Utilities Company6%
Financial Services Firm6%
REVIEWERS
Government15%
Comms Service Provider15%
Healthcare Company15%
Financial Services Firm15%
VISITORS READING REVIEWS
Computer Software Company28%
Comms Service Provider20%
Financial Services Firm8%
Government7%
Company Size
REVIEWERS
Small Business40%
Midsize Enterprise30%
Large Enterprise30%
REVIEWERS
Small Business28%
Midsize Enterprise24%
Large Enterprise48%
Find out what your peers are saying about Informatica, Microsoft, Talend and others in Data Integration Tools. Updated: July 2021.
521,690 professionals have used our research since 2012.

Matillion ETL is ranked 6th in Cloud Data Integration with 2 reviews while Pentaho Data Integration is ranked 16th in Data Integration Tools with 4 reviews. Matillion ETL is rated 8.6, while Pentaho Data Integration is rated 7.8. The top reviewer of Matillion ETL writes "An inexpensive solution that's very fast and extremely easy to use". On the other hand, the top reviewer of Pentaho Data Integration writes "Free to use, easy to set up, and has a great metadata injection feature". Matillion ETL is most compared with Talend Open Studio, Informatica PowerCenter, Azure Data Factory, Informatica Cloud Data Integration and StreamSets, whereas Pentaho Data Integration is most compared with Talend Open Studio, SSIS, Informatica PowerCenter, Oracle Data Integrator (ODI) and Oracle GoldenGate.

See our list of best Data Integration Tools vendors.

We monitor all Data Integration Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.