Pentaho Data Integration Reviews & Product Details

Pentaho is one of the best etl tool to extract ,transform and load the data among various sources ,it just requires connections of 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 fast like any other application and also required some tutorials from pentaho 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, Ouput, 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 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 Review collected by and hosted on G2.com.

I see a strong oportunity on improving their documentation, sometimes its kinda 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 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. Review collected by and hosted on G2.com.

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. 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 us which is a added advantage. Review collected by and hosted on G2.com.

1. While using Kettle environment variables the appication doesnt 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.