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

CloudQuery vs Pentaho Data Integration and Analytics comparison

Why PeerSpot?
 

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

CloudQuery
Average Rating
9.0
Reviews Sentiment
6.4
Number of Reviews
2
Ranking in other categories
Cloud Data Integration (22nd)
Pentaho Data Integration an...
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
61
Ranking in other categories
Data Integration (9th)
 

Featured Reviews

MR
Cloud Security Support at a tech vendor with 501-1,000 employees
AI-driven queries have transformed how I discover hidden cloud assets and misconfigurations
One of the improvements that could be made to CloudQuery is the GUI. In the past, I had issues where I couldn't see all the information that would pop up at the bottom. That might be fixed by now, but I was experiencing issues with the GUI itself. CloudQuery's AI capabilities lack governance and security features. While the AI is great for helping me craft SQLs to find assets in the environment, it does not have real security features for blocking or similar tasks. I can set up SQLs for alerting, but I find that a bit limiting. For what it is, CloudQuery is great. The only improvement I could suggest would be to set up more alerting features, but overall it is great for what it is, and I would say it feels a little bit limiting.
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.

Quotes from Members

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

Pros

"The AI-generated SQL works well for my team as it gets things right most of the time."
"CloudQuery has positively impacted my organization because instead of navigating through multiple cloud consoles, I can run an SQL query and get, for example, all my S3 buckets that are public, private, or that I need to do something with."
"If you are looking to integrate unstructured or semi-structured datasets with some parallelization, choose this tool."
"All you need is a balance of experienced users and new trainees to get going."
"If we didn't have this solution, we wouldn't be able to manage our workload or generate the volume of reporting that we currently do."
"Running itself with the ETL was very fast; it makes it so that it is very easy to transform the information we have, and we found that very useful."
"We're using the PDI and the repository function, and they give us the ability to easily generate reporting and output, and to access data. We also like the ability to schedule."
"Lumada has allowed us to interact with our employees more effectively and compensate them properly. One of the cool things is that we use it to generate commissions for our salespeople and bonuses for our warehouse people. It allows us to get information out to them in a timely fashion. We can also see where they're at and how they're doing."
"The fact that it's a low-code solution is valuable. It's good for more junior people who may not be as experienced with programming."
"Using the solution we were able to reduce our ETL deployment time by between 10 and 20 percent, and when it comes to personnel costs, we have gained 10 percent."
 

Cons

"CloudQuery really acts as an asset inventory tool, which is great, but I find that somewhat limiting."
"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."
"Its basic functionality doesn't need a whole lot of change. There could be some improvement in the consistency of the behavior of different transformation steps. The software did start as open-source and a lot of the fundamental, everyday transformation steps that you use when building ETL jobs were developed by different people. It is not a seamless paradigm. A table input step has a different way of thinking than a data merge step."
"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."
"Overall, our Hitachi solution was quite good, but over the last couple of years, we have been trying to move away from the product due to a number of things."
"It is difficult to process huge amounts of data."
"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."
"The rule executor step can be improved."
"Stability is a bit of an issue. The GUI quite often ‘freezes’ and there is no alternative to killing the session."
 

Pricing and Cost Advice

Information not available
"For most development tasks, the Enterprise edition should be sufficient. It depends on the type of support that you require for your production environment."
"We are using the Community Edition. We have been trying to use and sell the Enterprise version, but that hasn't been possible due to the budget required for it."
"I think Lumada's price is fair compared to some of the others, like BusinessObjects, which is was the other thing that I used at my previous job. BusinessObject's price was more reasonable before SAP acquired it. They jacked the price up significantly. Oracle's OBIEE tool was also prohibitively expensive."
"If a company is looking for an ETL solution and wants to integrate it with their tech stack but doesn't want to spend a bunch of money, Pentaho is a good solution"
"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."
"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."
"There was a cost analysis done and Pentaho did favorably in terms of cost."
"I believe the pricing of the solution is more affordable than the competitors"
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
915,341 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
No data available
Financial Services Firm
12%
Outsourcing Company
11%
Construction Company
9%
Educational Organization
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business3
Midsize Enterprise2
Large Enterprise2
By reviewers
Company SizeCount
Small Business18
Midsize Enterprise17
Large Enterprise32
 

Questions from the Community

What needs improvement with CloudQuery?
CloudQuery could maybe integrate with some AI agents like ChatGPT or Claude to help us do some things like writing in natural language instead of SQL. Regarding CloudQuery's AI capabilities, I thin...
What is your primary use case for CloudQuery?
My main use case for CloudQuery is as a tool for inventory platforms that lets me extract, transform, and query infrastructure data using SQL. A quick specific example of how I use CloudQuery in my...
What advice do you have for others considering CloudQuery?
My advice to others looking into using CloudQuery is that if you like SQL, you can use this product as if it was MySQL, SQL Server, or any other relational database. I would rate this product a 10 ...
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...
 

Also Known As

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

Overview

 

Sample Customers

Information Not Available
66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute
Find out what your peers are saying about Amazon Web Services (AWS), Informatica, Palantir and others in Cloud Data Integration. Updated: September 2026.
915,341 professionals have used our research since 2012.