TrustRadius
Pentaho is a suite of open source business intelligence and analytics products, now offered and supported by Hitachi Data Systems since the June 2015 acquisition.https://media.trustradius.com/product-logos/tH/rx/4APKV7V3F5EA.JPEGA great tool, but falls under the shadow of the larger players.We rolled out Pentaho within one of our business units as a way to get at trapped data from an old home-grown CRM system that had been recently updated to .net. Pentaho quickly got us access to the data and the built-in ETL tools were easy and quick to use and learn. It enabled a team of two to provide enough data, reporting and analytical dashboards to support over $1.5B in sales.,The built-in ETL tools are easy to learn, and can quickly import and transform any data you have. The excellent visualizations and charts are pleasing to the eye, and looks are important in sales and marketing presentations. The rollout was fast, we installed the software and were building dashboards within minutes.,I think the relative obscurity of the tool is a downside, not as many developers, consultants or peers you can tap into. Lack of a solid user community held us back, looking at Power BI and Qlik, they have huge user communities that help each other out. Would have liked that here. Smaller company means smaller sales force, and the lack of a local presence made it hard to only interact online with the account rep. Other companies have someone local who often stops by with pre-sales developers to just pitch in free of charge when they have time.,6,Qlik Sense, Microsoft Power BI and Tableau Server,8,7,Qlik Sense, Azure SQL Database, Informatica Cloud Data IntegrationPentaho for your businessCurrently, Pentaho was using it for our internal IT Department. We are using Pentaho to address more specific needs to integrate and analyze the company data that resides on all systems. It is necessary to have a secondary system that runs for the same purpose to run small and simpler modeling tools for Data Warehouses and Business Intelligence. It also acts as a comparison system to build simple jobs and transformations.,Easy to create simple jobs and transformations Mature data access and data transformation capabilities Suitable for complex analytic use cases Consume data from many sources,At first, one needs to learn the basic concept of this software before going for the implementation. Once you are an expert on this then you will rock it. Some of the basic features need to be enhanced such as sharing and collaboration capabilities Needs to support automatically generated analytic visualizations or models,8,Microsoft BI, Oracle BI Foundation Suite and SAP BusinessObjects BI Platform,8,7,Joomla!Pentaho can be a great solution for a companyWe are currently using this application for all the companies. We have managed to develop a lot of reports and dashboards and also bursting reports. Until now we have been able to meet the requirements of reporting in the company in all departments. Pentaho is a good BI solution to also provide the option of creating many operational reports if you don't have a good option in your ERP.,SQL query + scripting will help you design different objects, tables, pivots, dashboards, linked t other reports. Organizing in which way you want, synchronizing with AD is very helpful to set security/folder/group of users/single users. By using Eclipse you can set another layer of security by filtering information users's need to access. Sending reports y email also can be set up by security, by groups or list of users. Design seems pretty secure, from time to time can fail when there is too much design.,Would like to have a format copy for different objects, tables, cross-tabs, grids, it would make design much more easier. Of course, we use template and CSS design for these objects, from time to time we design something different and it makes it much harder to do this manually for each similar object. Possibility to use multiple DB in the .xaction.,9,direct query in excel,8,8,Kyubit Business Intelligence, BOARDPentaho - Enhancing our ETL CapabilitiesPentaho is used for scheduled ETL between Remedy and other platforms to help centralize and enrich data.,Easy to use! Reliable for small jobs Open source Easy to learn Great community online Fast,Open sourced Running on our vendor's VM... could be the reason why we are seeing some data limitation issues Future friendly,8,,BMC Remedy IT Service Management Suite, BMC Atrium CMDB,9,9Pentaho powerful backend BI tooling, hit-and-miss data visualizationWe utilize the Community Edition of Pentaho across our organization for business intelligence. We use Pentaho Data Integration (PDI) to gather data from disparate data sources and perform ETL to populate our data warehouse. We also use PDI to deliver custom reports to various internal and external clients. We use Mondrian as a data engine behind our customer-facing website to process MDX queries from our customer reporting portal. We use Pentaho Report Designer to author pixel-perfect reports for internal and external audiences. We also use the Pentaho User Console for our business analysts to slice-and-dice the data for various departments. In summary, Pentaho is used to allow our internal and external clients to benchmark the performance of our products and services and gain visibility into customer behavior and activity.,Pentaho Data Integration (PDI), which is Pentaho's ETL tool, is a powerful visual scripting tool. It is a very mature ETL tool that can process large quantities of data quickly when provided with appropriate hardware. Pentaho Analyzer which is Pentaho's Enterprise browser-based analysis and pivot table tool is powerful and intuitive. When provided with a well defined data warehouse schema it is easy for even non-technical users to quickly generate reports and graphs. Pentaho allows you to connect to virtually any datasource provided there exists a JDBC connector, REST API, or some other API end point. Pentaho has an open-source Community Edition which provides much of the functionality of the Enterprise Edition without any licensing fees.,A major problem we have had with Pentaho is their enterprise licensing. As a client who understands very well what is offered within the free Community Edition we felt their mark up on their enterprise features was much too high. They wanted to charge us for migrating from MySQL to Amazon RedShift since RedShift is an "analytical database" while nearly every other database could be connected to for free. Due to licensing concerns we terminated our enterprise license. Pentaho's visualization tools are very capable, but have a very steep learning curve and engineering cost. Due to this we ended switching from Pentaho for the majority of our internal dashboarding and reporting to purchasing Tableau licenses. If Pentaho could improve their visualization and dashboarding capabilities, they could truly be an end-to-end BI solution.,8,Tableau Server, Yellowfin, GoodData and Domo,10,7A powerful ETL tool which is open sourcePentaho is used as main ETL tool in the data analytics team. It solves the problem of processing and populating financial and ads related data.,Populate relational database Transform and clean data Create periodic job and generate report Aggregate data,It will be helpful to have modules supporting Google Adwords and Facebook API and Twilio API It has "add constant", but does not have "multiply constant" module. Unit transform module,9,,10,Number of users is 1 since only I have experience with that. Type of user is Data Scientist. It is used only in the data team.,10,8,7,YesPentaho- An adequate BI solution for users on a budget!Pentaho's BI stack is being used by our entire company. We use their tooling for ETL, delivering reports, and as a sort of end-point for a custom web app that we've built. The end point uses xaction and Mondrian to deliver data to our front end. We also make use of the community edition of the BI server--this houses several reports that our analyst team has built as well as resources necessary to support our custom app. In the near future we'll also be using the tool's big data plugins to ingest data into our data warehouse from hive/hadoop.,ETL, fairly wide support for a number of different data sources, a good API for writing plugins, and great out-of-the-box functionality. Community support and great documentation for using their tooling. Mondrian/OLAP, great engine for processing MDX queries.,pentaho's analyzer tool/front-end. This doesn't come close to competing with products like Tableau. Pentaho Report Designer, this looks like something that was built in the early 90's and is extremely clunky to use for new-users Schema Workbench, would be nice to see better support for snowflake type schemas,7,Tableau Desktop, Microsoft BI and RedPoint Data Management,Tableau Desktop, SQL Server Integration Services, MySQL,8,4One of the best BI solutions for start up companies or those looking for a highly customizable tool.It's been used across the whole organization . Automated reports and dashboards are some of our core usages .,automated reports dashboards data-integration Big Data,Poor support few books published in relation to Pentaho Pentaho User Console could be more user friendly,9,,8,8Pentaho the best BI integratorOur product intended to analyse Media and Communications data and provide decision making capabilities to our end users. Whereas we built the workflow management, transactional capabilities, Pentaho provided the BI layer for our product. Analysts were our end users. Everything from data ingestion to decision making was the scope of our product. We read data across disparate data sources/formats and using our business expertise provided decision making capability.,Data Integration. Pentaho wins hands down. You can read huge data using a Hadoop process, do your encirchment, load it to a Netezza database afterwards, finally input the data to your WEKA model to predict which Customer will churn or what offer should be made to the customer so that he/she stays put. BI Server. If you want to schedule a data read operation of your clickstream data, to finally burst out recommendations of next best actions to end users, Pentaho's BI Server performs this integration seamlessly. Mondrian. This layer provides Cube based Hierarchical data modeling on the front end and at the back end converts this OLAP structure to a ROLAP, SQL based model. Hence any relational database becomes a ROLAP engine seamlessly.,Data Visualization. Provide richer library of data visualization capabilities. Ultimately the dashboards are the end result of all the hard work done at the back office. Yes, Pentaho has a lower TCO compared to other Products but richer data visualization capabilities would make it a winner! Pentaho has overcome this limitation by allowing external charting engines to be integrated with their product suite, but more needs to be done to strengthen core Pentaho Data Visualizaiton capabilities. Alternatively the external charting engine capabilities need to be documented and evangalized. Alternative to Mondrian. In our case we needed to analyse data for a million subscribers over key performance areas like Churns, Activations etc. In these scenarios semi additive measures needed to be calculated and presented in a report across days to years grains of time. In such scenarios the Mondrian based ROLAP capability did not scale up to our expectation. Pentaho needs to address such issues and fast. In the world of R/SAS/SPSS its hard to find use cases where WEKA was used in Production environments to solve a business problem. We would have needed some hand holding to replace our R/SPSS code to WEKA and help us build newer alogorithms on this platform ground up.,7,,6,Typically system analysts, business analysts and departmental managers were our target audience. 10-15 users was the most we could reach before we decided to go with another suite of Products. But who ever used it did appreciate the end to end flow of data that they could see as opposed to the data obfuscation they noticed before.,8,6,4,10,5,As a replacement for our costly and technically disparate ETL and data visualization solution. As a integration software for our transactional systems with our BI systems. As a workflow management, business process specific application system.,As a dashboard/reporting solution. As a end to end data integrator. Right from data ingestion to pretty pictures that provide business value and decision making capability. As a workflow management solution.,No,Price Product Features Product Usability,I would place high marks on the visualization layer. If I cannot use one aspect of a Product suite it becomes difficult to evangelize the product within an organisation. Or I would set internal expectations that though the Product offers various modules, our evaluation should restrict itself to 2-3 core ideas and evaluate accordingly.,Implemented in-house,Yes,Technical expertise. Finding the right people who understood Java and BI was a tough ask. So we decided to keep the teams separate and let a Solutions Engineer/Architect provide direction for the integration. The team had prior experience in using stable proprietary products where documentation was plenty and hence any issue could be solved easily by tapping into the knowledge base around. Customer support interactions were infrequent. With Pentaho it was vice versa, where we depended more on Customer support than on community knowledge.,5,Yes,8,Yes,End to end data ingestion to data visualization is easiest to do. Dashboard/report creation, distribution is easy too. Workflow integration is best used in Pentaho. You can schedule an invoice to be loaded as soon as it arrives in your ftp server, you can apply business rules, load it to your database, refresh the data warehouse with this latest invoice and finally burst an email with telling all users to go and see the report. All this can be achieved in Pentaho's Workflow integration tool.,You HAVE to know Java to use Pentaho to the best of its capability. For pure BI enabled users like myself, it was a steep learning curve. Trying to match Customers data visualization expectations was tough, Our customers had already used Tableau and/or Microstrategy/Cognos/Business Objects, hence it was always a tough ask to match/better what they had already seen and experienced.,Yes, but I don't use it,5Pentaho Report Designer Integated with Odoo v7!We integrate Pentaho with Odoo for complex, custom reports that allow us to query data from PostgreSQL database across multiple data models in Odoo. I have used it to connect to Odoo via JDBC as well as directly to the web client for an object-based report. I have found the report designer client to be a bit difficult to use and buggy on my WIndows 7 machine but I have seen it working well on a Windows 8 machine. We use version 3.9.1.,Connect via JDBC Integrates with Odoo (formerly OpenERP) Grouping, summing seem to work well even though they are not intuitive as far as set up goes. The multiple report output types are great (PDF, CSV, Excel, Word, Text, etc) Connect via the web client of Odoo Easy to build in parameters for filtering in the report,Report designer seems to be buggy on Windows 7 The interface for the report designer is out dated and difficult to navigate or use. I would like to see a tool tip when hovering over options,8,,10,We have about 15 clients using reports that are designed in Pentaho and integrated with Odoo. We have 2 employees that do the design and development of reports using Pentaho. We are both advanced users of the report designer and can set up Pentaho to run on Ubuntu after installing Tomcat7 and Java JDK.,10,6,6Data Integration with Pentaho Kettle reviewI used Pentaho Kettle as a team manager of development and later as a CIO. After that I opened a company that consults and implement business intelligence solutions. We are using Pentaho mostly with the data integration module. I think that of all the modules of Pentaho, Kettle is the most complete. It can give a "fair fight" to source solutions that are not open. The problem it addresses of course is to extract data from various sources; transform them; ”play with data”; and then load it to the target. I find the transformation most valuable and rich with functionality. I even made a full scale course about it, you can find it on udemy.,Pentaho Kettle gives you a great graphic user interface to plan your transformation and jobs. Pentaho Kettle makes it easy to handle errors, logging and performance. Pentaho Kettle has dozen of great steps like: lookup and SCD functionality.,Several steps have performance issues like the Json input. The community edition does not include scheduler and job manager so you need to figure it out yourself, unless of course you buy the Enterprise edition. I think that web service should be easier to operate.,9,,9,This is not a relevant question, it is in the background. But I can say that when we add a new module / department we need to bring the data from more tables and sources.,9,8,10Pentaho was just OK as an OEM solutionWe made a decision to use Pentaho to OEM into the analytics feature of our software and the developers had a much harder time getting it integrated than we were expecting. The Mondrian code was hard to learn and the number of qualified applicants who already knew how to use it was limited.,Being able to use the OLAP Analyzer tool saved our organization a lot of time in not needing to develop an OLAP tool on our own. The ability to customize the tool and integrate all the internationalization we required was pretty straightforward.,The Mondrian code was hard to learn. The availability of resources that had experience with Pentaho and Mondrian was limited for us. The dashboards were slow and we found that it ended up being easier to remove the Pentaho pieces of the dashboard.,5,,4,7An implementor view on Pentaho tools.We used the Pentaho Data Integration tool to pre-process some data and fill thr production database. It was used in the department where I worked. Being a software developer I made a decision to use PDI instead of writing scripts on Python. The main advantage of PDI was supporting scaling out of the box, and the ability to run on multiple machines. When you need something less than a Hadoop cluster but bigger than self-made quick scripts it fits well.,The main strength of Pentaho (PDI) is that it is free. No need for additional license approvals to implement something quickly using the UI tool. It has Pentaho Reporting - the ability to use reporting on top of PDI transformations is a powerful feature. PDI can handle data extraction, and with reporting you can create a simple report on this data. They all just work with each other without additional integration required. And most of Pentaho projects are open-source. That helps a lot when debugging something.,Help documentation is an area for improvements. A lot of features and side effects just not documented. PDI uses swt. It has a lot of troubles with this dependency. It is run on Java, but with swt - and you are stuck with a platform that supports swt. ARM architecture does not have swt support out of the box. Online jobs/transformations creation. Jobs/transformations are just xml. So the lack of online editor is just 'it was not implemented yet'. Strange /Pentaho-solutions placement. Application is not deployed on a server in a standard way. Instead - a server should be embedded into a 'Pentaho solution' - very strange architecture.,7,,Cassandra, STORM, Redis,10,5Pentaho for Quality AssuranceAt our organization we are building a data ware house for data migration and analytics. After researching several options we went for the Pentaho community edition which is an open source tool. Pentaho played big role in the implementation of ETL jobs and QA testing. The features available in Pentaho covered all of our scenarios, plus it allowed us to plug in external jars to use for any unsupported activity.,Pentaho allows for migration from one system to another system without much trouble. Minimum code or almost no code expertise is required. Just get your SQL and Pentaho will do rest. It is difficult to verify millions of rows. But with Pentaho you can do that, this makes the QA task easier.,Pentaho does make comparison of data between two systems fairly easier compared to other systems, but it lags in terms of output you get. The output has a merge difference option which will show a difference transaction only but if you have large data set columns it is not easy to find issues. Date formatting and number formatting is again an issue, both the systems should have the same datatype. It was difficult for us to compare as a new system had updated data types and pentaho failed to compare these.,8,JMeter, NeoLoad, Oracle Hudson CI,9,8
Unspecified
Pentaho
108 Ratings
Score 6.9 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>

Pentaho Reviews

Pentaho
108 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 6.9 out of 101

Do you work for this company?

Show Filters 
Hide Filters 
Showing 14 of 108 Pentaho ratings and reviews.
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role

Reviews (1-14 of 14)

Companies can't remove reviews or game the system. Here's why.
No photo available
Score 6 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

7
Not a lot to say here, nothing above and beyond what any of the other tools offer. You can control, share or restrict data by data points such as user ID's or by roles tied to those IDs. Better interfaces with the suite of Microsoft products would make it easier to report out your data findings on, but not even Microsoft's Power BI can talk to its own products very well in this category.
Read this authenticated review
Ilham AB profile photo
Score 8 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

7
Pentaho provides the full support of different and many roles for access control capabilities. The features to share the data or report across team or different role in the organization and company. It includes features for managing security, running reports, displaying dashboards, report bursting, scripted business rules, OLAP analysis and scheduling out of the box.
Read Ilham AB's full review
Mihaela Olariu profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

8
Pentaho offers the possibility of sending to XLS, PDF or CSV, once saved on your local computer you can share with anyone. Reports used for PDF must have a special design from the start. Also, a special schedule to send report can be created in the .xaction and is working fine.
Read Mihaela Olariu's full review
Gordon Yeh profile photo
Score 8 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

9
Pentaho has a community online that shares the jobs and transformations. Importing/exporting the jobs is a piece of cake. Within our internal cloud, I am able to share, open, review the jobs and transformations that he has created and we can work together to finalize them. However, the access control comes with the connections themselves; if you don't have access, you don't have access and cannot do much with the tools to help shape and transform the data.
Read Gordon Yeh's full review
Jordan Squire profile photo
Score 8 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

7
Pentaho integrates with Active Directory / LDAP which makes managing users, roles, and groups simple. Sharing reports within Pentaho is very simple, however there is no notification to the user(s) that you shared a report with. You can schedule a report to be emailed to an email address on a recurring schedule. Other reporting tools provide a way to comment or discuss individual reports or dashboards, Pentaho does not.
Read Jordan Squire's full review
Ivan Miller profile photo
Score 7 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

4
The access control capabilities are generally sufficient, but not stellar. Most of the data sharing and access control is managed completely through pentaho's BI server, and there doesn't seem to be super strict security around the configuration and setup of permissions, who can view what reports, etc. The dashboarding capability of "putting a bunch of reports together" is extremely clunky, it's something we steer clear of trying to implement where possible.
Read Ivan Miller's full review
Deepak Paramanand profile photo
Score 7 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

6
Pentaho checked all the boxes with respect to security, formatting of reports/dashboards, distribution etc. In terms of collaborative capabilities, features like annotation, 'users-who-saw-this-also-saw' capabilities were missing. In hindsight we would have liked workflow integration to have been tightly coupled with collaboration so that all users in the same business process would have benefited from each others work and not have to redo.
Read Deepak Paramanand's full review
Adam O'Connor profile photo
Score 8 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

6
I use the Pentaho report designer on my local, generate a .prpt file and integrate that to make the report available in our client's Odoo instances. I haven't used any access control, data sharing or securities features that are available in Pentaho but I am looking forward to using them as I need them.
Read Adam O'Connor's full review
No photo available
Score 5 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

7
From my perspective as a business user and not a developer, they seemed to have all the functionality we needed. I could not say how easy or difficult these were to implement as I was not involved on that side. I do know we had some issues implementing the multi-tenant security.
Read this authenticated review
No photo available
Score 7 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

5
Did not use this feature. The reason was to use it required a user to install/run bi server, but we are not comfortable with the design bi server brings. We would prefer to use some self-contained functionalities of what can we get from Pentaho like reporting, or a PDI, and implement access control.
Read this authenticated review
No photo available
Score 8 out of 10
Vetted Review
Verified User
Review Source

Collaboration and Sharing

8
As we used the Community edition we didn't have any access control capabilities. But sharing data and connections was fairly easy. By just sharing kettle properties you can get most of the settings. On security again, our edition was the Community edition so we didn't bother that much.
Read this authenticated review

Feature Scorecard Summary

Pixel Perfect reports (12)
7.8
Customizable dashboards (11)
8.1
Report Formatting Templates (12)
7.2
Drill-down analysis (12)
7.2
Formatting capabilities (12)
7.2
Integration with R or other statistical packages (7)
6.1
Report sharing and collaboration (11)
5.3
Publish to Web (11)
6.1
Publish to PDF (13)
7.7
Report Versioning (8)
6.7
Report Delivery Scheduling (11)
7.0
Delivery to Remote Servers (3)
6.1
Pre-built visualization formats (heatmaps, scatter plots etc.) (10)
6.3
Location Analytics / Geographic Visualization (10)
6.7
Predictive Analytics (9)
5.7
Multi-User Support (named login) (13)
7.3
Role-Based Security Model (12)
7.1
Multiple Access Permission Levels (Create, Read, Delete) (12)
7.1
Single Sign-On (SSO) (4)
6.8
Responsive Design for Web Access (6)
6.2
Dedicated iOS Application (3)
6.4
Dedicated Android Application (3)
6.4
Dashboard / Report / Visualization Interactivity on Mobile (7)
6.6
REST API (3)
7.3
Javascript API (3)
6.7
iFrames (3)
5.6
Java API (3)
6.1
Themeable User Interface (UI) (3)
5.4
Customizable Platform (Open Source) (3)
6.1

About Pentaho

Pentaho is a suite of open source business intelligence and analytics products, now offered and supported by Hitachi Data Systems since the June 2015 acquisition.

Pentaho Integrations

Pentaho Technical Details

Operating Systems: Unspecified
Mobile Application:No