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

CloudQuery vs Pentaho Data Integration and Analytics 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

CloudQuery
Average Rating
9.0
Reviews Sentiment
6.5
Number of Reviews
2
Ranking in other categories
Cloud Data Integration (23rd)
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

"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."
"The AI-generated SQL works well for my team as it gets things right most of the time."
"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."
"It allows for very quick development due to the intuitive interface."
"We have seen at least 30% savings in terms of effort, which has helped us to price our service and products more aggressively in the market and win more clients."
"We have been able to expose data services through the use of CDA relying on the same database as the reporting tools, thus avoiding inconsistencies among the data shown by reports and data acquired by external systems."
"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."
"After using this product, we could do some of the things much faster than before."
"Data transformation within Pentaho is a nice feature that they have and that I value."
"We have a huge amount of data that needs to be cleaned and made more valuable for our organization, and this Data Integration helps us to achieve that goal."
 

Cons

"CloudQuery really acts as an asset inventory tool, which is great, but I find that somewhat limiting."
"Its performance can be improved so it will work better with Big Data. Also, sometimes it can be very buggy which keeps away some potential users."
"Lumada could have more native connectors with other vendors, such as Google BigQuery, Microsoft OneDrive, Jira systems, and Facebook or Instagram."
"The stability is not great, especially when you start patching it a lot because things get broken."
"The price of the regular version is not reasonable and it should be lower."
"Support for common Hadoop utilities can be expanded, such as bulk load with composite row keys for HBase, and include drivers for Impala out-of-the-box."
"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 would like to see more improvements with AS400 DB2. I journalled the tables/instance and the data migration is too slow if I compare it with other databases."
"The one annoyance that troubled us a lot was the fact that every step in a transformation that needed data, created its own data connection."
 

Pricing and Cost Advice

Information not available
"The pricing has been pretty good. I'm used to using everything open-source or freeware-based. I understand that organizations need to make sure that the solutions are secure, and that's basically where I hit a roadblock in my current organization. They needed to ensure that we had a license and we had a secure way of accessing it so that no outside parties could get access to our data, but in terms of pricing, considering how much other teams are spending on cloud solutions or even their existing solutions, its price point is pretty good. At this time, there are no additional costs. We just have the licensing fees."
"The cost of these types of solutions are expensive. So, we really appreciate what we get for our money. Though, we don't think of the solution as a top-of-the-line solution or anything like that."
"I primarily work on the Community Version, which is available to use free of charge."
"The price of the regular version is not reasonable and it should be lower."
"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."
"When we first started with it, it was much cheaper. It has gone up drastically, especially since Hitachi bought out Pentaho."
"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 don't need the Enterprise Edition, you can go with the Community Edition. That way you can use it for free and, for free, it's a pretty good tool to use."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
909,153 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
No data available
Financial Services Firm
14%
Construction Company
9%
Educational Organization
9%
Outsourcing Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
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 CloudQuery vs. Pentaho Data Integration and Analytics and other solutions. Updated: August 2026.
909,153 professionals have used our research since 2012.