We are using just the simple features of this product.
We're using it as a data warehouse and then for building dimensions.
Scales well with data and processes, but the cost should be lower and real-time processing capabilities improved
Pros and Cons
- "The amount of data that it loads and processes is good."
- "I would like to see improvements made for real-time data processing."
What is our primary use case?
What needs improvement?
The shortcoming in version 7 is that we are unable to connect to Google Cloud Storage (GCS), where I can write the results from Pentaho. I'm able to connect to S3 using Pentaho 8, but when using it for GCS, I'm unable to connect. With people moving from on-premises deployments to the cloud, be it S3, Azure, or Google, we need a plugin where we can interact with these cloud vendors.
I would like to see improvements made for real-time data processing. It is something that I will be looking out for.
For how long have I used the solution?
We have been using Pentaho Data Integration for three years.
What do I think about the stability of the solution?
For all of the features that we have been using, it is a stable product.
Buyer's Guide
Hitachi Lumada Data Integration
August 2022
Learn what your peers think about Hitachi Lumada Data Integration. Get advice and tips from experienced pros sharing their opinions. Updated: August 2022.
622,949 professionals have used our research since 2012.
What do I think about the scalability of the solution?
In terms of data loading and processes, the scalability is good.
We have a team of four people who are using it for analytics.
How are customer service and support?
As we are using the Community Version, we have not been in contact with technical support. Instead, we rely on forums and websites when we need to resolve a problem.
Which solution did I use previously and why did I switch?
In the past, I have worked with Talend, as well as SAP BO Data Services (BODS). However, that was with another company. This organization started with Pentaho and we are still using it.
How was the initial setup?
It is a straightforward setup process. It took between three and four hours to complete.
What's my experience with pricing, setup cost, and licensing?
We are using the Community Version, which is available free of charge.
The price of the regular version is not reasonable and it should be lower.
What other advice do I have?
My advice for anybody who is researching this product is that if they want to do batch processing, then this is a good choice. The amount of data that it loads and processes is good.
Based on the features that I have used and my experience, I would rate this solution a seven out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free Hitachi Lumada Data Integration Report and get advice and tips from experienced pros
sharing their opinions.
Updated: August 2022
Product Categories
Data Integration ToolsPopular Comparisons
Talend Open Studio
Oracle Data Integrator (ODI)
Informatica PowerCenter
IBM InfoSphere DataStage
Azure Data Factory
Informatica Enterprise Data Catalog
SAP Data Services
AWS Database Migration Service
Mule Anypoint Platform
Matillion ETL
Oracle Integration Cloud Service
Buyer's Guide
Download our free Hitachi Lumada Data Integration Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Which ETL tool would you recommend to populate data from OLTP to OLAP?
- When evaluating Data Integration, what aspect do you think is the most important to look for?
- Which is better, Informatica PowerCenter or SSIS?
- Microsoft SSIS vs. Informatica PowerCenter - which solution has better features?
- Experiences with Oracle GoldenGate vs. Oracle Data Integrator?
- What are the must-have features for a Data integration system?
- Should we choose Data Hub or GoldenGate?
- A recent review wrote that PowerCenter has room for improvement. Agree or Disagree?
- Python with Numpy/Scipy vs. Pure C++ for Big Data Analysis
- Abintio Record Format- Setting NULL to variable
Yes the integration tool should be made available as Professional or Community / Standard / Enterprise Editions and Pricing should be made accordingly on the industry by industry basis or cases by case. And also there should be Transparency in the pricing and availability of community edition as the case was earlier when Pentaho management realeased it into market.