Try our new research platform with insights from 80,000+ expert users
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.

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

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 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_user409920 - PeerSpot reviewer
Product Analyst at a recruiting/HR firm with 51-200 employees
Vendor
It enabled seamless data movement from one system to another. ​Debugging and logging needs to improve.

What is most valuable?

Transformations. The wide range of transformations that are available in product suite, enable me to do data cleaning, transformation and mapping. I have used Pentaho mostly for ETL purposes.

How has it helped my organization?

Pentaho was used for data massaging in a system integration project. It enabled seamless data movement from one system to another. The biggest advantage of using this tool was that it support a wide range of input and output formats

What needs improvement?

Debugging and logging needs to improve. Not all the time debugging gives the accurate picture of what is going wrong with the jobs or transformations.

For how long have I used the solution?

I've been using it for one year.

What was my experience with deployment of the solution?

We've had no issues deploying it.

What do I think about the stability of the solution?

It's been stable.

What do I think about the scalability of the solution?

Data type mismatch issues causes a lot of error in the transformations, which I believe at times make it difficult to scale. For example in many transformations you have to mention the data type of the data and if the input file changes the data type, these transformation also needs to be updated. Hence one data type change in the input file have cascading effects

How are customer service and technical support?

I've never had to use it, but they do have a strong online community.

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

There was no previous solution in place.

How was the initial setup?

It was straightforward, as there was not much of configuration was involved.

What about the implementation team?

I was the vendor team who implemented this solution for the client.

What was our ROI?

It's difficult to predict the ROI as it was just a component of the system.

What other advice do I have?

The tool is easy to implement, but it needs technical acumen to do so. In other words although it look like a simple drag and drop kind of tool, it can be fairly complex.

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
January 2025
Learn what your peers think about Pentaho Business Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: January 2025.
831,265 professionals have used our research since 2012.
it_user505383 - PeerSpot reviewer
Director at a tech consulting company with 51-200 employees
Consultant
Helps us build decision supported systems.

What is most valuable?

Here are the valuable features:

  • Open source solution
  • Fully integrated
  • Customizable
  • Extensible with a large community behind it
  • Has a powerful ETL process (Pentaho Data Integration)

How has it helped my organization?

It helps us build decision supported systems. The use of MicroStrategy improved the decision-making process through enterprise report automation and corporate information management.

What needs improvement?

I would like to see self-service analysis and front-end tools.

The "self-service" feature of all BI tools deals with let final user (normally not tech one) do his/her work navigating data in a freely and not organized way.

Is exactly the opposite as create and manage a DW where data, metadata, are known and processed before.

Normally, traditional BI tools are more complex and complete managing traditional DW and in recent years other BI tools (like Qlik and Tableau for example) appears to fulfill this features.

For how long have I used the solution?

We have used this solution for five years.

What do I think about the stability of the solution?

There have been no stability issues. There were some minor bugs that were fixed by the manufacturer in their regular patches.

What do I think about the scalability of the solution?

There have been no scalability issues. Pentaho is based on industry standards to build scalable solutions. It’s very simple to scale up, horizontally, and vertically.

How is customer service and technical support?

Technical support is good.

How was the initial setup?

The installation had medium complexity. There is good documentation, but you have to follow certain procedures before using it.

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

This solution has an open source philosophy. There is a community edition without license costs, although it takes some more time to develop.

There is also an enterprise option that allows you to perform certain tasks easily and includes support.

What other advice do I have?

Have a global and corporate design in mind. However, start with a particular area, small and well-defined.

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

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.
PeerSpot user
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
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
PeerSpot user
Senior Software Engineer - BI at a tech services company with 501-1,000 employees
Consultant
With the help of the Data Analysis tool, decisions are very easy but Data Mining needs improvement

What is most valuable?

The ability to maintain historical data.

How has it helped my organization?

For decision purposes, it serves the information to managers to so they can make proper decisions using the data. With the help of the Data Analysis tool, decisions are very easy.

What needs improvement?

  • Populating Cube
  • Data Mining

For how long have I used the solution?

Four months.

What was my experience with deployment of the solution?

Yes we did.

What do I think about the stability of the solution?

No issues encountered.

What do I think about the scalability of the solution?

No issues encountered.

How are customer service and technical support?

Customer Service:

9 out of 10.

Technical Support:

7 out of 10.

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

No previous solution used.

How was the initial setup?

It was complex to set-up.

What about the implementation team?

We implemented it through a vendor and I would rate them 9/10.

Which other solutions did I evaluate?

We also looked at Talend.

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: January 2025
Buyer's Guide
Download our free Pentaho Business Analytics Report and get advice and tips from experienced pros sharing their opinions.