IBM App Connect vs Pentaho Data Integration and Analytics comparison

Cancel
You must select at least 2 products to compare!
IBM Logo
1,760 views|944 comparisons
100% willing to recommend
Hitachi Vantara Logo
3,346 views|1,127 comparisons
94% willing to recommend
Comparison Buyer's Guide
Executive Summary

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

Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed IBM App Connect vs. Pentaho Data Integration and Analytics Report (Updated: March 2024).
767,847 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"I would say that the most valuable feature is the array of connectors and integration tools.""We use IBM App Connect for the integration between the applications.""App Connect's best feature is that it can be deployed in a container.""Technical support is good.""Very scalable, flexible, and user-friendly.""The most valuable feature is the user-friendliness of the application.""When using IBM stacks, IBM App Connect is suitable and integrates well with other IBM products like WebSphere.""It's a powerful application for collaboration. It has many features for customization and integration."

More IBM App Connect Pros →

"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.""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.""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.""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.""Pentaho Data Integration is quite simple to learn, and there is a lot of information available online.""We use Lumada’s ability to develop and deploy data pipeline templates once and reuse them. This is very important. When the entire pipeline is automated, we do not have any issues in respect to deployment of code or with code working in one environment but not working in another environment. We have saved a lot of time and effort from that perspective because it is easy to build ETL pipelines.""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.""The area where Lumada has helped us is in the commercial area. There are many extractions to compose reports about our sales team performance and production steps. Since we are using Lumada to gather data from each industry in each country. We can get data from Argentina, Chile, Brazil, and Colombia at the same time. We can then concentrate and consolidate it in only one place, like our data warehouse. This improves our production performance and need for information about the industry, production data, and commercial data."

More Pentaho Data Integration and Analytics Pros →

Cons
"More connectors could be available for the product as some of the third-party software doesn't have default connectors.""IBM needs to enhance and have a stronger offering for the event streaming part because this is the future needed for the containerization and the new integration requirement.""IBM App Connect should improve security features.""Updates are constantly delayed.""The product should improve its support.""The installation of containers could be simplified, as it currently requires a senior-level installer.""The setup time for App Connect could be improved.""The addition of string functionality would be a benefit, particularly in the ESQL space that IBM already uses internally."

More IBM App Connect Cons →

"Since Hitachi took over, I don't feel that the documentation is as good within the solution. It used to have very good help built right in.""I have been facing some difficulties when working with large datasets. It seems that when there is a large amount of data, I experience memory errors.""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 could not connect to our Hadoop environment in an easy and flexible way, and it was important to scale our data warehouse​.""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.""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.""I would like to see improvements made for real-time data processing.""The support for the Enterprise Edition is okay, but what they have done in the last three or four years is move more and more things to that edition. The result is that they are breaking the Community Edition. That's what our impression is."

More Pentaho Data Integration and Analytics Cons →

Pricing and Cost Advice
  • "It is very expensive if we want to scale."
  • "The price could be better."
  • "The licensing cost for IBM App Connect is very high."
  • "The cost depends upon the consumer."
  • "Initially, App Connect was quite expensive because the cost was based on the number of processors we used. However, it's now based on containers, which means we can be more specific about our consumption and get a better price."
  • "The solution's pricing isn't cheap, but you can get good discounts based on your competitive deal."
  • More IBM App Connect Pricing and Cost Advice →

  • "There is a good open source option (Community Edition)​."
  • "The price of the regular version is not reasonable and it should be lower."
  • "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."
  • "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."
  • "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."
  • "When we first started with it, it was much cheaper. It has gone up drastically, especially since Hitachi bought out Pentaho."
  • "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."
  • "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."
  • More Pentaho Data Integration and Analytics Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
    767,847 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The solution's pricing isn't cheap, but you can get good discounts based on your competitive deal.
    Top Answer:We use the product mainly for the integration of enterprise applications.
    Top Answer:Hi Rajneesh yes here is the feature comparison between the community and enterprise edition :… more »
    Top Answer: 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, it… more »
    Top Answer: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 use… more »
    Ranking
    11th
    Views
    1,760
    Comparisons
    944
    Reviews
    13
    Average Words per Review
    437
    Rating
    8.3
    16th
    out of 100 in Data Integration
    Views
    3,346
    Comparisons
    1,127
    Reviews
    15
    Average Words per Review
    1,193
    Rating
    7.7
    Comparisons
    Also Known As
    IBM Cast Iron
    Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration
    Learn More
    Overview

    Rapidly connect public clouds, private clouds and on-premises application

    App Connect Professional is IBM’s cloud integration offering which delivers an integration solution
    • With ease-of-use, flexibility and increased responsiveness to the evolving business needs, while removing the daunting complexities of integration.
    • Provides the powerful combination of a ‘simple integration experience’ for business users looking to automate how their applications talk to each other; coupled with a ‘configuration based integration’ approach for IT.
    • App Connect Professional is for the teams and integration developers who need to solve more complex problems and need powerful tooling for integration scenarios

    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.

    Sample Customers
    United Way of Allegheny County, Saint-Gobain CPS, Ricoh, SunTrust Banks Inc.
    66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute
    Top Industries
    REVIEWERS
    Financial Services Firm38%
    Computer Software Company23%
    Manufacturing Company15%
    Comms Service Provider8%
    VISITORS READING REVIEWS
    Educational Organization55%
    Computer Software Company9%
    Financial Services Firm6%
    Energy/Utilities Company3%
    REVIEWERS
    Healthcare Company19%
    Financial Services Firm19%
    Comms Service Provider11%
    Manufacturing Company11%
    VISITORS READING REVIEWS
    Financial Services Firm19%
    Computer Software Company13%
    Comms Service Provider12%
    Government7%
    Company Size
    REVIEWERS
    Small Business13%
    Midsize Enterprise17%
    Large Enterprise71%
    VISITORS READING REVIEWS
    Small Business9%
    Midsize Enterprise60%
    Large Enterprise30%
    REVIEWERS
    Small Business27%
    Midsize Enterprise31%
    Large Enterprise42%
    VISITORS READING REVIEWS
    Small Business21%
    Midsize Enterprise11%
    Large Enterprise68%
    Buyer's Guide
    IBM App Connect vs. Pentaho Data Integration and Analytics
    March 2024
    Find out what your peers are saying about IBM App Connect vs. Pentaho Data Integration and Analytics and other solutions. Updated: March 2024.
    767,847 professionals have used our research since 2012.

    IBM App Connect is ranked 11th in Cloud Data Integration with 20 reviews while Pentaho Data Integration and Analytics is ranked 16th in Data Integration with 48 reviews. IBM App Connect is rated 8.2, while Pentaho Data Integration and Analytics is rated 8.0. The top reviewer of IBM App Connect writes "Very flexible and user-friendly; embeds with other technologies; no dependency on queue manager". On the other hand, the top reviewer of Pentaho Data Integration and Analytics writes "It's flexible and can do almost anything I want it to do". IBM App Connect is most compared with IBM Cloud Pak for Integration, Mule Anypoint Platform, webMethods Integration Server, IBM InfoSphere DataStage and TIBCO BusinessWorks, whereas Pentaho Data Integration and Analytics is most compared with Azure Data Factory, SSIS, Talend Open Studio, Oracle Data Integrator (ODI) and AWS Glue. See our IBM App Connect vs. Pentaho Data Integration and Analytics report.

    See our list of best Cloud Data Integration vendors.

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