Pentaho Data Catalog

What do you like best about the product?

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.

What do you dislike about the product?

Sometimes faces performance issues when data volume is huge

What problems is the product solving and how is that benefiting you?

We are using for our data pipelines and it's benifits us for loading of data used for our application and we use it for reporting purposes.

What do you like best about the product?

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.

What do you dislike about the product?

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.

What problems is the product solving and how is that benefiting you?

It is usually best to transfer huge data from one source to another like Oracle to Hue. It is best to generate reports into Excel using SQL queries.

What do you like best about the product?

Best price in market, Hitachi sponsored and high quality in data integration.

What do you dislike about the product?

Limitation in features, connector is having portability issue and less user friendly.

What problems is the product solving and how is that benefiting you?

We used PDI for data integration for designed reports. So far, had the best experience.

What do you like best about the product?

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.

What do you dislike about the product?

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.

What problems is the product solving and how is that benefiting you?

PDI allows us to obtain data from various data sources such as databases, excel files, csv, big data / hadoop type databases and use preconfigured tools so that obtaining this data is simple and parameterizable. Other languages such as python require the writing of complete modules, with PDI the implementation and debugging are integrated through Plug & Play tools.

Recommendations to others considering the product:

The Pentaho suite has a Community version that is free and free software, so our recommendation is to download it and test it to verify that this tool meets your requirements. For our part, we recommend it as we use it practically whenever we need to extract data from a data source quickly and easily.

What do you like best about the product?

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.

What do you dislike about the product?

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.

What problems is the product solving and how is that benefiting you?

Pentaho Data Integration allows us to collect data from different data sources such as both relational and non-relational databases such as Big Data (HDFS), it allows us to bring information from Excel files ... and almost from any source of information we need. Also, their debugging tools save us a lot of time.

Recommendations to others considering the product:

Pentaho has a suite called Community that is free and available to everyone. In addition, it has many examples and information. We recommend trying it out before deciding if we need to purchase the paid version. It is a great tool and we recommend it.

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

What do you dislike about the product?

I see a strong opportunity in improving their documentation; sometimes it's kind of 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 Pentaho for transforming data in the ETL cycle, so I do cleansing of different sources and store it in a DWH.

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

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.

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

What do you dislike about the product?

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.

What problems is the product solving and how is that benefiting you?

The problem that I solve using Pentaho data integration is extracting millions of different data from our databases and turning it into reports and analytic charts that help my sales and production team analyze problems in our product sales.

Recommendations to others considering the product:

When you need a powerful business intelligence tool, Pentaho data integration is perfect for you. Its extraction capabilities are so great, no hassle and easy to use.

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

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.