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. 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, BOARDA 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: A great DW/BI soultionPentaho is the primary source for the Business Intelligence in my company. We have many Pentaho users across the whole organization that are making a good use of Pentaho Analyzer to create the reports. At the report side, it helps the business users to evaluate all the work that has been done by the different teams across the organizations. By seeing the reports they can check, for example, how many issues are open, how many bugs have been fixed in a specific duration, how many builds failed in which phase etc.,First thing what I have experienced about Pentaho is that it is user friendly. The best thing about Pentaho is Pentaho Data Integration. I have never used more user friendlier ETL tool like PDI. All the jobs and transformation steps are easy to understand. And I like the sample transformations and jobs that are provided with the package. It is so user friendly that, even if you don't know SQL, it will generate it for you. If you don't want to write scripts, that's fine, you can do it in PDI. I have found that Pentaho can be integrated with any technology or framework. I have easily and successfully integrated it with HDFS, EMR, S3, CouchDB, many different RDBMSs. I would consider it as a strength of Pentaho. Also if you are stuck or you find any error, the type of logging will have an answer for you. I found the logging mechanism very effective. I have mostly used Pentaho Analyzer and Schema Workbench at the BI side. It is user friendly too and we have a very few users who come to the developers to help them understanding the UI of PUC.,Most of the companies use star schema in their Data Warehouses but they are not the pure star schemas. There are the bridge tables, group tables but when using Schema Workbench to design a cube, it gets very painful for the developers to accommodate such schema in it. To do this, I have to go to the XML file and add the new elements. I would love to see the feature where Schema Workbench can accommodate the bridge tables as they are the part of star schema too. When it comes to ETL, I have found PDI to be the best tool, but at the report side, it is not as good as the other tools available in the market. Especially the users always complain about the graphs in the Pentaho Analyzer. I think. the UI needs a lot of improvement. PDI is slow reading the JSON files. There is a fast JSON input step available in the marketplace but I think I would be great if Pentaho can make the JSON reading even faster. When I export the repository, I see the files names are encoded with UTF-8 encoding. It would be great, if the spaces and the special characters can be preserved while exporting a BA repository.,9,Pentaho has improved our overall business process. Pentaho has helped the Managers and Directors to analyze the numbers going up and down from time to time. We have a started a big project using Pentaho that is going to include all the business processes in the organization.,Informatica Enterprise Data Integration,PostgreSQLPentaho - 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- 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,4Rookie Pentaho review from an ETL veteranIn my organization, we use Pentaho as our go-to ETL tool. It is used by our engineering department in order to create our data warehouse environment, which is used by several customers. It allows us to create our data warehouse, which ultimately enables our end users to utilize analytics for their environments.,Great visualizations. Much like SSIS, the component-based model of ETL is easy to see at-a-glance in order to understand what is going on. Easy roll-ups. It is very easy to encapsulate logic into separate jobs (KJBs) and transforms (KTRs), in order to group code into bite-size chunks. Wide selection of tools. There are several dozen ETL steps to choose from, in a variety of different categories. Everything from file management to XML and scripting.,Lack of support. Unlike many Microsoft products, there is not a great wealth of support out there for Pentaho on the web. It is much harder to track down solutions. Non-intuitive. There is a learning curve, and there are subtle nuances to Pentaho that even experienced ETL developers will take a while to get used to. Less reputable. Despite all of Pentaho's benefits, it just hasn't gotten to that critical mass in the marketplace. Thus it does not garner as much respect as Microsoft or Oracle, which in turn makes it harder to find online support. It's a vicious cycle.,6,It's cheap. The version we have is free, so it has an immediate positive impact on ROI in that regard. However, a lot of our developers don't like it, which eats away our ability to be effective and productive. It gets the job done. It may not be the most elegant tool, but for our purposes it works. There are probably better tools out there, and Pentaho has limited capabilities, but at the end of the day it works well enough.,SQL Server Integration Services,Microsoft SQL Server, Oracle Database, SQL Server Integration ServicesAn 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
106 Ratings
Score 7.3 out of 101
<a href='' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

Pentaho Reviews

106 Ratings
<a href='' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.3 out of 101
Show Filters 
Hide Filters 
Showing 9 of 106 Pentaho ratings and reviews.
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Job Type

Reviews (1-9 of 9)

  Vendors can't alter or remove reviews. Here's why.

Feature Scorecard Summary

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

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