DBamp vs Pentaho Data Integration and Analytics comparison

CData Software and Hitachi Vantara are both solutions in the Data Integration category. CData Software is ranked #43 with an average rating of 8.0, while Hitachi Vantara is ranked #19 with an average rating of 7.7. CData Software holds a 0.1% mindshare in DI, compared to Hitachi Vantara’s 1.8% mindshare. Additionally, 100% of CData Software users are willing to recommend the solution, compared to 94% of Hitachi Vantara users who would recommend it.

DBamp

Read 1 DBamp review

135 Views
88 Comparison Views

100% willing to recommend

Pentaho Data Integration an...

Read 53 Pentaho Data Integration and Analytics reviews

1,983 Views
1,021 Comparison Views

94% willing to recommend

DBamp

Pentaho Data Integration an...

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between DBamp and Pentaho Data Integration and Analytics based on real PeerSpot user reviews.

Find out what your peers are saying about Microsoft, Informatica, Talend and others in Data Integration.

To learn more, read our detailed Data Integration Report (Updated: June 2025).

Buyer's Guide

Data Integration

June 2025

Download the complete report

Helped 857,585 peers since 2012

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

DBamp

Ranking in Data Integration

43rd

Average Rating

8.0

Reviews Sentiment

8.7

Number of Reviews

Ranking in other categories

No ranking in other categories

Pentaho Data Integration an...

Ranking in Data Integration

19th

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of June 2025, in the Data Integration category, the mindshare of DBamp is 0.1%, up from 0.1% compared to the previous year. The mindshare of Pentaho Data Integration and Analytics is 1.8%, up from 0.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration

Featured Reviews

reviewer2542599

Lead Database Administrator at a insurance company with 201-500 employees

Integration with existing tools enhances data handling capabilities

DBM allows integration with SQL Server, which is beneficial for Microsoft. While we are only downloading at the moment, we have tested some uploads, and the performance seems better than Data Loader, though it is more complicated. Both products use recommended security protocols, and we don't worry about their security.

Read full review

Aqeel UR Rehman

BI Analyst at a computer software company with 51-200 employees

Transform data efficiently with rich features but there's challenges with large datasets

Currently, I am using Pentaho Data Integration for transforming data and then loading it into different platforms. Sometimes, I use it in conjunction with AWS, particularly S3 and Redshift, to execute the copy command for data processing Pentaho Data Integration is easy to use, especially when…

Read full review

Quotes from Members

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

Pros

"Their support is good, very responsive despite being overseas."

"DBM allows integration with SQL Server, which is beneficial for Microsoft."

"Provides a good open source option."

"The amount of data that it loads and processes is good."

"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 has a really friendly user interface, which is its main feature. The process of automating or combining SQL code with some databases and doing the automation is great and really convenient."

"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."

"The solution offers features for data integration and migration. Pentaho Data Integration and Analytics allows the integration of multiple data sources into one. The product is user-friendly and intuitive to use for almost any business."

"It's very simple compared to other products out there."

"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."

More Pentaho Data Integration and Analytics pros

Cons

"DBM is a bit more complicated when compared to DataLoader, especially for more complex operations."

"It's not very stable, at least not in the case of the community edition. I'm working with the community edition right now and I think perhaps it is because of that it is not very stable, it causes the system to sometimes hang. I'm not sure if this is the case for pair tiers."

"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 reporting definitely needs improvement. There are a lot of general, basic features that it doesn't have. A simple feature you would expect a reporting tool to have is the ability to search the repository for a report. It doesn't even have that capability. That's been a feature that we've been asking for since the beginning and it hasn't been implemented yet."

"While Pentaho Data Integration is very friendly, it is not very useful when there isn't a lot of data to handle."

"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."

"The testing and quality could really improve. Every time that there is a major release, we are very nervous about what is going to get broken. We have had a lot of experience with that, as even the latest one was broken. Some basic things get broken. That doesn't look good for Hitachi at all. If there is one place I would advise them to spend some money and do some effort, it is with the quality. It is not that hard to start putting in some unit tests so basic things don't get broken when they do a new release. That just looks horrible, especially for an organization like Hitachi."

"Parallel execution could be better in Pentaho. It's very simple but I don't think it works well."

"I work with the Community Edition, therefore I do not have support. There was an issue that I could not resolve with community support."

More Pentaho Data Integration and Analytics cons

Pricing and Cost Advice

Information not available

"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."

"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."

"The solution reduced our ETL development time by a lot because a whole project used to take about a month to get done previously. After having Lumada, it took just a week. For a big company in Brazil, it saves a team at least $10,000 a month."

"I primarily work on the Community Version, which is available to use free of charge."

"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."

"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 believe the pricing of the solution is more affordable than the competitors"

More Pentaho Data Integration and Analytics pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Data Integration solutions are best for your needs.

See recommendations

857,585 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

No data available

Financial Services Firm

21%

Computer Software Company

14%

Government

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

Questions from the Community

What is your experience regarding pricing and costs for DBamp?

There is a charge, but it is not a huge charge. It is definitely cost-effective for what is received from it.

See all answers

What needs improvement with DBamp?

DBM is a bit more complicated when compared to DataLoader, especially for more complex operations. While DataLoader allows mapping, with DBM, everything must be done manually, which increases compl...

See all answers

What is your primary use case for DBamp?

We are using DBM for uploading. Currently, we are using it to download. However, we want to use it for uploading, however, it is more complicated, so we have not achieved that yet.

See all answers

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...

See all answers

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, ...

See all answers

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...

See all answers

Comparisons

No data available

Oracle Data Integrator (ODI) vs Pentaho Data Integration and Analytics

Compared 16% of the time

SSIS vs Pentaho Data Integration and Analytics

Compared 11% of the time

Informatica PowerCenter vs Pentaho Data Integration and Analytics

Compared 9% of the time

Talend Open Studio vs Pentaho Data Integration and Analytics

Compared 9% of the time

Azure Data Factory vs Pentaho Data Integration and Analytics

Compared 8% of the time

More Pentaho Data Integration and Analytics Competitors

Product Reports

Buyer's Guide

Data Integration

June 2025

Download DBamp product report

Buyer's Guide

Pentaho Data Integration and Analytics

May 2025

Pentaho Data Integration and Analytics report

Download Pentaho Data Integration and Analytics product report

Also Known As

No data available

Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration

Overview

CD-Data is a data publishing company with incorporates GIS technology to display parcel ownership data in a variety of ways. CD-Data has a unique relationship with the California county Assessors and receives data daily from most counties. The Navigator product is a statewide GIS which utilized the ownership data in multiple disciplines such as simple parcel searches, buffer searches, fire hazard layer, soils report layer (on a per parcel basis).

CData Software

Pentaho Data Integration stands as a versatile platform designed to cater to the data integration and analytics needs of organizations, regardless of their size. This powerful solution is the go-to choice for businesses seeking to seamlessly integrate data from diverse sources, including databases, files, and applications. Pentaho Data Integration facilitates the essential tasks of cleaning and transforming data, ensuring it's primed for meaningful analysis. With a wide array of tools for data mining, machine learning, and statistical analysis, Pentaho Data Integration empowers organizations to glean valuable insights from their data. What sets Pentaho Data Integration apart is its maturity and a vibrant community of users and developers, making it a reliable and cost-effective option. Pentaho Data Integration offers a range of features, including a comprehensive ETL toolkit, data cleaning and transformation capabilities, robust data analysis tools, and seamless deployment options for data integration and analytics solutions, making it a go-to solution for organizations seeking to harness the power of their data.

Hitachi Vantara

Sample Customers

Information Not Available

66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute

Find out what your peers are saying about Microsoft, Informatica, Talend and others in Data Integration. Updated: June 2025.

DOWNLOAD NOW

857,585 professionals have used our research since 2012.

See our list of best Data Integration vendors.

We monitor all 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.