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

Pentaho Data Integration and Analytics vs Tray.io comparison

 

Comparison Buyer's Guide

Executive Summary

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

Pentaho Data Integration an...
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
60
Ranking in other categories
Data Integration (7th)
Tray.io
Average Rating
7.4
Reviews Sentiment
5.9
Number of Reviews
3
Ranking in other categories
Process Automation (29th), Cloud Data Integration (22nd), Low-Code Development Platforms (27th), Integration Platform as a Service (iPaaS) (17th)
 

Featured Reviews

Michelle Lawson - PeerSpot reviewer
Principal Software Engineer at a tech vendor with 10,001+ employees
Streamlines complex data workflows and has supported automated customer payment notifications
I haven't used Pentaho Data Integration and Analytics in a couple of years, so I don't know how it can be improved. I was pretty pleased with it and was self-taught on it, working a lot with their team at various times, but they were surprised that I was able to learn it all by myself. The documentation is not bad, and documentation is the main thing that any product can do to make themselves better because the easier it is to find examples of what you're trying to do improves the learning curve. I think it took me the longest to learn how to do the asynchronous processing and have things wait for other things to finish processing before continuing on in the workflow. I choose 8 out of 10 because the one reason that it's been rejected at T-Mobile is that everything has to go through a provisioning process and has to get approved, meaning the actual code base has to be investigated by T-Mobile before they'll allow us to use tools of that nature. For whatever reason, we just haven't been able to get that approval; I don't know if it's on Pentaho Data Integration and Analytics' side or if it's on our side. The more you can make it easier for companies to feel comfortable that your product is secure, robustly tested and bug-free, and free of any other kind of negative hacks, the more quickly it will get accepted.
SS
Principal AI and Data Science Engineer at a manufacturing company with 10,001+ employees
Marketing A/B tests have gained deeper insights from user behavior and unified global reporting
The best features Tray.io offers include excellent visualization capabilities and a dashboard, which stand out to me the most. I appreciate that it is very easy to convert the data we receive from Tray.io into dashboards from Power BI, which is extremely useful. I would also appreciate if in the future Tray.io provides a way to natively convert the data to Tableau. Tray.io has positively impacted my organization as it provides a trusted way to organize data results and share them throughout the company at once. As a multinational and very large company, it is definitely beneficial that those of us in the UK can use the same format that colleagues use in India, and the entire data architecture is framed within a trusted system from an established organization. As far as I know, Tray.io has been operating for the last 12 years, making it a very reliable system.

Quotes from Members

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

Pros

"The way it has improved our product is by giving our users the ability to do ad hoc reports, which is very important to our users. We can do predictive analysis on trends coming in for contracts, which is what our product does. The product helps users decide which way to go based on the predictive analysis done by Pentaho. Pentaho is not doing predictions, but reporting on the predictions that our product is doing. This is a big part of our product."
"The graphical nature of the development interface is most useful because we've got people with quite mixed skills in the team. We've got some very junior, apprentice-level people, and we've got support analysts who don't have an IT background. It allows us to have quite complicated data flows and embed logic in them. Rather than having to troll through lines and lines of code and try and work out what it's doing, you get a visual representation, which makes it quite easy for people with mixed skills to support and maintain the product. That's one side of it."
"The solution has a free to use community version."
"I find the drag and drop feature in Pentaho Data Integration very useful for integration."
"It is a very good tool if you need to work with data."
"I can create faster instructions than writing with SQL or code. Also, I am able to do some background control of the data process with this tool. Therefore, I use it as an ELT tool. I have a station area where I can work with all the information that I have in my production databases, then I can work with the data that I created."
"Sometimes, it took a whole team about two weeks to get all the data to prepare and present it, and after the optimization of the data, it took about one to two hours to do the whole process."
"Data transformation within Pentaho is a nice feature that they have and that I value."
"Tray.io has positively impacted my organization as it provides a trusted way to organize data results and share them throughout the company at once."
"Tray.io has positively impacted my organization by reducing the amount of redundant tasks that our team performs by approximately 80%, and the numbers are quite significant with the workflows alone, as we are working towards creating and utilizing AI within these workflows as well."
"Tray.io has positively impacted my organization by helping us keep our internal database and this third-party service in sync, and it has really helped us automate a lot of that work because it is fairly straightforward to maintain and develop."
 

Cons

"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."
"For managing very large volumes of data, Pentaho Data Integration and Analytics is not the best tool, but it is in a good position to handle millions of records."
"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."
"I would like to see improvement when it comes to integrating structured data with text data or anything that is unstructured. Sometimes we get all kinds of different files that we need to integrate into the warehouse."
"The initial version we were on was v3.2 and we had multiple issues, but currently don't find any issues as a blocker."
"If you're working with a larger data set, I'm not so sure it would be the best solution; the larger things got the slower it was and it was kind of buggy sometimes."
"​I could not connect to our Hadoop environment in an easy and flexible way, and it was important to scale our data warehouse​."
"Upgrading the bi-platform is a little pain, but the rest is easy to use and to set up."
"I have found that the error management in my main use case with Tray.io is not as effective as we would prefer."
"As our product got more complex, we needed to add more and more complexity to Tray.io in terms of our setup, and that is when the benefits of it being no-code or low-code started to pale in comparison to the cost of making everything slightly more complicated."
"One way Tray.io could be improved, especially for people coming in with no real coding experience, is with more comprehensive error messages."
 

Pricing and Cost Advice

"You need to go through the paid version to have Hitachi Lumada specialized support. However, if you are using the free version, then you will have only the community support. You will depend on the releases from Hitachi to solve some problem or questions that you have, such as bug fixes. You will need to wait for the newest versions or releases to solve these types of problems."
"It does seem a bit expensive compared to the serverless product offering. Tools, such as Server Integration Services, are "almost" free with a database engine. It is comparable to products like Alteryx, which is also very expensive."
"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."
"I mostly used the open-source version. I didn't work with a license."
"I use it because it is free. I download from their page for free. I don't have to pay for a license. With other tools, I have to pay for the licenses. That is why I use Pentaho."
"There was a cost analysis done and Pentaho did favorably in terms of cost."
"For most development tasks, the Enterprise edition should be sufficient. It depends on the type of support that you require for your production environment."
"When we first started with it, it was much cheaper. It has gone up drastically, especially since Hitachi bought out Pentaho."
Information not available
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
894,738 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
15%
Educational Organization
8%
Government
7%
Manufacturing Company
6%
Construction Company
16%
Comms Service Provider
11%
Computer Software Company
10%
Outsourcing Company
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business18
Midsize Enterprise17
Large Enterprise31
No data available
 

Questions from the Community

Which ETL tool would you recommend to populate data from OLTP to OLAP?
Hi Rajneesh, yes here is the feature comparison between the community and enterprise edition : https://www.hitachivantara.com/en-us/pdf/brochure/leverage-open-source-benefits-with-assurance-of-hita...
What do you think can be improved with Hitachi Lumada Data Integrations?
In my opinion, the reporting side of this tool needs serious improvements. In my previous company, we worked with Hitachi Lumada Data Integration and while it does a good job for what it’s worth, ...
What do you use Hitachi Lumada Data Integrations for most frequently?
My company has used this product to transform data from databases, CSV files, and flat files. It really does a good job. We were most satisfied with the results in terms of how many people could us...
What needs improvement with Tray.io?
I believe Tray.io can be improved by offering integration with Tableau, which is still not available. I rated it an eight because there are still some things that can be improved, as I mentioned be...
What is your primary use case for Tray.io?
My main use case for Tray.io is to conduct A/B testing for marketing initiatives that the company has undertaken. We test the deployment of different campaigns across similar cohorts and evaluate w...
What advice do you have for others considering Tray.io?
My advice to others considering Tray.io is to trust the process because once the installation is complete, it is extremely easy to deploy and set up. I have rated this product an eight out of ten.
 

Also Known As

Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration
No data available
 

Overview

 

Sample Customers

66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute
Copper, DigitalOcean, Udemy, AdRoll, FICO, Outreach
Find out what your peers are saying about Pentaho Data Integration and Analytics vs. Tray.io and other solutions. Updated: April 2026.
894,738 professionals have used our research since 2012.