TrustRadius Insights for Pentaho are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.
Pros
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.
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.
Likelihood to Recommend
Pentaho is very well suited to perform data extraction & data mining from various cloud storage & transform that data using various available data models. However, the software struggles when it comes to visualizing the extracted data in an appealing manner & can be difficult for end-users to get an understanding of data tables created using those models.
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
Likelihood to Recommend
We did report designing for the market requirement. It was well suited to the requirement because of its apt feature. Also, both Pentaho report designer and Pentaho data integration are very good in terms of high flexibility and compatibility. Also, in terms of cost, any small organization can utilize the service.
VU
Verified User
Analyst in Information Technology (10,001+ employees)
Pentaho is used in my organization, mainly by the IT team, creating processes and routines focused on data ingestion from many sources. We also use Pentaho to create complex ETL jobs and prepare data to be used in our data warehouse and reporting platforms that are used by other departments in the company.
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
Likelihood to Recommend
Pentaho requires less technical skills than other solutions to start integrating and creating complex data manipulations and preparation. By having logical skills you can just start to 'drag and drop' some boxes, connect them, and create a data pipeline, step by step.
Before working for Hitachi Vantara, I had experience using the Pentaho Tools for personal projects mainly. I had the chance to work directly with the teams that supported the Pentaho tools, and I can tell with much objectivity that the Pentaho tools are by far one of the best options in the market when it comes to all the ETL processes. Data science requires extracting data from different sources, organizing it, and transforming it according to each necessity. Machine learning is built on top of these concepts, and with the Pentaho tools, you can accomplish most of it. Since I supported the Pentaho tools while working for Hitachi Vantara, my perspective is kind of unique; I can tell that the tools were used to solve internal problems such as integrations with our release tools and some of our agile tools, so the tools were used to enhance the newer versions.
Solving problems such as extracting metadata from thousands of files, organizing this information, and filtering it to create release files, determining how to create meta information files is just an example of the ETL cycle that can be performed with the Pentaho tools.
Pros
Open source, the Pentaho tools have a free to use version with a lot of support.
Performance. The Pentaho tools can be setup so they process gigabytes of data seamlessly.
Support from the open source developer community.
Documentation up-to-date.
Cons
The web versions of the Pentaho tools are limited to the server component.
Worker nodes features are being improved but more documentation and support is always welcome.
Likelihood to Recommend
<div>Any company looking to solve ETL, data science, data mining problems can solve these issues with the Pentaho tools.</div><div>
</div><div>From a very close perspective, I know that different industries, such as the leads generation industry, which operates with other sectors such as loans, medical insurance, and mortgage, can benefit significantly from using the Pentaho tools to perform data extraction and refine records.</div><div>
</div><div>Other industries such as universities use the Pentaho tools for different kinds of investigations.</div><div>
</div><div>Banking industries also use the Pentaho tools to perform internal data mining operations, which, as you can imagine having so much data is challenging.</div><div>
</div><div>Perhaps if you are a single developer trying to extract data for some machine learning process, using the Pentaho tools could be a little too much, maybe overcomplicated when some spreadsheets or using R or Python could probably get the job done. Still, complex or straightforward data transformations could suffice for the job.</div>
Information is our company fuel, The information and this software are used in all parts of our company, marketing, and sales, as well as development and research we make better decisions. Pentaho is now part of Hitachi Vantara and now is more better and professional than before. Lumada DataOps Suite is built with Pentaho, for end-to-end data integration and analytics at an enterprise scale. the more databases and information we have about customers, the target market, marketing, the type of goods, the consumer market, and the demand, It is better to decide on the presentation and save money. Pentaho Enterprise Edition is great for end-to-end data integration and analytics at enterprise scale. The complexities of doing business with this platform are simplified and all information is intelligently categorized and usable.
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
Likelihood to Recommend
Integration Pentaho with Hitachi Vantara is a successful idea, it has increased the speed of work in all departments of the organization. We recommend Hitachi Pentaho Enterprise Edition (Lumada DataOps Suite) to our customers in all industries, information technology, human resources, hospitals, health services, financial companies, and any organization that deals with information and databases and we believe Pentaho is one of the good options because it's agile, safe, powerful, flexible and easy to learn.
I use the Pentaho Data Integration ETL tool in our enterprise business intelligence projects. I often use the Pentaho tool for data manipulation and data transport. Pentaho plays an important role in our business processes because we work on the database in the department where I work. I use the PentahoETL tool when designing ETL processes, transporting data to the database and designing the data warehouse.
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.
Likelihood to Recommend
The Pentaho Data Integration ETL tool runs successfully on systems derived from both Windows and Unix. When designing a data warehouse, we can create ETL packets both at the Stage layer and at the DWH layer. There are many components for ETL design. We can run packages at certain time intervals through the Windows Task Scheduler. Since Pentaho Data Integration is an open-source application, it can be developed in applications to be integrated with PDI (Pentaho Data Integration). This allows you to manage the scheduler process through a separate application.
Pentaho is used as our organizational-wide reporting and BI platform. It is bringing together data from multiple enterprise applications including ERPs, HRM, EAM and PLMs. We are using it to create both prepackaged PDF reports as well as interactive analysis reports where users can compose their on add-how reports.
Pros
It is relatively stable, robust and reliable.
Interactive analysis reports are very useful and relatively easy to use.
Relatively simple to integrate with other systems
Cons
The type of graphs and layouts proposed for diagrams and charts are a little bit limited and partly outdated.
For certain reports you can feel that it is not using the latest web technologies.
The tools for creating new report template designs could be improved.
Likelihood to Recommend
Pentaho is well suited for bringing together data from multiple data sources in order to perform analyses and to create reports.
If you want to create very nicely looking interactive graphs using the latest web technologies, there might be other tools that are more suited. We have also seen performance problems with large amounts of data, but it is not certain if this only was the fault of Pentaho but could also be the infrastructure around.
VU
Verified User
Manager in Information Technology (10,001+ employees)
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.
Pros
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.
Cons
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.
Likelihood to Recommend
The tool is fast, visually attractive and intuitive to use, but we also have an implementation of Qlik Sense and Pentaho pales in comparison to the overall capabilities. I recommend the tool, but everyone’s solution need is unique, so it may not be the right fit. Larger tools like Qlik are more versatile and easier to recommend. More expensive, yes, but you usually get what you pay for.
VU
Verified User
Manager in Finance and Accounting (10,001+ employees)
Currently, 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.
Pros
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
Cons
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
Likelihood to Recommend
Pentaho will work great to embed analytic content with full features of Machine Learning capabilities. It supports many machine-learning frameworks and can be easily integrated. So, you also can connect with many data sources and have no worries about it. In our case, we are using it to help us create many day-to-day jobs and transformations that our internal users need. But to achieve this, we need to train our team to be able to understand the main concepts of how this software works.
We 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.
Pros
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.
Cons
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.
Likelihood to Recommend
<ul><li>Operational reports, big lists of COs, POs, DOs, master information and details. Bursting reports by email and scheduling tasks are interesting and very useful.</li><li> Complex aggregations are useful to use in cross tabs and calculated functions in the tables. I would recommend a new tool if the purpose is dashboards, but they still can be created in Pentaho as well.</li></ul>
