Secured & Safest ETL and Reporting tool
I used Pentaho as an ETL tool to extract data from different data sources and created data marts for reporting and descriptive analytics …
Pentaho
Pentaho
Pentaho
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.
Read moreRecent Reviews
Popular Features
View all 28 features- Multi-User Support (named login) (21)9.191%
- Role-Based Security Model (20)8.888%
- Formatting capabilities (20)8.484%
- Publish to PDF (20)7.777%
Reviewer Pros & Cons
View all pros & cons
Video Reviews
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Pentaho, and make your voice heard!
Pricing
View all pricingN/A
Unavailable
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?
47 people want pricing too
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 Analytics Cloud?
The SAP Analytics Cloud solution brings together analytics and planning with integration to SAP applications and access to heterogenous data sources. As the analytics and planning solution within SAP Business Technology Platform, SAP Analytics Cloud supports trusted insights and integrated planning…
Features
Return to navigation
Product Details
- About
- Integrations
- Tech Details
- FAQs
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.
Pentaho Integrations
Pentaho Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Frequently Asked Questions
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.
Reviewers rate Responsive Design for Web Access highest, with a score of 9.6.
The most common users of Pentaho are from Mid-sized Companies (51-1,000 employees).
Comparisons
View all alternativesCompare with
Reviews and Ratings
 (131)
Attribute Ratings
Reviews
(1-3 of 3)- Popular Filters
Companies can't remove reviews or game the system. Here's why
August 19, 2015
Pentaho - Fast and Furious Data Integration
Pentaho Data Integration is used to move data into our data warehouse solution, used for various projects.
- Data Integration. PDI handles pretty much any type of data source and can transform data and conform it to any type of business logic.
- Object Oriented ETl Coding. Code developed in PDI can be shared across numerous jobs/transformations. This allows for resusable and maintainable code.
- Flexibility and plugins. If the function that you are looking for is not built into the tool, it's fairly straightforward to either download or develop plugins. There is a huge community of users that build new functionality all the time.
- Scaleable and cloud ready. PDI is able to cluster and scale out to handle huge data sets.
- The speed at which some trouble issues get resolved could be improved.
- We are able to be agile with our code development.
- We are able to have faster turn around on code development, integrate to standard tools like Git and Jenkins, and save time to release products.
1
Knowledge of Business Intelligence, Data Integration, and data usage is a must. The tools are relatively easy to learn with the given references, community, and general ecosystem but it does take time to master - as with any tool set.
June 03, 2015
B.I. made simple. Pentaho rocks!
We use it for what you would expect. ETL for process and aggregate data, and then building data cubes and reports for viewing that data. We also use the ETL tool to auto-process files (CSV, XML etc) from that we receive from a few of our vendors daily.
- The Data Integration tool is fantastic. A novice user can get up to speed quickly with it and the GUI is intuitive
- Support. As an enterprise customer, I am always thrilled with the fast turnaround on support tickets that I open.
- Job Scheduling. The Job scheduler is easy to use and very reliable
- Data Analyzer Tool in "User Console". The drag and drop UI makes it easy for me end users to see the data in whatever way suits them. They can even GEO-MAP the data instantly!!
- Speed on ETL. Without a very complex setup, the ETL Job runs single threaded and can be slow for BIG jobs.
- The "Report Designer" is decent, but lacks a lot of control that you might get from more mature products (like Business Objects, for instance). Sometimes to want to rotate or reformat a chart label, and it can't be done. In other cases, it can. It is not consistent. Also, 3D charts don't work in certain circumstances. Finally, charts mapped over time, in some cases, don't have the X Axis auto-scale and so all the data points are not readable.
- Jasper
We chose Pentaho because their initial sales support was fantastic, and the value proposition was great. Also, they "threw in" training for our 2 developers for free!
N/A
N/A
N/A
N/A
76.66666666666667%
7.7
57.5%
5.8
75%
7.5
43.33333333333333%
4.3
46.66666666666667%
4.7
N/A
N/A
N/A
N/A
10
developers (to build the stuff).
marketing folks (to pull data to make business decisions)
C-Level -- pulling data to view business trends and analyze success of different promotional campaigns we run.
marketing folks (to pull data to make business decisions)
C-Level -- pulling data to view business trends and analyze success of different promotional campaigns we run.
2
moderate level of competence as a developer helps, but is not absolutely necessary. Knowledge of database architecture and design helps a lot
- auto-processing vendor data files
- ETL for aggregate OLTP data into OLAP for reporting
- auto-producing reports for weekly meetings
- using the ETL tool (PDI) to process external files was unexpected.
November 04, 2014
Pentaho the best BI integrator
Our 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.
We evaluated Panorama, Cognos, MicroSrategy, Jasper Reports, Talend and homegrown solutions. Though each were awesome in their own right, none of them provided a end to end integration like we wanted. Pentaho did the job for us and more. Knowing that Pentaho was built by a team who were industry veterans made us feel comfortable that the basics were always a given and that we could always reach out to them for more. Plus Pentaho's responsiveness in providing a hands on expert to train us was a huge plus.
10
Managers, System Analysts and Business Analysts. We provide financial analytics hence the users are somewhat tech savvy, know how to use the system and get meaningful information from it to complete their day to day activities. Some users use our product for strategic planning purposes such as budgeting and marketing spend.
5
Java is a must have. Somebody who is proficient with object oriented programming concepts, understands APIs.
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.
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.
No
- Price
- Product Features
- Product Usability
Integration. That Pentaho had ETL, reporting, scheduling, workflow management included in one software plus being Java based it could be easily integrated with our existing software stack was the most important factor in choosing Pentaho.
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
We first chose the reporting solution as a module to integrate. Via API calls this module was integrated with our existing Product for transactional reporting purposes. Next phase of our implementation was centered around integrating the ETL solution into our product as a single point of data ingestion mechanism. Once the data was brought in using Schema Workbench we built the logical layer to help publish dashboards/reports via the Pentaho BI Server.
- 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.
Yes
For any production related issues where a hotfix is the only way to go.
For any configuration related issues where best practices are known but are not working as expected.
For any configuration related issues where best practices are known but are not working as expected.
Yes
Some bugs were resolved whereas some were slated in a much later release.
- 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