Pentaho Business Analytics Reviews

We use Pentaho Business Analytics primarily as an ETL process to extract data, transform them, and load them into our warehouse where we store data.

I have Pentaho Business Analytics deployed locally and also on the cloud.

Pentaho Business Analytics is scalable to a point. It is pretty scalable.

The process CI/CD is possible to implement, a real CI/CD process.

It is quite nice, but there is a glass roof.

Depending on the specificity or the difficulty that you have in the process that you want to implement, you should change the tool to another solution, a more elastic one.

From my service provider perspective, the best features of Pentaho Business Analytics are the possibility to put a real CI/CD process to have it more standardized with a better best practice approach.

Pentaho Business Analytics is the best value for money.

While improvements can be made in some areas, particularly with more cloud-based solutions, it is not in their domain because they do not want to be those kinds of providers.

Maybe they just need to avoid becoming obsolete because, for example, I use Talend as a tool, and the version of Talend was a business strategy to make obsolete some kinds of elements because they wanted to move to Talend Pro.

I am very satisfied with the tool.

From an integration perspective, Pentaho Business Analytics is not the best tool on the market.

There are things done by Apache that are better, though I am not the one implementing them, so this is based on what I have heard about novelties in the market.

I do not see the need to extend the coverage of Pentaho Business Analytics's domain.

For things that it does not do, there are better solutions on the market, and it would be costly to implement them.

Pentaho Business Analytics is a very great tool for very specific standardized scenarios.

If you need more complex elastic solutions because the process is different, there are better tools available.

I have been dealing with Pentaho Business Analytics for seven years.

Pentaho Business Analytics is scalable to a point.

It is pretty scalable.

The process CI/CD is possible to implement, a real CI/CD process.

It is quite nice, but there is a glass roof.

Depending on the specificity or the difficulty that you have in the process that you want to implement, you should change the tool to another solution, a more elastic one.

I am satisfied with Hitachi's support for this product.

It is stable and working, so I do not see any difficulty in that area.

I would rate my satisfaction with tech support for Pentaho Business Analytics as a four out of ten.

It is not that I am dissatisfied.

I know there are limitations.

I prefer to solve issues by myself or with my own resources.

I never use their support because there is a lot of knowledge spread on their platform and the internet, which makes maintenance easy.

Neutral

Pentaho Business Analytics offers the best value for money.

While improvements can be made in some areas, particularly with more cloud-based solutions, it is not in their domain because they do not want to be those kinds of providers.

Maybe they just need to avoid becoming obsolete because, for example, I use Talend as a tool, and the version of Talend was a business strategy to make obsolete some kinds of elements because they wanted to move to Talend Pro.

I am very satisfied with the tool.

From an integration perspective, Pentaho Business Analytics is not the best tool on the market.

There are things done by Apache that are better, though I am not the one implementing them.

Regarding integration capabilities, I do not think this is an edge value because in my expertise, it is not the strongest solution.

There are more easily integrated tools.

I use Pentaho Business Analytics because I have always used it, but other providers today on Snowflakes or other elements are better suited for more elaborated needs.

I work in data integration and use other, more standardized Microsoft products.

I currently use the MS Fabric package solution.

I have customers that use AWS services and bare-metal servers.

I use storage and machines to provide ETL service with Pentaho Business Analytics installed on them.

As a service provider and product owner, I can say that Pentaho Business Analytics is cheaper than competitors.

When I have a customer that wants to have a real ETL tool in a standardized way with a real code written product, it is the cheapest.

When I make inquiries about other solutions, it is always 20-30% more expensive.

Pentaho Business Analytics requires some base knowledge for installation.

It requires a developer because it is not a friendly tool. However, there is a lot of knowledge available on the internet and many available developers on the market with competitive pricing.

It is not a low-code solution.

I have used better platforms that enable things with a low-code element. The threshold is quite high because if you have never worked with it, it is not the most friendly for juniors.

It is not SQL-based.

I have it deployed on AWS cloud and on bare-metal owned by the customer.

I do not see any performance issues with Pentaho Business Analytics.

I rate Pentaho Business Analytics as 8 out of 10.

Positive

Pentaho is a BIS(business intelligence system) that is designed to help customers
make decisions based on their data type, size, workflow, use, and importance.

The "Pentaho Data Integration and Analytics" is software made and integrated with different software sets of tools to make it a good alternative BIS.

The customers can create a platform using "Pentaho Data Integration and Analytics" for data integration and analytics.

The Pentaho Data Integration and Analytics platform includes, extract, transform, and load (ETL), big data analytics, visualizations, dashboards, reporting, data mining, and predictive analytics.

Pentaho BIS can be used where an organization has a lot of big data storage systems already installed and needs to manage, visualize, and analyze that data.

It has a specific use case for unstructured data, such as documents, and needs to be able to search and analyze it.

This sometimes happens when customers buy one storage capacity, then upgrade or buy another one to get more capacity, and their organization is full of different types of storage/data. It is very hard to visualize and manage that data.

Pentaho Business Analytics can significantly improve an organization's IT insite, instead of creating silos of their data, they can manage, analyze and create an overall report using one product. It has a community version and an Enterprise version. Organizations can benefit from it by Increasing their Productivity, Improving Data Pipeline Quality, and faster Data Delivery.

It is a very good replacement for BIS, an organization's needs can be fulfilled by using the community version if they don't have any compliance issues.

Pentaho can help organizations by providing them an insight of their unstructured data using one platform(Pentaho Business Analytics).

The features are almost identical to other BIS platforms but to me, customers can benefit as it has a community version with most of its Enterprise features. It also has a free limited-period trial version.

The other feature that I would like to share here is, that users have access to a complete spectrum of data from different sources with the system’s adaptive big data layer, which takes the source of the data into account. The software is built on an open architecture and can be integrated with multiple systems. However, Pentaho Data Integration and Analytics has been acquired by HDS which offers an Enterprise edition for organizations that also need to meet product compliance.

The product to me is not as user-friendly as other players in the market.

It also still needs improvement in the reporting module. You will need to search for  deployment examples or need to have a first demonstration to make it ready for your specific needs. The adoption and learning will be another challenge if you are already using other solutions. If that is the case or your challenge then I will recommend buying the Enterprise edition from Hitachi Vantara as full solution with installation, deployment, and migration from your existing product.

We are just exploring and selling it as it is new to our customers.

PBA stability depends on the overall infrastructure and deployment scenario.

It is built for scalability and data visualization of a very large namespace.

We need more installations and deployments to share our customers' reviews for "Pentaho Data Integration and Analytics".

Neutral

We are just exploring it and offering our customers with Hitachi Content Platform (HCP) as a full solution. However, it all depends on customer needs and requirements.

The initial setup is simple but deployment complicity depends on scalability and features you need.

We are Hitachi Vantara(Providing Pentaho Data Integration and Analytics Enterprise Edition only) Partners, so we are offering as a reseller to our customers.

It helps organizations get better business efficiency and ROI in their heterogeneous environment.

The organization has both options based on their needs and budget constraints. The Enterprise Edition is expensive with references to an added number of features.

We are also offering Oracle OBIEE, but it all depends on the customer's use case and existing setup.

No, not yet any.

I work in business intelligence with Pentaho. I am associated with the marketing industry as well as the automotive industry. I help in marketing intelligence and work on insights for CEOs and heads of companies.

I work on market intelligence with Pentaho, providing insights and intelligence for CEOs and heads of companies. It is robust, offers market intelligence, and utilizes modules effectively. The ability to install on a server, unlike other tools which operate in the cloud, differentiates it from competitors.

The tool is very good, and yet it has some problems as it relies heavily on Java. The platform works with Java, and it has brought some issues to the company.

I have been working with Pentaho for about seven years.

The tool runs on Java, which affects the overall stability. It is generally stable, but issues can arise due to its reliance on Java.

The scalability of the product is very good. I believe it is beneficial to work with modules, making it efficient and scalable.

The customer support for Pentaho is rated seven out of ten. I have been working with their support for several years, and it is improving.

Neutral

The initial setup is rated an eight out of ten. The setup is considered easy.

The platform does not provide a clear calculation of ROI. However, it does not take long to get returns. The tool is stable, and generating a return does not take a long time.

For those starting to use this tool, there is a free version available which is beneficial. The company also finds the pricing to be good.

I would rate Pentaho Business Analytics a nine out of ten. It is a good tool. I would recommend it to others, as it is very capable.

The use case is for a General Insurance company headquartered in Japan. Data from legacy and active systems are integrated, and a standardized and clean copy of data is delivered for tracking KPIs, Loss Ratios, Claim Process Quality Review, and Customer 360 Portal using Pentaho, Tableau, R, and Qlikview.

Pentaho was used to build ETL pipelines for data warehouses (SSOT - Single source of Truth) and to prepare/distribute data for Tableau and Excel users.

Pentaho also had the ability to create Tableau data extracts for the purpose of developing report prototypes.

Currently I use this at Kaizentric Technologies to build data warehouse on Snowflake. 

It automated several data preparation tasks, enabled cleaner/standardized data for Tableau reports, and was used for integrating data from the current operating system with 3 other legacy system data.

Pentaho was used to migrate data from legacy systems such as Mumps, AS400, AeGIS, to MS SQL Data Warehouse.

ETL jobs helped to move data from Premia (Oracle) systems and OGG Replicas (Oracle Golden Gate) to MS SQL.

We used Pentaho to perform data quality analysis and for the development of data marts/DWH solutions and dashboards adhering to time requirements. 

The fuzzy logic match component came in handy to identify AML suspects (anti-money laundering). The SHA key generation component helped in generating a unique identifier for our customers, without revealing personal data; especially when we send data to the AWS cloud.

Regularly, we had to send the new policy data files to medical centers over email. Using Pentaho, we were able to compress the files in zip format with a password and email them to unlimited partners. 

We could confidently use Pentaho for sharing data with internal and external customers in mediums such as FTP servers, LAN folders (Local Area Network), email, etc. 

Connectivity to platforms such as snowflake is great.

To implement a logic we may need to use several components. In other tools such as Informatica, equivalent logic can be implemented with lesser components. To set the Java memory size, the configuration has to be changed outside the tool; it will be easier if everything can be handled within the tool.

There are no easy guides to implementing metadata injection. Templates and sample jobs could be provided for customers who need to leverage metadata for standard processing across multiple databases and tables.

I've used the solution for five years. I am also using the kettle as ETL for any personal projects, along with other ETL tools such as Fivtran & DBT.

The solution is stable enough.

We ran into insufficient memory issues due to the limits specified in Java config files. When processing larger data files, the UI may hang. But this issue may not appear when the programs run on the server.

As we opted for an OEM solution. We had to go through the vendor. It was not a great experience with most of the tickets.

Neutral

Stored procedures were used to generate data files. UI-based ETL pipelines are easier to maintain.

The initial setup was simple to medium. We were able to install it without any assistance from tech support.

We handled the implementation in-house. Our staff was given official Pentaho training, which helped in implementing the data pipelines.   

We did not achieve the ROI. The work delivered to users had lesser value than the subscription cost.  

We were lucky enough to find a Pentaho OEM partner who offered a data warehouse model and the ETL software for about 60K SGD per year. 

We considered Informatica, Talend, and Lavastorm Analytics. We dropped Informatica as it was an expensive alternative. The staff was not comfortable when reading Java code generated by Talend. Pentaho is more popular than Lavastorm. For these reasons (and a few others), we chose Pentaho. 

Pentaho seems to be popular in Europe and Canada. Talend is popular in APAC region. Informatica is popular in the USA. You may want to consider the availability of technical staff and support in your region before choosing ETL software.

Our company provides telecom solutions. We have a BA team of approximately 40 employees.

We use Pentaho to analyze our customers' subscriber analytics. This includes subscriber account, prediction, and analysis by the server.

The most valuable feature of Pentaho is the Tableau report.

Pentaho Business Analytics is not a good tool for visualization. We have many issues surfacing.

Another concern is that Pentaho is not customizable or interactive.

I have been using Pentaho Business Analytics for five years.

Pentaho is a stable solution.

This solution is scalable.

We used Tableau in the past and find that Tableau gives more features compared to Pentaho. Tableau also has ML features. We chose to use Pentaho because our customers were using it.

I do not recommend Pentaho, I rate this solution a five out of ten.

It's a data warehouse for finance and central bank reporting purposes, and an ETL tool in this environment.

It's easily understandable. The product is quick and flexible, with very good steps to make data transformation possible. 

The initial setup is pretty straightforward.

The repository should be improved. There should be the possibility to have versioning, to make it combinable with some Git repositories or something like that, to check out the processes and make sure it has a traceable history.

The solution could really be improved. There are too many bugs in our version.

The stability could be improved. In this version, we have several bugs and it's not that stable. I don't know whether the eighth and the ninth versions are better, however, there is room improvement in terms of stability.

We have three people who use the solution for the most part.

I'm not sure about the level of scalability. We had just a limited amount of data to pass through. If we have the 100 times amount of data, how this would scale with several servers or something like that, I have no clue. I don't know. I've never tried.

We hadn't had any contact with technical support in the past. I cannot judge their level of helpfulness.

We previously used Informatica PowerCenter. We found it a good switch as it's easier and more flexible than Informatica.

The initial setup was fine. It was pretty straightforward and not overly complex. That said, our environment was not that complex, which made it manageable.

We had three people involved in the implementation. It took a couple of months to have everyone on a level that they could work with it.

We handled everything in-house. We didn't need any exterior help from an integrator or anything like that.

We've definitely seen an ROI. It's been worth it for us.

It is an open-source option, so there isn't much overhead. There are just some fees that are supported. It might have been only 10,000 or 20,000 euros as an annual fee, however, I'm not sure.

We did look around a bit, however, we ended up choosing this product as it's open-source.

It's Hitachi, Hitachi Data Integration, formerly known as Pentaho.

I'm a partner with Pentaho/Hitachi and I'm a consultant.

New users should define some style guides to have a common implementation and documentation in the processes to handle and maintain it in the future. They should maybe use some modular approaches so that everything goes in the same direction. You should create reusable assets to make it happen.

I would rate the solution at an eight out of ten.

I primarily use Pentaho Business Analytics to create ETL processes, monitoring processes, and hierarchies.

Pentaho Business Analytics' best features include the ease of developing data flows and the wide range of options to connect to databases, including those on the cloud.

Pentaho Business Analytics' user interface is outdated. It's also limited in out-of-the-box features, which forces you to develop features yourself. There are also some problems with having to update metadata manually, which I would like to see Pentaho fix in the future. 

Pentaho Business Analytics is stable.

Pentaho Business Analytics is scalable (though I have only tested this lightly).

Since Pentaho Business Analytics is open-source, it has a very helpful community.

I previously used Microsoft Integration Services and Microsoft Azure Data Factory.

The initial setup was easy.

Pentaho Business Analytics is a very good product for those starting to work with ETL processes. Usually, it will solve every problem you may have when creating those processes, and it's free, with a big support community. However, it may not be the best choice if your company has a very strong relationship with Microsoft or if you want to work in the cloud. I would give Pentaho Business Analytics a rating of eight out of ten.

To manage the different data flows from various data sources(including both upstream and downstream) using visual representation. The usecase is to track various user activities from multiple sources within the enterprise.

Making business decision easily and efficient by simplifying the Performance Management of each business units on timely basis.

Ad-hoc reporting (available only in Enterprise Edition) GEO-referencing using Google Maps ETL (Pentaho Data Integration) Support for both JasperReport, BIRT

QueryByExample Portal support for Liferay No collaborative BI Auditing / User-Profiling is available only in Enterprise edition

7 years

Very rarely

No

Customer Service:

3 (out of 5 scale)

Technical Support:

3 (out of 5 scale)

No

It is easy

In-House

Completely using community edition along with features implemented on top.

No, but now evaluating both SpagoBI and Jasper

Study, Analyze and Compare with other platforms feature according to your requirements. Following are the nice features of Pentaho: Ad-hoc reporting Support for both JasperReport,BIRT Dashboard using JFreeChart

Easy to use components to create the job.

• Logging capability.
• Version control would be a good addition.

A lot of time jobs get stuck, causing them to lock out and fail to run, until we kill them.

I  have not needed to scale this product so far.

Open community, you can find good responses at a high level for the free edition. I have not used the commercial version which includes support.

This is first solution I have used and I like it.

Simple, easy to install.

Free and commercial versions are available.

We did not evaluate other options as this one is free.

Good for any size organization. There are other products and vendors available to better handle errors and logging, but for us, the free version of Pentaho is good enough to satisfy our needs.