Help the communities most affected by the California wildfires in only a few minutes. We'll donate $10 for every review you submit.

Pentaho Business Analytics

4.0
(37)
Optimized for quick response

Modern, integrated, embeddable business analytics and data integration platform built for the future of analytics.

Work for Pentaho Business Analytics?

Learning about Pentaho Business Analytics?

We can help you find the solution that fits you best.

Pentaho Business Analytics Reviews

Ask Pentaho Business Analytics a Question
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • For Category
  • Industry
Ratings
Company Size
User Role
For Category
Industry
Showing 39 Pentaho Business Analytics reviews
LinkedIn Connections
Pentaho review by Eduardo G.
Eduardo G.
Validated Reviewer
Review Source

"There is a huge community working on and testing the new versions "

What do you like best?

Is a very versatile and effective tool, not only applicable in the context of business intelligence or big data, but also in the development of applications, systems migration or even data science (a combination of processes and systems to extract knowledge or a better understanding of data in its different forms)

What do you dislike?

Although it has a large community, there is not much reliable documentation, it has a basic user manual, which does not detail many of the concepts, which hinders the development and deployment of the solution. In addition, most of this documentation is created by users, who usually detail solutions to specific problems.

Recommendations to others considering the product

The tools that are part of the suite have been developed separately. we see ourselves in the obligation to use different methodologies to be able to do the same actions but in different tools, harming the learning and development of possible solutions.

What business problems are you solving with the product? What benefits have you realized?

Thanks to it has a powerful data mining engine and OLAP server, the series of classification, regression, association rules, and clustering algorithms, supported us in the tasks of predictive analysis to discover hidden patterns or future trends.

Sign in to G2 Crowd to see what your connections have to say about Pentaho Business Analytics
Pentaho review by Josbeb D C.
Josbeb D C.
Validated Reviewer
Review Source

"Excellent for handling many data!!!!"

What do you like best?

It allows the flexible migration of data from multiple sources, fully integrable account, n tools which is integrable, scalable and customizable. It has a platform that has a very intelligent architecture, which provides ease of use to the user when needed. This application is spectacular since it has a set of free programs to generate business intelligence and includes integrated reporting tools, data mining, ETL.

What do you dislike?

When presenting an error collapses and erases everything, it means that when the memory fails it can cause damage to the final migration structure. It has to be improved, as you can see in its public activities, they are working on that, it is a BI platform oriented to the solution and it focuses on processes that include all the main components necessary to implement process-based solutions, since has designed from the beginning. Updating the web platform is not easy.

Recommendations to others considering the product

Recommended, but must be more explanatory in the handling of errors that are difficult to detect, has a knowledge base of the support portal, if applicable.

What business problems are you solving with the product? What benefits have you realized?

In a company this software allows to determine and perform defective invoices, as well as in other companies it allows to integrate a large amount of data that turn out to be critical for suppliers with different formats, it can also be implemented for the detection of fraud.

What Self-Service Business Intelligence solution do you use?

Thanks for letting us know!
Pentaho review by Dan M.
Dan M.
Validated Reviewer
Verified Current User
Review Source

"Awesome Free BI Platform"

What do you like best?

Pretty much designed platform. Awesome cost vs bennefit. Nice integration and reports, even better when we analize costs. This is a free platform, reason why, you can realize an awesome perspective of starts using Pentaho and discover all the potencial of this tool. You also, can search and browse a large and constantly growing gallery of custom data visualizations made by users, it´s a huge and awesome structure provide by Pentaho Communit users. You can get quickly up to speed by searching through an online Pentaho visualizations gallery to find the particular presentation template you want to use to show your data.

What do you dislike?

It´s not an intuitive platform. You do need to study a lot in order to make some great progress. New users of Pentaho or folks who are interested in performing a specific task or type of analysis, needs to improve their skills in order to have or make easy their relationship with the tool. Once it´s a free platform, some of our managers dislike this situation, it sounds like, no quality or poor structure security for data and vizualiztions.

Recommendations to others considering the product

Nice to understand about integrations.

What business problems are you solving with the product? What benefits have you realized?

My personal dashboards about our marketing operations, got an amazing views. Even better, all stakeholders got free and easy access to the business data, bring a solid and trust analysis to all departaments of the company. Underwood, our analysis got a improve once we stats to prepares many of the presentations, and posts links with tips, tricks, and sample data sets to explore.

Pentaho review by Henning C.
Henning C.
Validated Reviewer
Verified Current User
Review Source

"A very good tool for Integration and Visualization"

What do you like best?

It was very easy to integrate the database and to receive realtime information and statistics through the tool. It is easy to use even for unexperienced colleagues. The tool is fast and you can easyly analyze your business.

What do you dislike?

Not much. You have to pay for the enterprise edition. Without it especially the graphic solutions are limited.

Recommendations to others considering the product

If you are looking for a convenient tool for business analytics then use Pentaho.

What business problems are you solving with the product? What benefits have you realized?

We are using it for the database integration and especially for analyzing our "numbers" in various marketing channels. Reports and graphic presentations are based on Pentaho.

Pentaho review by Marcello P.
Marcello P.
Validated Reviewer
Verified Current User
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"End-to-end"

What do you like best?

The ETL Tool is always two steps ahead when it comes to BigData awareness. Besides, it's fully embeddable, scalable and customizable.

The Platform has a very smart architecture and it's thought to be extensible and to give the ease-of-use that the user needs. It also presents a great amount of tools and frameworks to build whatever the new techologies bring in terms of Data Vualization/Consumption.

It's opensource!

What do you dislike?

In the latest releases, Pentaho has been tackling their big weaknesses, which is to bring the end user closer to the data side of things. It still has to be improved, especially if you consider the concurrency, but as you can tell from their public activities, they're working on that as I write.

Recommendations to others considering the product

When trying to get help, follow this order"

- Support portal knowledge Base - if applicable;

- help.pentaho.com

- Community Forums - check also your country for local communities;

- jira.pentaho.com - to file or read cases, not to ask for support.

What business problems are you solving with the product? What benefits have you realized?

I've worked on multiple implementations since 2008 and I can give some examples of problems solved such as:

- Determining when water meters start to produce faulty measurements/billing - State level water company;

- Integrating big and critic data from multiple suppliers with different formats but one pipeline;

- Integrating multiple data-mining tools using Pentaho, in order to implement fraud detection on an Insurance Company;

The benefits I can outline are:

- The enormous community that will back you up;

- The reliability of the tool, behind a very responsive support team;

- The fact that when it comes to sustainability, opensource DOES matter, even if you're a big deployer.

Pentaho review by Jim C.
Jim C.
Validated Reviewer
Verified Current User
Review Source

"Great ETL Tool as well as Front End for Business User"

What do you like best?

Pentaho's ETL tool is very stable when compared to something like SSIS. I find SSIS to be very brittle and intolerant of changes to source files, etc. Whereas, with Pentaho, when something changes, it is usually very easy to quickly edit the ETL and get right back to work.

What do you dislike?

The built-in report building tool for pre-formatted reports is archaic. It is as if they just don't think people need something better. Here, SSRS is much superior to it; however, the analysis reports (on-the fly reporting) are great, so it depends on what you need. This tool is better suited toad-hoc reporting than to making a set of uniform looking pre-formatted reports.

Recommendations to others considering the product

The licensing isn't inexpensive, but you can try most of the product for free using the Community Edition.

What business problems are you solving with the product? What benefits have you realized?

We are creating health metrics to improve business process as well as report specific numbers to the Federal government. We use data from our Electronic Medical Record system as well as billing data from providers such as Medicaid and other insurance companies to monitor the trends and health of our patient population.

Pentaho review by Haince Denis P.
Haince Denis P.
Validated Reviewer
Verified Current User
Review Source

"Good Data Cleansing software"

What do you like best?

The tool has ability to drag and drop different functionalities in the window and create a pipeline of tasks through which the data passes, and gets cleaned. Also the ability to create jobs and running them is a very good feature of the system

What do you dislike?

The interface needs some upgrade. It looks a little old and un-engaging. Also the application requires a lot of physical memory and hence slows down the operations. while creating transformations is easy, working on the job creation in pentaho is a cumbersome task and takes a while to complete.

Recommendations to others considering the product

Have good experience on Javascript as it required sometime in the transformations to perform certain cleaning activities on the data.

What business problems are you solving with the product? What benefits have you realized?

I was building a relational data warehouse and used Pentaho for the cleaning purpose.

Pentaho review by Grey P.
Grey P.
Validated Reviewer
Verified Current User
Review Source

"Pentaho"

What do you like best?

app spectacular as it is a set of free programs to generate business intelligence and includes integrated reporting tools , data mining , ETL

What do you dislike?

everything is excellent as it is a BI platform solution-oriented and focused on processes that includes all major components required to implement process-based solutions as it has been designed from the beginning

Recommendations to others considering the product

100 % recommended without hesitation

What business problems are you solving with the product? What benefits have you realized?

many benefits as it is an infrastructure of tools integrated with a workflow engine business process analysis and reporting. The platform is capable of running the business rules necessary , expressed in the form of processes , activities, and is able to present and deliver the right information at the right time

Pentaho review by User in Higher Education
User in Higher Education
Validated Reviewer
Verified Current User
Review Source

"Provides better access to data and insights"

What do you like best?

I like that Pentaho is a drag and drop environment. Like everyone else, our organization has a ton of data, which is stored in a less than ideal manner. Historically, we'd have to create custom joins to get the data we need, but for those in the organization who were not comfortable with joins, they'd either get bad or no data. Pentaho makes this easy for users to get exactly what they want. I also like that Pentaho allows you to quickly adapt your data from table view to chart view, then back to table view without any issues.

What do you dislike?

The dashboard reporting feature could use some visual enhancements. I've only played around with it a few times, but I've not yet figured out how to apply a global filter to all reports within a dashboard, so this feature could be made more intuitive, perhaps.

Recommendations to others considering the product

Converting systems is always a big undertaking, but this one seems well worth the effort.

What business problems are you solving with the product? What benefits have you realized?

All of them. All of our data is being (or will soon be) surfaced using Pentaho, and all data users in the organization will soon have access to the tool. This will be our primary data access tool. I would suggest this product to any business that has multiple data sources.

Pentaho review by Harshita S.
Harshita S.
Validated Reviewer
Verified Current User
Review Source

"Simple way to build Interactive Dashboards"

What do you like best?

It's a very simple and intuitive way to build highly interactive dashboards that help analyze trends and perform other analytics as desired for individuals purposes.

What do you dislike?

Set up in not too easy and it's good to have a database to perform ETL as without it's it's harder to do a deep dive into analytics.

Recommendations to others considering the product

Give the software a try since it's the easiest and fasted way to build dashboards that are highly interactive in nature.

What business problems are you solving with the product? What benefits have you realized?

Quick way to perform analytics that are very visual and interactive in nature. It's easy to manipulate the data and doesn't require one to go into a database each time or an excel spreadsheet to do that. A huge benefit is that you don't need to train employees to use the software, it can be self taught with various resources available online, free of cost.

Pentaho review by Mohan krishna K.
Mohan krishna K.
Validated Reviewer
Verified Current User
Review Source

"Big fan of Pentaho (PDI) tool - opens source community edition"

What do you like best?

I have used PDI (Pentaho Data Integration) tool (community edition) for archiving and error handling capabilities and find it the best in business. It is very easy to use and flexible. Learning curve is very less compared to other integration tools.

What do you dislike?

This tool occupies lot of hard disk space in your machine. Support for analytics also can be improved.

Recommendations to others considering the product

I would recommend Pentaho for simple integration requirements but not for very complex solutions.

What business problems are you solving with the product? What benefits have you realized?

Used Pentaho for archiving and error handling capabilities as part of high volume data loading to Salesforce environment. I find it very easy and flexible to use without any prior training.

Pentaho review by User
User
Validated Reviewer
Verified Current User
Review Source

"Centralized data, but Unimpressive Dashboarding"

What do you like best?

The ability to quickly put together a report with the data loaded into the back-end is useful for bare bones reporting. You can sort through and filter to find the data you need for reporting purposes.

What do you dislike?

It seriously takes several hours to get used to the intricacies of creating even simple reports. Usually, the leads us to just do a data dump into Excel from the tool rather than to go through the pains of designing reporting dashboards.

Recommendations to others considering the product

Look at other market leading tools. Our company is in the midst of a migration to Qlik Sense and considered several other platforms (Microsoft BI, Tableau) before doing so. There's just so much more value in the marketplace than what you get with this package.

What business problems are you solving with the product? What benefits have you realized?

Centralization of data was huge. Benefits include aligning the organization around the one source of truth in the Pentaho system. Before, we had many disparate systems and with Pentaho, there's the ability to go and grab data and create your own report if you have the technical expertise.

Pentaho review by Administrator in Publishing
Administrator in Publishing
Validated Reviewer
Review Source

"Strong and easy to use data integration tool"

What do you like best?

It has rich data connection and user friendly GUI. The spool PDI 's drag and drop features can finish most of requirements, sometimes JAVA script can be more handy for programmers. Pentaho has many big data tools and it is very useful for people with SQL skill set.

What do you dislike?

I am pretty satisfied with its features so far. The only thing I had trouble was to upgrade from old version and a new version, it was not very smooth and had to seek help from Pentaho support team.

Recommendations to others considering the product

This is very mature and easy to use tool and it is easy to adopt and Pentaho has very good support people if you have premium support.

What business problems are you solving with the product? What benefits have you realized?

We use it as ETL tool primarily and this does the job.

Pentaho review by Chaitanya Kumar C.
Chaitanya Kumar C.
Validated Reviewer
Verified Current User
Review Source

"Best Reports Tool"

What do you like best?

It supports the Pentaho Marketplace which provides a place for developers to share their Pentaho plugins.

A really complete BI solution. Excellent ETL module (PDI\Kettle), with some awesome visualizations. The maintaining company acquired Webdetails, one of the main plugin developers.

Pentaho Reporting integrates with the rest of the Pentaho BI Suite.

It has great visualization tools as well as good user experience.

What do you dislike?

This is not fit for very complex reviews.

It's very heavy software.

We faced lot of difficulties when we try to integrate this with Liferay CMS portal.

Recommendations to others considering the product

It's good product if you are looking for less complex reports and also it's a good choice if printed reports are an important requirement.

What business problems are you solving with the product? What benefits have you realized?

I am trying to provide solutions for education industry. I generated attendance, grade reports of students.

Pentaho review by User in Accounting
User in Accounting
Validated Reviewer
Verified Current User
Review Source

"Simple, interactive dashboards "

What do you like best?

It's a very simple way to build an interactive dashboard for quick and detailed analysis especially for non IT users. I've used it to reporting purposes and it helps build reports in multiple formats like PFD and excel. It works very well with SQL.

What do you dislike?

It's not easy to maneuver as it's interface isn't straightforward and simplistic. It's good to integrate it with a database and the setup is not easy and requires some knowledge to do so. Addressing these drawbacks will make it a very useful and powerful tool for BI solutions.

Recommendations to others considering the product

It s a great tool that requires some time and effort in learning how to use it But once you do, you'll love it more than excel or PowerPoint while building reports and dashboards. it's definitely worth a try!

What business problems are you solving with the product? What benefits have you realized?

It's the best way to build simple reports and dashboards than those that can be built in excel or PowerPoint as the e ones built in Pentaho are highly interactive in nature and help drill down to any level of detail for analysis.

Pentaho review by Mauricio L.
Mauricio L.
Validated Reviewer
Verified Current User
Review Source

"Awesome tool, not just for datawarehousing and analysis"

What do you like best?

Awesome tool, not just for datawarehousing and analysis. We use it here for every kind of automation on daily routines. Need to run a report everyday with data from a e-mail, use pentaho to listen for that e-mail and do your report automatically. Of course we use it on our data-integration processes and on analysis end too, all using CE. Really and awesome tool.

What do you dislike?

It's not easy to upgrade the web platform, but that's the only problem with it. And you can get it done with a day or two of tests, just could be easier in the CE.

What business problems are you solving with the product? What benefits have you realized?

Datawarehousing processes in ETL and presentation on dashboards to the end user.

Pentaho review by Igor P.
Igor P.
Validated Reviewer
Review Source

"Pentaho review"

What do you like best?

This product has a free community version that can be used to satisfy BI needs of any organization. Pentaho has a lot of different features and intuitive layout that help build various reports and dashboards. Management was happy to see reports and dashboards in a short period of time.

What do you dislike?

Pentaho does not have powerful ETL functionality which complicates installation and configuration process. The interface of the product also could be improved. Not a lot of user support to solve complicated issues with the product.

What business problems are you solving with the product? What benefits have you realized?

The company was looking to improve its effectiveness through developed reports and established KPIs.

Pentaho review by Minh N.
Minh N.
Validated Reviewer
Verified Current User
Review Source

"Easy to use GUI with lots of functions"

What do you like best?

It is unique because of the ability to drag and drop different components and its integration. It also supports multiple languages and tools like Shell, Javascript, Python, MySQL, PostgreSQL etc.

What do you dislike?

Sometimes it is difficult to debug and the GUI is confusing in several occasions.

Recommendations to others considering the product

It is very intuitive and powerful.

What business problems are you solving with the product? What benefits have you realized?

Extract, Clean and Transform data

Pentaho review by Kenneth P.
Kenneth P.
Validated Reviewer
Verified Current User
Review Source

"Pentaho Is the Perfect Solution"

What do you like best?

Pentaho works as advertised -- it provides a truly drag-and-drop customizable interface for your data.

The Enterprise Suite has everything you need to start working and showing results right away.

Pentaho's customer support has been responsive and timely when we've had issues.

What do you dislike?

The Report Designer interface can seem clunky at times when trying to perform additional calculations on previously calculated fields or pass values to subreports.

There is inconsistency within the tools in Data Integration -- it is clear the various tools were authored by different engineers at different times. It is not always obvious what goes where.

There is inconsistency between all the products within the Pentaho Suite. Each has a different look and feel and none work the same way.

Upgrading can be challenging but Pentaho customer support has been very helpful.

Recommendations to others considering the product

Do you need to integrate data from multiple sources? Pentaho is great for this. Previously, we were SSHing files around and importing with numerous cron scripts.

Are your Finance and Marketing teams constantly asking for one-off queries? Pentaho puts this power in THEIR hands so they can pull and arrange the data they want into whatever view they want.

Do you want to pay too much for a full-featured BI solution? Pentaho is very reasonably priced, and even has a free version!

It has been too long since we did the research (over three years) before choosing Pentaho so I cannot remember exactly which competing products we looked at. In the end, the problem with all the others was that they were too expensive for our small company. Pentaho was reasonably priced and was exactly what we were looking for.

Microsoft, Oracle, SAP, SAS all provide similar, but very expensive products.

What business problems are you solving with the product? What benefits have you realized?

Pentaho serves several roles in our environment.

We use the Pentaho Report Designer for report design and delivery. This tool is fairly straightforward. It feels a lot like Crystal Reports and similar tools. Once reports are complete they are immediately accessible to our end users.

We use Pentaho Data Integration (PDI) for Business Intelligence which includes totals, trends, and forecasts of sales and subscriptions of our services. The browser-based analysis tool allows our end-users to drag & drop measures and dimensions and instantly convert raw data into a variety of graphical representations.

Before we had Pentaho, each view might have required a long query or static report that was hand-exported to Excel. With Pentaho's analysis tool, our sales, finance, and marketing teams have instant insight and infinitely flexible views of our data. Are your Finance and Marketing teams constantly asking for one-off queries? Pentaho puts this power in THEIR hands so they can pull and arrange the data they want into whatever view they want.

In the IT department, we use Pentaho as a scheduling engine for data maintenance jobs as its interface allows us to manage multiple shards from a single source. Previously, we were SSHing files around and importing with numerous cron scripts.

Pentaho is very reasonably priced, and even has a free version!

Pentaho has had tremendous positive influence on how we run our business. It gave us insight into our marketing successes and failures by showing us actual trends before and after pricing sales. It provides a visual representation of subscription revenue so we can accurately plan for marketing and sales strategies.

Pentaho freed up countless man-hours by adding simplicity to our daily data maintenance routines, providing a single interface for data sharded across numerous servers.

Pentaho eliminated time-consuming one-off queries and reports, providing a browser-based user interface that sales, marketing, and finance teams can access from anywhere at any time.

Pentaho review by Consultant in Oil & Energy
Consultant in Oil & Energy
Validated Reviewer
Verified Current User
Review Source

"Big data integration with Pentaho"

What do you like best?

Pentaho offers open source business intelligence solution for data integration with PDI/Kettle ETL module and visulization . It simplifies big data hadoop integration with great flexibility and reduced risk of changes from big data system. It also offers seamless integration with NOSQL databases and connectivity to analytical databases.

What do you dislike?

BI front end is not appealing like other industry leading front ends products.

What business problems are you solving with the product? What benefits have you realized?

Integrating BIG data with pentatho.

Performance improvement for tera/peta byte data.

Pentaho review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"Experience with Pentaho"

What do you like best?

Out of the whole Pentaho suite I love PDI the most. It is a great tool which gives you a lot of opportunities to connect to different data points and embed a lot of logic into your ETL. Besides having variety of predefined steps it allows to use customized codes which tremendously extend ETL functionality.

For Pentaho BI server I think there is a great way for end users to get access to data either through predefined reports or analytics cubes (based on Mondrian schema). I really like the way it is not over-complicated and very much customizable.

What do you dislike?

I think Dashboard functionality can be extended. For more beautiful and professional interface it is advised to use C-tools, but it requires additional development and administration. I'd like to see more dashboarding functionality out of the box solution. Right now it is in a very rudimentary stage.

The other component which requires improvement is Report Designer. It allows you to do many things, but interface is kind of old and not much of documentation available.

Recommendations to others considering the product

For the functionality vs price Pentaho is the great solution.

What business problems are you solving with the product? What benefits have you realized?

I am a head of BI team and we provide our business users with data. We need to present information in a way so business user will be able to create their own reports and make a decision with less customized reports. We introduced cubes, but they still mostly using predefined reports. Dashboarding should solve it and this is direction we are trying to move to.

Pentaho review by Michael M.
Michael M.
Validated Reviewer
Verified Current User
Review Source

"Pentaho Rocks!"

What do you like best?

Using Pentaho Business Integration tools was far easier than I expected. Taking a terabyte of public information and extracting, transforming and loading it into our own data store for quick reporting took less time than we expected saving both our sanity and our labor costs.

What do you dislike?

There is not much to dislike. I think the tools are not exactly intuitive to use but within an hour we had the "aha" moment where it all made sense and we could begin to see the fruits of our eforts.

Recommendations to others considering the product

Give Pentaho a try, you won't be sorry!

What business problems are you solving with the product? What benefits have you realized?

We were taking a bucketful of public data (that changes monthly) and creating a process to extract it, filter and transform it to our needs, and quickly load it into our own data stores. This process would have take us weeks in the past and tweaking the transformations would be tortuous. With Pentaho we could preview the results in seconds and make changes in minutes.

Pentaho review by User in Computer Software
User in Computer Software
Validated Reviewer
Verified Current User
Review Source

"Good tool for BI "

What do you like best?

This is a powerful tool that allows us to produce actionable data that we can easily share company wide.

What do you dislike?

For many of our reports that are larger, it can time out or take a great deal of time

Recommendations to others considering the product

Straightforward to pick up, worth giving a chance. Accomplishes my objectives

What business problems are you solving with the product? What benefits have you realized?

Understanding trends throughout the business, and digging into which customer uses what

Pentaho review by Adam O.
Adam O.
Validated Reviewer
Verified Current User
Review Source

"I use Pentaho for reports within OpenERP and I love it!"

What do you like best?

I like the easy to use report designer and the integration with OpenERP. It definitely requires technical savvy to set up but it is very easy to use once it is. I like that you can parameterize your reports to give clients that ability to filter through data as they would like to see it.

What do you dislike?

The designer is a bit buggy on my Windows 7 machine. I may have the incorrect Java version or it could be a conflicting setting on my machine but that has been frustrating.

Recommendations to others considering the product

If you are considering Crystal Reports or some other popular report writing software, have a look at the trial version of Pentaho. If you're a techy, then you can easily set it up, install the designer and integrate with OpenERP, JDBC and many other popular platforms. There are many ways to connect to your data and the parameterized reporting feature works pretty well and is very helpful. I also like the SQL query builder in the report writer and use it extensively. If you are not a coder or don't know SQL, you can also build your reports using the data object functionality to accomplish much. I love the trial version and here that the paid version for Analytics and Business Intelligence is amazing. I cannot wait to try that.

What business problems are you solving with the product? What benefits have you realized?

I needed to run reports across multiple data models in OpenERP and wasn't able to do it with out Pentaho.

Pentaho review by Amey C.
Amey C.
Validated Reviewer
Verified Current User
Review Source

"Pentaho for Data Migration"

What do you like best?

I loved the Spoon product of Pentaho. It has lot's of possible data sources ready to use, including mongodb, redshift etc. Also you can create your own adapters using Java. This ETL tool is really fast and it's community edition is free.

You can even write you own script to pull data from social media and combine with relational data.

What do you dislike?

There is minimal logging provided out of the box. You need to find some work around to get the logging in place. I didn't like the reporting portion of it. Looks out of date and needs better visualizations.

Recommendations to others considering the product

If you are looking for a low cost, customizable ETL tool, Pentaho is the right choice.

What business problems are you solving with the product? What benefits have you realized?

I used Pentaho to move huge amount of production data from one DBMS to another in very short time frame. It was really fast and could work seamlessly with different DBMS at the same time.

Pentaho review by John B.
John B.
Validated Reviewer
Verified Current User
Review Source

"Probably the best all in one tool on the market"

What do you like best?

The easy to use client tools, multiple out-of-the-box database connections, and simple integration is most notable about this product. Also, it is great for dynamic data-sources and ETL jobs.

What do you dislike?

The administration portion could use some work, currently there is no functionality for the user to change their own password, only an administrator role can do that. Also, using a Mondrian schema directly into a Mongo source is not available, currently we would have to manipulate the data into a relational database in regards to Mondrian schema.

Recommendations to others considering the product

It will be the best investment you ever made. We broke even on it's cost in year one and continue to optimize through our partnerships. We have also added value to our product by offering reporting to our clients.

What business problems are you solving with the product? What benefits have you realized?

We have found hundreds of uses for this tool. From a client CRM, to real-time business metrics, to campaign optimizations, and even as a reporting solution for our clients and vendors (who barter services with us now).

Executives get important top line data in real time, even on their phones; managers now manage instead of putting together excel reports to answer their questions; and the tech team works on several priority tasks instead of wasting time pulling raw data for analysts.

Pentaho review by Leandro G.
Leandro G.
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Perfect for my enviroment"

What do you like best?

Greate Tool for ETL, Easy Dashboard Creation, No License costs in Community Version.

Great Community Support.

What do you dislike?

Native tool to change the layout of main screens (Pentaho Business Analytics)

Pentaho should provide more trainings and certifications based on Community Version.

Recommendations to others considering the product

Patience when starting to working with Pentaho. Learn JS

What business problems are you solving with the product? What benefits have you realized?

I use Pentaho everyday in my Company, providing Business Intelligence Solutions for my Customers.

Pentaho review by Jonathan S.
Jonathan S.
Validated Reviewer
Verified Current User
Review Source

"I used this product to control the loading of an Enterprise Data Warehouse"

What do you like best?

Speed of development and ease of use were the highlights. We were able to use a metadata repository to generate the packages.

What do you dislike?

This is a hard question to answer because we were very satisfied with our experience.

Recommendations to others considering the product

Do not be afraid to try it. The ETL product works well.

What business problems are you solving with the product? What benefits have you realized?

We needed a low cost alternative to a major ETL product we were using. We found that we could replace our previous tool and generate new work at a much faster pace with higher quality using Pentaho.

Pentaho review by Mark J.
Mark J.
Validated Reviewer
Review Source

"Sometimes goes down."

What do you like best?

I do like the ability to chart sales/profits, when it works. There's often a time when it doesn't.

What do you dislike?

I don't enjoy the downtimes involved with using Pentaho. It's frequent.

Recommendations to others considering the product

Try out other services first!

What business problems are you solving with the product? What benefits have you realized?

I'm solving the time-suck that is pulling data that is relevant to our business.

Pentaho review by User in Retail
User in Retail
Validated Reviewer
Review Source

"Easy to use"

What do you like best?

I like the user interface. We have just started using Kettle for ETL. We were using another tool before and we have now switched to Kettle.

What do you dislike?

Still discovering all the features of it. As of now everything looks good.

What business problems are you solving with the product? What benefits have you realized?

ETL. We want to extract , transform and load data on a daily basis.

Pentaho review by Administrator in Investment Management
Administrator in Investment Management
Validated Reviewer
Review Source

"Pentaho kettle - game changer or not"

What do you like best?

I like how it is seemless and make your work easy in ETL world

What do you dislike?

Bottlenecks while using big data and loading the data

Recommendations to others considering the product

Definitely recommmend to work on big data

What business problems are you solving with the product? What benefits have you realized?

It helps me in resolving ETL related problems, let's me load and transform data into easier format using kettle.

Pentaho review by User in Computer Software
User in Computer Software
Validated Reviewer
Review Source

"User through my company"

What do you like best?

The ability to create custom reports for my clients and give me more insight on my business metrics.

What do you dislike?

Sometimes pulling the reports can be a bit cumbersome; we've had several server crashes that impede the ability to pull reports we depend on.

What business problems are you solving with the product? What benefits have you realized?

I can give my clients an insight to past quarter metrics and I can view areas of improvement.

Pentaho review by Consultant in Retail
Consultant in Retail
Validated Reviewer
Verified Current User
Review Source

"Decent analytics on the free version"

What do you like best?

For the free version, the visualization and slice & dice options were great!

What do you dislike?

The implementation is lengthy and tough.

What business problems are you solving with the product? What benefits have you realized?

Tracking performance and growth

Pentaho review by Administrator in Information Technology and Services
Administrator in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"Decent ETL for 0 cost"

What do you like best?

It's open source, very good for small to medium (volume/complexity) processes, simple.

What do you dislike?

It's java based, runs locally (where you have the designer interface), post-SQL transformations are not straightforward.

Recommendations to others considering the product

There's a reason the big ETL tools have a reputation and a price tag associated with. If you need something small and easy to implement, I would highly recommend Pentaho, but I'm not sure how scalable it'll be.

What business problems are you solving with the product? What benefits have you realized?

The main issues solved with this tool were importing/exporting from files (csv/xls) to DB.

Pentaho review by User in Computer & Network Security
User in Computer & Network Security
Validated Reviewer
Review Source

"Received proof of concept using our data; pending purchase."

What do you like best?

The best features are the instant return on investment that we will receive when moving to an ETL solution from multiple single source extract and transform programs. The scalability is HUGE.

What do you dislike?

The pricing model may be different for AWS.

Recommendations to others considering the product

Ask them to demonstrate the product using your own data

What business problems are you solving with the product? What benefits have you realized?

We will be sending data from various source systems into our AWS data warehouse and SFDC.

Pentaho review by Executive Sponsor in Staffing and Recruiting
Executive Sponsor in Staffing and Recruiting
Validated Reviewer
Verified Current User
Review Source

"Good ETL product, mediocre reporting product. "

What do you like best?

Pentaho ETL product is good and seems to scale well. Has comparable functionality to Informatica.

Wide range of connectors / transformations to pretty much do any transformation.

Support is fairly responsive and knowledgeable.

What do you dislike?

Reporting products are mediocre at best. Their various reporting products are quite buggy.

Pentaho Consulting is expensive. Go with a 3rd party firm. I would not recommend using Pentaho Consulting at all.

The metadata layer is not very intuitive / easy to use. Error messages are vague. Product documentation is poor.

No perpetual licensing. Same cost every year. Therefore, there isn't a large upfront investment, but a recurring one.

Recommendations to others considering the product

Use this only if you have budget constraints or if you are in the infancy stages of your BI implementation.

Their ETL product is very good and robust.

Pentaho review by Industry Analyst / Tech Writer in Marketing and Advertising
Industry Analyst / Tech Writer in Marketing and Advertising
Validated Reviewer
Verified Current User
Review Source

"Pentaho Review"

What do you like best?

Wraps reporting duties in a user-friendly manner, and Report Designer allows for easy customization.

What do you dislike?

The user interface could stand to be more refined; Auto-submit or text entry functions could stand to not refresh every time.

What business problems are you solving with the product? What benefits have you realized?

Streamlining the process so much of our reporting is automated. Pentaho has been a huge help for this, and we hope it continues to help us as it is ungraded and refined.

Pentaho review by User in Non-Profit Organization Management
User in Non-Profit Organization Management
Validated Reviewer
Review Source

"Experience with etl module"

What do you like best?

Software allows you great flexibility to connect to a variety of data sources

What do you dislike?

Does not natively connect to Microsoft authentication (NTLM over SSL). This can cause problems when trying to connect to Sharepoint web services.

What business problems are you solving with the product? What benefits have you realized?

Process automation is the goal. Pentaho has served us well in that regard.

Pentaho review by Administrator in Consumer Electronics
Administrator in Consumer Electronics
Validated Reviewer
Review Source

"Pentaho PDI is awesome "

What do you like best?

Love their Kettle product. We have used both the BA and PDI and stopped using BA.

What do you dislike?

The BA Server and admin dashboard. Filter logic leaves something to be desired.

What business problems are you solving with the product? What benefits have you realized?

Standard ETL , the product is easy to learn and simple to use.

Kate from G2 Crowd

Learning about Pentaho Business Analytics?

I can help.
* We monitor all Pentaho Business Analytics reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.