Try our new research platform with insights from 80,000+ expert users

Palantir Foundry vs Pentaho Data Integration and Analytics comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 19, 2024

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

Palantir Foundry
Ranking in Data Integration
11th
Average Rating
7.8
Reviews Sentiment
7.0
Number of Reviews
18
Ranking in other categories
IT Operations Analytics (10th), Supply Chain Analytics (1st), Cloud Data Integration (11th), Data Migration Appliances (3rd), Data Management Platforms (DMP) (1st), Data and Analytics Service Providers (1st)
Pentaho Data Integration an...
Ranking in Data Integration
8th
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
60
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of March 2026, in the Data Integration category, the mindshare of Palantir Foundry is 2.1%, down from 2.7% compared to the previous year. The mindshare of Pentaho Data Integration and Analytics is 1.6%, up from 1.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Mindshare Distribution
ProductMindshare (%)
Pentaho Data Integration and Analytics1.6%
Palantir Foundry2.1%
Other96.3%
Data Integration
 

Featured Reviews

BA
Associate Vice President at a insurance company with 10,001+ employees
Unified data workflows have empowered collaborative analytics and streamlined AI development
Regarding points for improvement for Palantir Foundry, I see that they are improving day by day. In the last one to two years, I have seen many improvements compared to the two years that I have worked on Palantir Foundry. There are many things that come up, but a few things are not intuitive enough. Now that we are in this AI phase, Palantir Foundry has created some wrappers around the models, allowing us to create using a no-code application, chatbots, and LLM functions. The problem is that interaction with outside applications can be difficult with the current setup that Palantir Foundry has. There are ways to do that, but it is not that intuitive, which is what I feel.
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 ease of use is my favorite feature. We're able to build different models and projects or combine different projects to build one use case."
"The solution provides an end-to-end integrated tech stack that takes care of all utility/infrastructure topics for you."
"The interface is really user-friendly."
"I rate Palantir Foundry a ten out of ten."
"I like the data onboarding to Palantir Foundry and ETL creation."
"The virtualization tool is useful."
"It's scalable."
"The interface is really user-friendly."
"It allows for rapid prototyping of a wide array of ETL workloads."
"We also haven't had to create any custom Java code. Almost everywhere it's SQL, so it's done in the pipeline and the configuration. That means you can offload the work to people who, while they are not less experienced, are less technical when it comes to logic."
"No software can give as complete functionality for fulfilling end user requirements as Pentaho."
"It is a very good open source ETL tool that's capable of connecting to most databases."
"I can use Python, which is open-source, and I can run other scripts, including Linux scripts. It's user-friendly for running any object-based language. That's a very important feature because we live in a world of open-source."
"Since we started using Pentaho Data Integration and Analytics, many of our manual tasks have become automatic, and we have increased our time for productive things."
"The amount of data that it loads and processes is good."
"The fact that it enables us to leverage metadata to automate data pipeline templates and reuse them is definitely one of the features that we like the best. The metadata injection is helpful because it reduces the need to create and maintain additional ETLs. If we didn't have that feature, we would have lots of duplicated ETLs that we would have to create and maintain. The data pipeline templates have definitely been helpful when looking at productivity and costs."
 

Cons

"If you want to create new models on specific data sets, computing that is quite costly."
"The solution's visualization and analysis could be improved."
"The startup pricing is high, causing concern despite being cost-effective in terms of total cost of ownership."
"The solution’s data security could be improved."
"Some error messages can be very cryptic."
"The major hindrance with Palantir Foundry is that being a very closed product, the cost optimization and costing are not exposed to the end users."
"There are some issues with scalability because when we are using a really large dataset, the system is rather slow."
"The frontend capabilities of Palantir Foundry could be improved."
"Upgrading the bi-platform is a little pain, but the rest is easy to use and to set up."
"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."
"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."
"The web interface is rusty, and the biggest problem with Pentaho is debugging and troubleshooting. It isn't easy to build the pipeline incrementally. At least in our case, it's hard to find a way to execute step by step in the debugging mode."
"There some steps that should perform better like the json input, but because of the flexibility we at inflow, override it by using scripting steps."
"The performance could be improved. If they could have analytics perform well on large volumes, that would be a big deal for our products."
"Some old plugins, after a long time, still doesn’t work properly enough."
"I would like to see improvements made for real-time data processing."
 

Pricing and Cost Advice

"Palantir Foundry is an expensive solution."
"It's expensive."
"The solution’s pricing is high."
"Palantir Foundry has different pricing models that can be negotiated."
"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 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."
"I primarily work on the Community Version, which is available to use free of charge."
"There was a cost analysis done and Pentaho did favorably in terms of cost."
"We did a two or three-year deal the last time we did it. As compared to other solutions, at least so far in our experience, it has been very affordable. The licensing is by component. So, you need to make sure you only license the components that you really intend to use. I am not sure if we have relicensed after the Hitachi acquisition, but previously, multi-year renewals resulted in a good discount. I'm not sure if this is still the case. We've had the full suite for a lot of years, and there is just the initial cost. I am not aware of any additional costs."
"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."
"There is a good open source option (Community Edition)​."
"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."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
884,933 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Manufacturing Company
14%
Financial Services Firm
10%
Government
8%
University
7%
Financial Services Firm
12%
Educational Organization
9%
Government
8%
Computer Software Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business4
Midsize Enterprise5
Large Enterprise9
By reviewers
Company SizeCount
Small Business18
Midsize Enterprise17
Large Enterprise31
 

Questions from the Community

What needs improvement with Palantir Foundry?
Apart from the pricing and offline availability issues, improvements are needed in Palantir Foundry's costing factor. Cost-wise, it is not open for everybody, and they are not exposing anything out...
What is your primary use case for Palantir Foundry?
One of the leading European manufacturing plants uses Palantir Foundry for manufacturing interior parts of various car brands such as Honda, Hyundai, Ford, Mercedes-Benz, and BMW. This involves hig...
What advice do you have for others considering Palantir Foundry?
Palantir Foundry is an excellent product for data engineering. On a scale of one to 10, I would rate Palantir Foundry a 9.
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

Merck KGaA, Airbus, Ferrari,United States Intelligence Community, United States Department of Defense
66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute
Find out what your peers are saying about Palantir Foundry vs. Pentaho Data Integration and Analytics and other solutions. Updated: March 2026.
884,933 professionals have used our research since 2012.