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 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.

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 most valuable feature of Pentaho is the Tableau report.

• Open Source Community Edition feature - helped us a lot with our budget in the beginning of our project
• Ability to produce different types of visualizations (on par with Tableau) - map, pie, bar, heat map, table etc. Several other different options like exporting to CSV, downloading a table and so on
• Ability to integrate with different databases seamlessly - Hadoop, MySQL etc
• Ability to highly customize the dashboards to the developer's preference.

Pentaho Data Integration - Even though this is the community edition it is very powerful compared to other expensive products like MS SQL, SSIS, or Informatica.

• Pentaho data integration
• Most of the ETL stuff can be done with minimal coding
• Reporting capabilities

Pentaho is a suite with five main products: Pentaho Data Integration for ETL, Pentaho Business Analytics Server for results delivery and development clients Report Designer, Metadata Editor and Schema Workbench.

Pentaho Data Integration's (PDI, former Kettle) features and resources are virtually unbeatable as it can handle everything from the smallest Excel files to the most complex and demanding data loads. It's able to scale from a single desktop computer to lots of nodes, on premises or in the cloud. Not only is it powerful, but it is also easy to use. I have never worked with anything else, like Informatica's PowerCenter or Microsoft's SSIS but I have always taken the opportunity to inquire who has. Lastly, PDI is easier to use and achieves more with less effort than those other products.

Then there is the Pentaho BA Server, built to be the linchpin on BI delivery for enterprises. It is built on a scalable, auditable platform able to deliver from dashboards and reports to OLAP and custom-made features. It supports background processing, results bursting by e-mail, load balacing (through native Java Webserver - like Tomcat - load balancing features), integration with corporate directories services as MS Active Directory and LDAP directories, with account management and lots of bell and whistles.

The suite's plugin architecture deserves a special remark: Both PDI and BA Server are built to be easily extended with plugins. There are two plugins marketplaces, one for PDI and onde for BA Server, with a good supply of diverse features. It all those plugins are not enough, there are means to develop you own plugin either coding in Java (mostly for PDI) or, for the BA Server, with point-and-click ease with Sparkl, a BA Server plugin for easy development and packing of new BA Server plugins (but some need of JavaScript, CSS and HTML is needed.)

Any company is able to design and delivery a deep and embrancing BI strategy with Pentaho. At its relatively low prices, when sided with comparable competition, the most valuable features are the data integration and the results delivery platform.

Pentaho Business Analytics platform overall is an outstanding product that offers great cost saving solutions for companies of all sizes. The Pentaho Business Analytics platform is built on top of several underlying open source projects driven by the community’s contributions. There are several features that I find invaluable and with each release, improvements are made.

The Pentaho User Console provides a portal for users that makes it easy for users to explore information interactively. Dashboard Reporting, scheduling jobs, and managing data connections are some of the features that are made easy with the console. For more advanced users you can extend Pentaho Analyzer with custom visualizations or create reporting solutions with Ctools. The Marketplace empowers the community to develop new and innovative plugins and simplifies the installation process of the plugins for the users of the console. The plugin framework provides a plugin contributor that extends the core services offered by the BI Server.

Pentaho Data Integration (Spoon) is also another valuable tool for development. Spoon delivers powerful extraction, transformation, and load capabilities using a Metadata approach. The Data Integration graphical drag and drop design is easy for new users to follow and can increase productivity. More advanced users can extend Pentaho Data Integration creating transformations and jobs dynamically.

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 Data Integration (PDI).

Pentaho Analysis Services

Pentaho Reporting

Transformations. The wide range of transformations that are available in product suite, enable me to do data cleaning, transformation and mapping. I have used Pentaho mostly for ETL purposes.

Here are the valuable features:

• Open source solution
• Fully integrated
• Customizable
• Extensible with a large community behind it
• Has a powerful ETL process (Pentaho Data Integration)

Pentaho Analyzer (EE)

Saiku (CE)

Marketplace (CE)

R (EE and CE)

Community Dashboard Framework (CE)

Dashboard Editor (EE)

I use the BI Server, CDE Dashboards, Saiku, and Kettle, because these tools are very good and highly experienced.

I found Pentaho Data Integration the most valuable component since it is the most mature open-source ETL tool available. Compared to other proprietary products it has a less steep learning curve due to it's very intuitive user interface. Besides that it has a pluggable architecture which makes it quite easy to extend with custom functionality and features.

Another thing worth mentioning is the very active user community around the products which provide some great resources for community support.

We use both DataStage and Pentaho, but I don't see any special features in Pentaho that is not available in DataStage, except Big Data plugins and connectors. These are default in Pentaho, and for those who have expertise in Java and Java script can write their custom code or enhance and call from Pentaho's code.

Speed, performance and for me the best one is integration with any data type, including Big Data.

- Correct URL integration

- Excelent Look & Feel

- Good Dashboards integration with Bootstrap

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

Easy to use components to create the job.

• Business analytics
• CDE
• Flexible dashboard development
• Cube

It's free and easy to use. You can actually explain it to any non-ETL developer.

Pentaho Data Integration.

The data integration feature is the most valuable feature for us.

Pentaho Business Analytics tool provides ETL. Easy creation of Analyser, interactive & attractive dashboards.

Pentaho BA server is supported by CDE (Common Dashboard Editor) to create responsive Dashboard which can used in Mobile.

The ability to maintain historical data.

• OLAP analysis (in CE edition JPivot)
• Dashboards (CDF + CDE)

Everything related to ETL.

I really like Pentaho Data Integration, an ETL tool that makes your Extract, Transform and Load process easy, with rich functionality and nice design tools. And, for some reason creating your own plugin is very easy.

My company embeds the following features into our product -

• BI server
• Analyzer report
• Interactive report
• Dashboard

• Spoon
• Schema work bench
• CDE dashboards
• Client budget