PeerSpot user
Senior Software Engineer - Alfresco, Liferay, Pentaho at a construction company with 1,001-5,000 employees
Vendor
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.

Buyer's Guide
Pentaho Business Analytics
April 2024
Learn what your peers think about Pentaho Business Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
770,141 professionals have used our research since 2012.

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 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.
PeerSpot user
PeerSpot user
Product Owner of Business Intelligence at a computer software company with 501-1,000 employees
Vendor
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.
PeerSpot user
Buyer's Guide
Pentaho Business Analytics
April 2024
Learn what your peers think about Pentaho Business Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
770,141 professionals have used our research since 2012.
Ricardo Díaz - PeerSpot reviewer
COO at a tech services company with 11-50 employees
Consultant
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.
PeerSpot user
PeerSpot user
Solution Architect at MIMOS Berhad
Real User
Leaderboard
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.
PeerSpot user
Saravanan Ramaraj - PeerSpot reviewer
Saravanan RamarajSolution Architect at MIMOS Berhad
LeaderboardReal User

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.

See all 7 comments
it_user798240 - PeerSpot reviewer
Identity and Access Management Engineer at a financial services firm with 10,001+ employees
Real User
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.
PeerSpot user
PeerSpot user
Founder and Business Intelligence Consultant at Know Solutions
Consultant
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.
PeerSpot user
it_user384954 - PeerSpot reviewer
Data Modeller and Pentaho Integration Analyst at a financial services firm with 1,001-5,000 employees
Real User
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.
PeerSpot user
it_user164988 - PeerSpot reviewer
Senior Analyst at a tech services company with 10,001+ employees
Real User
A few steps in PDI can be fine tuned, but has enabled our clients and their users to make calculated decisions.

What is most valuable?

Pentaho Data Integration.

How has it helped my organization?

Pentaho reports have enabled our client and their users to take calculated and informed tactical decisions. The drag and drop reporting of Pentaho is very user friendly and takes care of all reporting needs very efficiently.

What needs improvement?

  1. A few steps in PDI like Database Join can be fine tuned.
  2. Work could be done on roles and securities.

For how long have I used the solution?

3 and a half years.

What was my experience with deployment of the solution?

None so far.

What do I think about the stability of the solution?

Pretty stable. But database and repository cache sometimes need to be manually refreshed to make the changes effective.

What do I think about the scalability of the solution?

Yes. A few steps like Database join and merge join steps could be finetuned.

How are customer service and technical support?

Customer Service:

A 3/5. The support is prompt and timely. But there have been some technical limitations sometimes.

Technical Support:

3/5.

Which solution did I use previously and why did I switch?

Used MSBI sparingly. Used Pentaho mostly for cost benefits.

How was the initial setup?

Pretty straightforward. Also the support Pentaho documents are self explanatory for installation guidelines.

What about the implementation team?

In-house team.

What was our ROI?

Awesome. Even for enterprise edition. Obviously much better for community version.

What's my experience with pricing, setup cost, and licensing?

Currently using community edition. So zero maintenance cost.

Which other solutions did I evaluate?

Not thoroughly enough.

What other advice do I have?

If budget is a constraint, then Pentaho is a very good option. If budget is not an issue , then paid BI tools can be easily considered. Pentaho is leader in open source technology but still may not match paid BI tools.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free Pentaho Business Analytics Report and get advice and tips from experienced pros sharing their opinions.
Updated: April 2024
Buyer's Guide
Download our free Pentaho Business Analytics Report and get advice and tips from experienced pros sharing their opinions.