Pentaho Data Integration and Analytics
Hitachi Vantara LLC | 10.2.0.3 (10.2 with Service Pack 3)Linux/Unix, Ubuntu Ubuntu 20.04 LTS - 64-bit Amazon Machine Image (AMI)
External reviews
21 reviews
from
and
External reviews are not included in the AWS star rating for the product.
PDI, best data cleaning tool
What do you like best about the product?
Pentaho comes in two editions, enterprise and community, I had experience with the community edition and here are all the advatages I see:
1. Its under apache2.0 license so while you read and work under the agreements, you can have this powerful tool for free
2. Has a very friendly user interface, so anybody, even without strong programming skill could make some transformations in just minutes
3. It has a wide variety of data inputs formats, allowing you to read from simple csv's or excels files to databases, json's and even s3 storage
4. It has a lot of tools for transformating your data without coding
5. If the functions that PDI has integrated aren't enough for you, you can add some scripting steps
1. Its under apache2.0 license so while you read and work under the agreements, you can have this powerful tool for free
2. Has a very friendly user interface, so anybody, even without strong programming skill could make some transformations in just minutes
3. It has a wide variety of data inputs formats, allowing you to read from simple csv's or excels files to databases, json's and even s3 storage
4. It has a lot of tools for transformating your data without coding
5. If the functions that PDI has integrated aren't enough for you, you can add some scripting steps
What do you dislike about the product?
I see a strong oportunity on improving their documentation, sometimes its kinda hard finding examples for all the functionalities that PDI offers
What problems is the product solving and how is that benefiting you?
I mainly use pantaho for transforming data on the ETL cycle, so I do cleansing of different sources and storage it in a DWH
Open Source ETL Tools
What do you like best about the product?
Pentaho Data Integration (PDI) is a free and open source tool for all users.
Pentaho Data Integration (PDI) is a very high performance product compared to the paid ETL tools. The product is quite simple to use. The components on the left side of the product have all the components that the user needs. (For example; excel connection, row value, etc.) In my experience, the Logging screen is not descriptive. Sometimes you cannot identify the source of the error. Other than that, I am very satisfied with the PDI tool
Pentaho Data Integration (PDI) is a very high performance product compared to the paid ETL tools. The product is quite simple to use. The components on the left side of the product have all the components that the user needs. (For example; excel connection, row value, etc.) In my experience, the Logging screen is not descriptive. Sometimes you cannot identify the source of the error. Other than that, I am very satisfied with the PDI tool
What do you dislike about the product?
Since there are no detailed explanations of the errors on the logging screen, sometimes we cannot find the cause of the error. Also in the user community microsoft, oracle is not as strong.
What problems is the product solving and how is that benefiting you?
We needed to import the data from the json file into the tables in the database. With the Pentaho Data Integration tool, we have transferred the json files to the database. We designed daily job with Windows Task Scheduler.
Great Business Intelligence Tool
What do you like best about the product?
The most like about Pentaho report data integration is it can handle large, millions of data files with no hussle, You can extract data from different databases with such a small amount of time. From data extraction you can use the report to build more power analytic chart and business intelligence that my colleagues helps a lot specially the sales and production to overcome the problems we can face on the future.
What do you dislike about the product?
Its not a dislike but i observe that when i run pentaho verions 3 the bootup is fast while on version five on above it takes a 5 to 7 minutes. I dont know if this is involve with the specs of the computer or the pentaho version itself has lot of features to load.
What problems is the product solving and how is that benefiting you?
The problem that i solve using pentaho data integration is extract million of different data from our databases and turn it on the reports and analytic charts that help my sales and production team on analyze problem on our product sales.
Recommendations to others considering the product:
When you need a powerful business intelligence tool pentaho data integration is perfect for you, It's extraction capabilities is so great, no hustle and easy to use,
Pentaho review
What do you like best about the product?
Pentaho is a BI tool which can provide Data Integration, reporting , statistics dashboards data mining and Extract Transform Load, ETL tools.
What do you dislike about the product?
It turns out to be a bit slow as compared to its competitors. Other than that i do not dislike anything about the tool
What problems is the product solving and how is that benefiting you?
We have used it in our project to integrate and reconciliation of huge data and also to report the stats
Used pentaho for ETL job and to run dataflow in Clarabridge
What do you like best about the product?
It is easy to use with graphical options for various things such as transformation.
What do you dislike about the product?
There should be better documents for first-time users. When users use the tabs for the first time, it can ve confusing to them. Beside that better community support is required for the application so that enterprise can report bugs easily in the software.
What problems is the product solving and how is that benefiting you?
Collecting and analyzing customer experience.
Recommendations to others considering the product:
Better documents is needed.
ETL transformation done right
What do you like best about the product?
Ability to inject custom scripts as part of the transformation process
What do you dislike about the product?
UI/UX is not so friendly. Guess there is improvement on that front.
What problems is the product solving and how is that benefiting you?
I used it for data migration of millions of customer records for a big organization and I don't know if there was a better way to do it without Pentaho.
Excellent ETL UI for the non-programmer
What do you like best about the product?
PDI (previously known as Kettle) is an excellent data cleansing and transformation tool for the non-programmer. It has an excellent UI for users to build data flows without knowing how to code!
What do you dislike about the product?
You are limited to the modules and steps that the tool offers. There are excellent modules that is already offered but I heard there are some that you will not find here.
What problems is the product solving and how is that benefiting you?
We use PDI for data cleansing and data prepping, especially when data is across multiple environments.
Recommendations to others considering the product:
Check out the community version.
Excellent BI tool
What do you like best about the product?
Excellent BI tool, I think it is very convenient to publish reports for client, it is also very useful to download reports to PDF and excel
What do you dislike about the product?
In version 4 of pentaho had very interesting things which were lost in the new versions, also the application at that time had better performance
What problems is the product solving and how is that benefiting you?
We use Pentaho as the report orchestrator, where we use it to show our clients sales reports
Just what you need to integrate data in low cost
What do you like best about the product?
Pentaho data integration is a multiplatform (Java) ETL tool (and more) it allow their users to intuitively integrate data through multiple data sources, it is easy to use and really powerful
What do you dislike about the product?
The setup is not the most intuitive, you may manually configure your Java environmental variables and install additional database drivers
What problems is the product solving and how is that benefiting you?
Data integration is always challenging and this tool makes it really easy, no matter if you are integrating data over a data warehouse or just migrating data
Great tool. Easy to learn with infinite value
What do you like best about the product?
I love the visual ETL builder. PDI offers a very large selections of out of the box steps that fortunately have fantastic documentation behind them.
What do you dislike about the product?
I would really like to see the email notification process to be a bit more simple. Paramatizing your email configuration helps, but I still believe it could be easier for the users.
What problems is the product solving and how is that benefiting you?
We are doing a lot with PDI. We have found the tool excellent for migrating data between applications. We have recently started to use it to create monitors on data and applications.
showing 11 - 20