Pentaho is one of the best ETL tools to extract, transform, and load data among various sources. It just requires connections to the database and transfers data very fast. It also executes SQL and generates reports into Excel or any other required source. It has all basic components like execute SQL, table input, Excel input, Excel output, TXT output, HDFS output. Review collected by and hosted on G2.com.

Pentaho job runs fast but modifying a job is time-consuming. It is usually so slow. Better if it were as fast as any other application and also required some tutorials from Pentaho's side. Review collected by and hosted on G2.com.

It's a open source software still it's a very user-friendly interface and I just love all functionalities . It's a very simple design steps which are self explanatory kind of , easy to use. Review collected by and hosted on G2.com.

Sometimes faces performance issues when data volume is huge Review collected by and hosted on G2.com.

Best price in market, Hitachi sponsored and high quality in data integration. Review collected by and hosted on G2.com.

Limitation in features, connector is having portability issue and less user friendly. Review collected by and hosted on G2.com.

Pentaho Data Integration (aka Kettle) is a tool included in the Pentaho suite that we use in our Smart Cities projects to obtain data from various data sources. It has a large number of tools already built for Input, Output, Transform ... that allow developers to save a lot of time. Its use is easy even for inexperienced users. Review collected by and hosted on G2.com.

If we want to have support with the Pentaho suite we should not use its Community version (free), but in some Smart Cities specifications of our clients they require a free and open source tool with associated support. Review collected by and hosted on G2.com.

Pentaho comes in two editions, enterprise and community, I had experience with the community edition and here are all the advantages I see:

1. It's under the Apache 2.0 license, so while you read and work under the agreements, you can have this powerful tool for free.

2. It has a very friendly user interface, so anybody, even without strong programming skills, could make some transformations in just minutes.

3. It has a wide variety of data input formats, allowing you to read from simple CSVs or Excel files to databases, JSONs, and even S3 storage.

4. It has a lot of tools for transforming your data without coding.

5. If the functions that PDI has integrated aren't enough for you, you can add some scripting steps. Review collected by and hosted on G2.com.

I see a strong opportunity in improving their documentation; sometimes it's kind of hard finding examples for all the functionalities that PDI offers. Review collected by and hosted on G2.com.

Pentaho data integration is one of the most powerful tools for building ETL processes that we use within our Smart Cities projects. It is a tool with a graphical interface that allows you to debug quickly and easily and has a multitude of preconfigured modules. Furthermore, it combines very well with the Hitachi Pentaho CDE tool for the generation of Dashboards. Review collected by and hosted on G2.com.

When you want to do a very simple development maybe you can choose to use Python source code directly. There are other powerful alternatives like Talend Studio. Review collected by and hosted on G2.com.

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 Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

The most like about Pentaho report data integration is it can handle large, millions of data files with no hassle. You can extract data from different databases in such a small amount of time. From data extraction, you can use the report to build more powerful analytic charts and business intelligence that helps my colleagues a lot, especially in sales and production, to overcome the problems we might face in the future. Review collected by and hosted on G2.com.

It's not a dislike, but I observe that when I run Pentaho version 3, the bootup is fast, while on version five and above, it takes 5 to 7 minutes. I don't know if this is related to the specs of the computer or if the Pentaho version itself has a lot of features to load. Review collected by and hosted on G2.com.

1. Easy to use GUI drag & drop option.

2. Single view of the complete process.

3. Sharing connections makes it easy for different jobs.

4. Ability to change or modify individual transformations is very helpful.

5. It is a free tool to use which is an added advantage. Review collected by and hosted on G2.com.

1. While using Kettle environment variables, the application doesn't work as intended, which can be frustrating.

2. Unless paying for the tool, the implementation is something that one has to figure out by themselves. Review collected by and hosted on G2.com.

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! Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.