We performed a comparison between Matillion ETL and Pentaho Data Integration and Analytics based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It has good integrations with Amazon Redshift and other AWS services."
"Matillion ETL helps manage data movement, ingestion, and transformation through pipelines."
"The technical support treats us well. They already have a support portal, and they are responsive, which helps."
"It has helped us to get onto the cloud quickly."
"The loading of data is the most valuable feature of Matillion ETL."
"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 ETL has great Git integration that is perfect and convenient to use."
"It's been able to do everything we require."
"Provides a good open source option."
"Data transformation within Pentaho is a nice feature that they have and that I value."
"Flexible deployment, in any environment, is very important to us. That is the key reason why we ended up with these tools. Because we have a very highly secure environment, we must be able to install it in multiple environments on multiple different servers. The fact that we could use the same tool in all our environments, on-prem and in the cloud, was very important to us."
"It's very simple compared to other products out there."
"Pentaho Data Integration is quite simple to learn, and there is a lot of information available online."
"We can schedule job execution in the BA Server, which is the front-end product we're using right now. That scheduling interface is nice."
"One of the most valuable features is the ability to create many API integrations. I'm always working with advertising agents and using Facebook and Instagram to do campaigns. We use Pentaho to get the results from these campaigns and to create dashboards to analyze the results."
"One of the valuable features is the ability to use PL/SQL statements inside the data transformations and jobs."
"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."
"Ideally, I would like it to integrate with Secrets Manager as well as the AWS."
"I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly."
"While the UI is good, it could be improved in its efficiency and made easier to use."
"It needs integration with more data sources."
"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."
"Matillion’s on-premises capabilities don’t allow you to build something customized."
"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."
"There is not a data quality or MDM solution in the Pentaho DI suite."
"The product needs more plugins."
"If you develop it on MacBook, it'll be quite a hassle."
"I would like to see improvements made for real-time data processing."
"Although it is a low-code solution with a graphical interface, often the error messages that you get are of the type that a developer would be happy with. You get a big stack of red text and Java errors displayed on the screen, and less technical people can get intimidated by that. It can be a bit intimidating to get a wall of red error messages displayed. Other graphical tools that are focused at the power user level provide a much more user-friendly experience in dealing with your exceptions and guiding the user into where they've made the mistake."
"It could be better integrated with programming languages, like Python and R. Right now, if I want to run a Python code on one of my ETLs, it is a bit difficult to do. It would be great if we have some modules where we could code directly in a Python language. We don't really have a way to run Python code natively."
"A big problem after deploying something that we do in Lumada is with Git. You get a binary file to do a code review. So, if you need to do a review, you have to take pictures of the screen to show each step. That is the biggest bug if you are using Git."
"One thing that I don't like, just a little, is the backward compatibility."
More Pentaho Data Integration and Analytics Pricing and Cost Advice →
Matillion ETL is ranked 4th in Cloud Data Integration with 22 reviews while Pentaho Data Integration and Analytics is ranked 15th in Data Integration with 48 reviews. Matillion ETL is rated 8.6, while Pentaho Data Integration and Analytics is rated 8.0. The top reviewer of Matillion ETL writes "Efficient data integration and transformation with seamless cloud-native integration". On the other hand, the top reviewer of Pentaho Data Integration and Analytics writes "It's flexible and can do almost anything I want it to do". Matillion ETL is most compared with Azure Data Factory, Snowflake, AWS Glue, Informatica PowerCenter and SSIS, whereas Pentaho Data Integration and Analytics is most compared with Azure Data Factory, SSIS, Talend Open Studio, AWS Glue and Oracle Data Integrator (ODI). See our Matillion ETL vs. Pentaho Data Integration and Analytics report.
See our list of best Cloud Data Integration vendors.
We monitor all Cloud Data Integration 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.