We use both DataStage and Pentaho, but I don't see any special features in Pentaho that is not available in DataStage, except Big Data plugins and connectors. These are default in Pentaho, and for those who have expertise in Java and Java script can write their custom code or enhance and call from Pentaho's code.
Programmer Analyst at a tech company with 10,001+ employees
Big Data plugins and connectors are available by default.
What is most valuable?
How has it helped my organization?
When we wanted pursue this tool, the major factor was the amount of money we could save. Other than that, there is no special use cases for using this product as it was not that matured when we started using it in 2012 when compared to other ETL tools.
What needs improvement?
It's still not user friendly or robust enough for our needs.
What was my experience with deployment of the solution?
There were issues with the deployment.
Buyer's Guide
Pentaho Business Analytics
December 2024
Learn what your peers think about Pentaho Business Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.
What do I think about the stability of the solution?
There have been stability issues.
What do I think about the scalability of the solution?
We've had issues scaling it for what we need.
What other advice do I have?
Since there are very few skilled people available on the market, we had to risk the project.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Senior Software Engineer - Alfresco, Liferay, Pentaho at a construction company with 1,001-5,000 employees
It's helped us with the integration of Big Data.
What is most valuable?
Speed, performance and for me the best one is integration with any data type, including Big Data.
How has it helped my organization?
We wanted a tool where by using it we could integrate multiple data sets, and could get responsive reports and Pentaho helped us do this in a good way.
What needs improvement?
The presentation of data and reports. Pentaho have made a lot of improvements in the newer versions, but it's still an area of improvement when compared to other products in market.
For how long have I used the solution?
We have been using Pentaho for over four years, starting from v3.2 we are continuously upgrading to new versions. We're also using Pentaho BI server v4.8.
What was my experience with deployment of the solution?
Pentaho BI server comes with inbuilt Tomcat container which is easy to deploy.
What do I think about the stability of the solution?
No. So far so good.
What do I think about the scalability of the solution?
No. So far so good.
How are customer service and technical support?
Being a community user, most of the time we depend on forums and the kind of response we got for tricky questions was just amazing.
Which solution did I use previously and why did I switch?
We were using Talend but simplicity of Pentaho attracts us and we settled on Pentaho.
How was the initial setup?
It was very much straightforward except at some points where we did our customizations which we had to take into account during new installations or upgrades.
What about the implementation team?
We implemented in-house on our own servers.
What's my experience with pricing, setup cost, and licensing?
We are using the Community Edition of Pentaho.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Pentaho Business Analytics
December 2024
Learn what your peers think about Pentaho Business Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.
Product Owner of Business Intelligence at a computer software company with 501-1,000 employees
We found workarounds to a couple of issues, but we spend too much time dealing with them. We're now evaluating other solutions.
With Pentaho we ran into a couple of issues - Multi-tenancy capability issues. We've found workarounds to the issues but our developers need to spend a great amount of time dealing with them.
We're looking to expand our product offering to our customers and we'd like to have the ability to give them better access to their data. Pentaho isn't proving to be a great solution for our needs.
Development time is currently too long for developing basic charts, dashboards and reports. All of these basic items take a long time to develop when using Pentaho. This costs us money and time.
Part of these issues is due to the fact that Pentaho documentation is pretty limited. We need to go ad hoc and pay a lot for additional training. There aren't many help files for our developers.
We're currently evaluating other solutions which will allow us to develop dashboards, charts and dashboards quicker while still taking the price point into consideration.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
COO at a tech services company with 11-50 employees
R Script needs work. Provides good dashboards for non-IT users.
Valuable Features:
- Correct URL integration
- Excelent Look & Feel
- Good Dashboards integration with Bootstrap
Improvements to My Organization:
- Senior management dashboard
- Pentaho Reporting and CDF integration
Room for Improvement:
- R Script
Use of Solution:
6 months
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Solution Architect at MIMOS Berhad
Pentaho is best fit for small and medium enterprises where the quantity of data and the workload are not critical.
What is our primary use case?
To manage the different data flows from various data sources(including both upstream and downstream) using visual representation. The usecase is to track various user activities from multiple sources within the enterprise.
How has it helped my organization?
Making business decision easily and efficient by simplifying the Performance Management of each business units on timely basis.
What is most valuable?
Ad-hoc reporting (available only in Enterprise Edition) GEO-referencing using Google Maps ETL (Pentaho Data Integration) Support for both JasperReport, BIRT
What needs improvement?
QueryByExample Portal support for Liferay No collaborative BI Auditing / User-Profiling is available only in Enterprise edition
For how long have I used the solution?
7 years
What do I think about the stability of the solution?
Very rarely
What do I think about the scalability of the solution?
No
How are customer service and technical support?
Customer Service:
3 (out of 5 scale)
Technical Support:
3 (out of 5 scale)
Which solution did I use previously and why did I switch?
No
How was the initial setup?
It is easy
What about the implementation team?
In-House
What's my experience with pricing, setup cost, and licensing?
Completely using community edition along with features implemented on top.
Which other solutions did I evaluate?
No, but now evaluating both SpagoBI and Jasper
What other advice do I have?
Study, Analyze and Compare with other platforms feature according to your requirements. Following are the nice features of Pentaho: Ad-hoc reporting Support for both JasperReport,BIRT Dashboard using JFreeChart
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.
Identity and Access Management Engineer at a financial services firm with 10,001+ employees
Easy to install, easy to use, the free edition meets our needs
Pros and Cons
- "Easy to use components to create the job."
- "Logging capability is needed."
- "Version control would be a good addition."
What is most valuable?
Easy to use components to create the job.
What needs improvement?
- Logging capability.
- Version control would be a good addition.
For how long have I used the solution?
One to three years.
What do I think about the stability of the solution?
A lot of time jobs get stuck, causing them to lock out and fail to run, until we kill them.
What do I think about the scalability of the solution?
I have not needed to scale this product so far.
How are customer service and technical support?
Open community, you can find good responses at a high level for the free edition. I have not used the commercial version which includes support.
Which solution did I use previously and why did I switch?
This is first solution I have used and I like it.
How was the initial setup?
Simple, easy to install.
What's my experience with pricing, setup cost, and licensing?
Free and commercial versions are available.
Which other solutions did I evaluate?
We did not evaluate other options as this one is free.
What other advice do I have?
Good for any size organization. There are other products and vendors available to better handle errors and logging, but for us, the free version of Pentaho is good enough to satisfy our needs.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Founder and Business Intelligence Consultant at Know Solutions
It helps me to create new BI environments for my customers.
Valuable Features
- Business analytics
- CDE
- Flexible dashboard development
- Cube
Improvements to My Organization
I use Pentaho everyday in my company, creating new BI environments for my customers.
Room for Improvement
The ad-hoc reporting needs to be improved.
Deployment Issues
There were no deployment issues.
Stability Issues
There have been no issues with the stability.
Scalability Issues
There have been no issues with the scalability.
Customer Service and Technical Support
I've never had to use technical support.
Initial Setup
It was easy, and only took a few minutes.
Other Advice
You should always check the community version first as it may be better for you.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Data Modeller and Pentaho Integration Analyst at a financial services firm with 1,001-5,000 employees
It covers most of our ETL requirements. It relies heavily on Java caching and sometimes it causes issues.
What is most valuable?
It's free and easy to use. You can actually explain it to any non-ETL developer.
How has it helped my organization?
It covers most of our ETL requirements.
What needs improvement?
There are issues with Java code and sometimes we have to fix it or apply work around.
For how long have I used the solution?
I've been using it for two years.
What was my experience with deployment of the solution?
There are issues with clustering, and partitioning which we have reported.
What do I think about the stability of the solution?
It relies heavily on Java caching and sometimes it causes issues.
How are customer service and technical support?
Customer Service:
7/10
Technical Support:7/10
Which solution did I use previously and why did I switch?
I have used ODI, Talend and Informatica. Pentaho is just current ETL choice for organization.
How was the initial setup?
It's very easy.
What about the implementation team?
We have implemented in-house with customization.
What's my experience with pricing, setup cost, and licensing?
We're only using the Community Edition.
What other advice do I have?
It's very easy to use and implement.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free Pentaho Business Analytics Report and get advice and tips from experienced pros
sharing their opinions.
Updated: December 2024
Popular Comparisons
Microsoft Power BI
IBM Cognos
SAP BusinessObjects Business Intelligence Platform
Oracle OBIEE
MicroStrategy
Oracle Analytics Cloud
Buyer's Guide
Download our free Pentaho Business Analytics Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Seeking advise on going with Birst, BOARD or Pentaho as an OEM platform solution where we could end up with 1,000's of users over time.
- Jaspersoft vs. Pentaho. Which should we choose?
- Performance benchmarks for Pentaho?
- What is the biggest difference between SSIS and Pentaho?
- When evaluating Business Intelligence Tools, what aspect do you think is the most important to look for?
- BI Tool Replacements, What Do You Recommend?
- Which one is best for ETL - Pentaho or Jaspersoft?
- Seeking advise on going with Birst, BOARD or Pentaho as an OEM platform solution where we could end up with 1,000's of users over time.
- BI Tool Evaluation Criteria Rating Matrix -- anyone have one they've used in making a tool selection?
- QlikView or Tableau - Which is better?
The recent version of pentaho supports various integration such as Big data tools, SAP etc., for efficiently create/schedule/run the transformation/job in standalone/cluster environment.