#1 most frequent
United States of America
28.7%1,270 installations of 4,432
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.
Categories & Use Cases
Product Demos
Top Performing Features
Customizable dashboards
Customizable dashboards are dashboards providing the builder some degree of control over the look and feel and display options.
Category average: 8.6
Report Delivery Scheduling
Report Delivery Schedule is the ability to have reports delivered to a destination at a specific data and time.
Category average: 8.4
Multiple Access Permission Levels (Create, Read, Delete)
Multiple access permission levels means that different levels of users have different rights.
Category average: 8.3
Areas for Improvement
Single Sign-On (SSO)
Allows users to use one set of login credentials to access multiple applications
Category average: 8.5
iFrames
An iFrame is an HTML document embedded inside another HTML document on a website
Category average: 8.1
Mobile Application
A dedicated app for iOS and/or Android.
Category average: 7.4
Who Buys & Uses Pentaho
#2 most frequent
Brazil
21.6%959 installations of 4,432
#3 most frequent
India
4.4%193 installations of 4,432
Data integration made easy
Pros
- Data Integration with (almost) any source
- ETL jobs
- Manage and scheduling recurrent process
Cons
- Report development could be easier
- Better integration with online repository
- Native deployment and development environments
Return on Investment
- Less time spent daily on exporting data from platforms (CSV, XLS, etc)
- Prepare and enrich data from multiple sources
- Automate report generation and schedule sending to clients or teams
Alternatives Considered
AWS Lambda
Other Software Used
Zoho Analytics (formerly Zoho Reports), Tableau Public, Amazon EC2 Auto Scaling
Usability
Integrate and connect all data sources with Ai engineering in the cloud environment
Pros
- Integrate and synchronize with big data easily
- Import data from any sources and different databases
- Managing data in on-premise, hybrid and cloud environments.
- Compatibility and flexibility of the platform with any type of scenario and any business or industry
- Various tools in the software suite to transformation of data
- Simple interface appearance and creative UI graphics
Cons
- It has good modules and they should work on more variety and new modules suitable for the service
- Initial configuration is a bit time consuming and complicated for novice users and need smart config wizard
Return on Investment
- Data integration and fast reporting
- Smart Visualize and analyze data
Alternatives Considered
Cleo Integration Cloud, AWS Glue and Oracle Data Integrator
Other Software Used
MicroStrategy Analytics, SAP Data Intelligence, Google Cloud AI
Usability
My Experience with Pentaho data integrator
Pros
- I frequently use the Pentaho tool for data manipulation and data migration.
- I use the PentahoETL tool when designing ETL processes, transporting data to the database and designing the data warehouse.
- It is an ideal ETL tool for transporting XML and JSON-based data.
Cons
- The error codes we received in the Pentaho ETL tool are not clear enough. Explanations need to be more detailed for quick resolution of the problem.
- Scheduling ETL packages through the windows Task Scheduler makes things difficult. This process will be more efficient through the Pentaho tool.
- Database connection information is timed out after a certain period of time. I sometimes have this problem even though the database password hasn't changed.
Other Software Used
Microsoft SQL Server, Oracle Data Integrator
Trust Pentaho to deliver a smooth data mining experience
Use Cases and Deployment Scope
We use Pentaho to store, collaborate & present data in a more modular form, which in turn helps us in making better business decisions & also allows end-users to navigate through complex data tables in a comfortable & easy manner. Pentaho not only helps in loading up the required data quickly, but it also helps in making sure the data is well structured & presented in a simple way.
Pros
- Excellent OLAP Services
- Multiple tools for data mining & extraction
- Plethora of options to transform data as per your needs
Cons
- Data Integration takes up too much time due to server loads.
- Data visualization has limited options to customize.
- Data modeling can take too much time depending on complexities of the model.
Return on Investment
- Helps in mining the data effectively & quickly.
- Minimizes the need for human intervention, automates the tasks brilliantly.
- Can be more expansive when it comes to data modeling.
Other Software Used
Movavi Video Editor Plus, Movie Maker Online (moviemakeronline.com), Canva
Usability
Best for Reporting and Dashboard
Use Cases and Deployment Scope
I use Pentaho for reporting and dashboard development. We develop the reports and integrate them with different database sources. It really helps us to achieve our business goals. I would suggest Pentaho for everyone who is looking to utilize one of the best BI tools for enhancing features with satisfying business requirements. I really love it.
Pros
- Reporting
- Integration
- Flexibility
Cons
- Cost
- DB connector
- High user friendly
Return on Investment
- Enhanced decision making
- Work management
- Effective business growth
Alternatives Considered
Tableau Online
Other Software Used
Slack