Overview
What is 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.
Trust Pentaho to deliver a smooth data mining experience
Best for Reporting and Dashboard
Data integration made easy
Using the Pentaho tools to solve ETL challenges
Integrate and connect all data sources with Ai engineering in the cloud environment
My Experience with Pentaho data integrator
Robust platform that needs some refresher to compete with more modern tools
A great tool, but falls under the shadow of the larger players.
Pentaho for your business
Pentaho can be a great solution for a company
Pentaho was just OK as an OEM solution
Pentaho - Yay or Nay?
Pentaho: A great DW/BI soultion
Rookie Pentaho review from an ETL veteran
Pentaho - Enhancing our ETL Capabilities
Popular Features
- Publish to PDF (19)9.797%
- Role-Based Security Model (19)9.595%
- Multi-User Support (named login) (20)9.393%
- Formatting capabilities (19)8.383%
Pricing
What is 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.
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
136 people also want pricing
Alternatives Pricing
What is Microsoft Power BI?
Microsoft Power BI is a visualization and data discovery tool from Microsoft. It allows users to convert data into visuals and graphics, visually explore and analyze data, collaborate on interactive dashboards and reports, and scale across their organization with built-in governance and security.
What is SAP Lumira Discovery?
SAP Lumira Discovery is SAP’s data visualization and discovery application. It facilitates data discovery, visualization, and analysis by assisting users with creation of dashboards, infographics, presentations, data facets, tag clouds, and more.
Product Demos
Pentaho and Hadoop Demo
Adempiere Pentaho Demo - Products & Sales figures
Agile BI with Pentaho BI Suite Demo
Google Analytics (part 1/2) - Pentaho Data Integration Demo
PENTAHO DATA INTEGRATION TOOL DEMO
Control de Mando (Dashboard) con Pentaho de Matrix CPM Solutions
Features
BI Standard Reporting
Standard reporting means pre-built or canned reports available to users without having to create them.
- 8.7Pixel Perfect reports(18) Ratings
Pixel Perfect reports are highly-formatted reports with graphics and ability to preview the report before printing.
- 9.8Customizable dashboards(18) Ratings
Customizable dashboards are dashboards providing the builder some degree of control over the look and feel and display options.
- 8.6Report Formatting Templates(18) Ratings
Ad-hoc Reporting
Ad-Hoc Reports are reports built by the user to meet highly specific requirements.
- 7.7Drill-down analysis(18) Ratings
Drill down analysis is the ability to get to a further level of detail by going deeper into the hierarchy.
- 8.3Formatting capabilities(19) Ratings
Ability to format output e.g. conditional formatting, lines, headers, footers.
- 9.3Integration with R or other statistical packages(12) Ratings
Integration with the open-source R predictive modeling environment.
- 9.6Report sharing and collaboration(17) Ratings
Report sharing and collaboration is the ability to easily share reports with others.
Report Output and Scheduling
Ability to schedule and manager report output.
- 9.6Publish to Web(18) Ratings
- 9.7Publish to PDF(19) Ratings
- 9.6Report Versioning(13) Ratings
Report versioning is the assignment of version numbers to each version of a report to help in tracking.
- 9.9Report Delivery Scheduling(17) Ratings
Report Delivery Schedule is the ability to have reports delivered to a destination at a specific data and time.
- 9.3Delivery to Remote Servers(10) Ratings
Ability to deliver reports to remote servers
Data Discovery and Visualization
Data Discovery and Visualization is the analysis of multiple data sources in a search for patterns and outliers and the ability to represent the data visually.
- 7.9Pre-built visualization formats (heatmaps, scatter plots etc.)(16) Ratings
Pre-built visualization formats are canned visualization types that can be selected to visualize different kinds of data.
- 8.2Location Analytics / Geographic Visualization(16) Ratings
Location analytics is the visualization of geographical or spatial data.
- 8.3Predictive Analytics(14) Ratings
Predictive Analytics is the ability to build forecasting models based on existing data sets.
Access Control and Security
Access control means being able to determine who has access to which data.
- 9.3Multi-User Support (named login)(20) Ratings
Named model access means that users have access based on name and password.
- 9.5Role-Based Security Model(19) Ratings
Role-based access means that access to data is determined by job or position in the corporation.
- 9.9Multiple Access Permission Levels (Create, Read, Delete)(18) Ratings
Multiple access permission levels means that different levels of users have different rights.
- 7.7Single Sign-On (SSO)(10) Ratings
Allows users to use one set of login credentials to access multiple applications
Mobile Capabilities
Support for mobile devices like smartphones and tablets.
- 9.7Responsive Design for Web Access(10) Ratings
Web design aimed at producing easy-to-read sites across a range of different devices.
- 7Mobile Application(7) Ratings
A dedicated app for iOS and/or Android.
- 8.7Dashboard / Report / Visualization Interactivity on Mobile(11) Ratings
In-app dashboard reports and data visualization.
Application Program Interfaces (APIs) / Embedding
APIs are a set of routines, protocols, and tools for used for embedding one application in another
- 8.3REST API(10) Ratings
REST is an architecture style for designing networked applications
- 9Javascript API(9) Ratings
A Javascript API is a type of API
- 7.3iFrames(9) Ratings
An iFrame is an HTML document embedded inside another HTML document on a website
- 8.6Java API(9) Ratings
A Java application programming interface (API) is a list of all classes that are part of the Java development kit (JDK)
- 8.9Themeable User Interface (UI)(10) Ratings
A themeable user interface means that a specific visual them can be applied to it
- 9.6Customizable Platform (Open Source)(10) Ratings
A customizable, open source API Gateway is a fast and scalable type of API
Product Details
- About
- Integrations
- Tech Details
- FAQs
What is Pentaho?
Pentaho Integrations
Pentaho Technical Details
Operating Systems | Unspecified |
---|---|
Mobile Application | No |
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(131)Community Insights
- Business Problems Solved
- Pros
- Cons
Pentaho has proven to be a valuable tool for users across a range of industries and business functions. Users have found value in using Pentaho for building data warehouses for data migration and analytics, covering all scenarios and allowing the use of external jars for unsupported activities. Pentaho's BI stack is utilized for ETL, report delivery, and as an endpoint for custom web apps. It offers ease of learning and impressive functionality, making it a popular choice for small-size private consulting firms. Pentaho is also used by engineering departments to create data warehouse environments for multiple customers, enabling analytics usage. In addition, it serves as the primary source for Business Intelligence in many companies, used by multiple users for creating reports and evaluating work across different teams. The software's ability to handle large and complex data sets with ease has been highly regarded by users, along with its advanced features for data integration, reporting, and analytical dashboards. Overall, Pentaho meets various needs such as scheduled ETL processes, data ingestion, reporting and dashboard development, making it a flexible solution across organizations.
Wide range of tools and features: Users appreciate the flexibility of Pentaho, as it offers a wide range of tools and features that can be tailored to meet the specific needs of different users and organizations. This has been mentioned by multiple reviewers who found this feature highly customizable and easy to learn.
Excellent reporting tool: Pentaho is praised for being an excellent reporting tool, with features like data reporting, integration, data mining, and ETL. Users find it intuitive and easy to use, even for advanced users. The visual interface simplifies processes that would traditionally require writing lines of code. Many reviewers have highlighted this aspect as one of the strengths of Pentaho.
Highly accessible data integration module: Pentaho's Data Integration module is highly regarded for its maturity and ease of learning. It allows business users to quickly connect to almost any data source. The ability to preview data in a pivot view format enables early data analysis. Several users have mentioned this module as a valuable feature in their reviews.
Limited Data Visualization Capabilities: Users have expressed the need for Pentaho to improve its data visualization capabilities in order to enhance the end result of dashboards. Specifically, some users feel that the current options are limited and lack advanced features and customization.
Difficulties with Mondrian-based ROLAP: Some users have mentioned that the Mondrian based ROLAP capability does not scale up well when analyzing data for a large number of subscribers over different time periods. This has resulted in performance issues and challenges in meeting the needs of complex business requirements.
Lack of Support and Guidance for WEKA: Users believe that WEKA, the machine learning platform used by Pentaho, lacks use cases in production environments and requires more support and guidance. They have found it challenging to implement and fully leverage the potential of WEKA within their organizations due to limited resources and documentation.
Attribute Ratings
Reviews
(1-1 of 1)Pentaho the best BI integrator
- 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.
Pentaho is Java based, so no shortage of skilled Java resources who can help you integrate. We did not spend time building our own reporting engine, Data Visualization layer, Security layer, workflow capabilities. We simply used our proven transactional product and used Pentaho to fill our gaps.
ETL Developer. Must have hands on experience coding ETL using SQL and/or proprietary tools.
Report Developer. Must have experience with building reports with Excel, Business Objects et al.
Solutions Engineer. Must understand how Pentaho fits with the overall Product offering. Should have the customer in mind at all times during product integration.
- 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.
- Price
- Product Features
- Product Usability
- Implemented in-house
- 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.
Evangalize within the organization the capabilities and limitations equally so that correct delivery expectations are set.
Set expectations with the Customer that the tool cannot replace proprietary software in terms of stability/usability and that timelines could change given the new ness of the product.
For any configuration related issues where best practices are known but are not working as expected.
They gave us workarounds when required.
They were quite knowledgeable when it came to issue analysis and providing fixes.
They were forthright in informing us if a bug was not due for release soon.
- 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.