2020-07-15T07:11:00Z

What do you like most about Pentaho Data Integration?

Miriam Tover - PeerSpot reviewer
  • 0
  • 23
PeerSpot user
22

22 Answers

ES
Real User
Top 20Leaderboard
2022-09-04T22:17:00Z
Sep 4, 2022

We also haven't had to create any custom Java code. Almost everywhere it's SQL, so it's done in the pipeline and the configuration. That means you can offload the work to people who, while they are not less experienced, are less technical when it comes to logic.

Search for a product comparison
Ridwan Saeful Rohman - PeerSpot reviewer
Real User
Top 10
2022-06-26T13:19:00Z
Jun 26, 2022

The abstraction is quite good.

RK
Real User
Top 20
2022-05-30T16:19:00Z
May 30, 2022

One of the most valuable features is the ability to create many API integrations. I'm always working with advertising agents and using Facebook and Instagram to do campaigns. We use Pentaho to get the results from these campaigns and to create dashboards to analyze the results.

VK
Consultant
Top 20
2022-05-25T17:24:00Z
May 25, 2022

We use Lumada’s ability to develop and deploy data pipeline templates once and reuse them. This is very important. When the entire pipeline is automated, we do not have any issues in respect to deployment of code or with code working in one environment but not working in another environment. We have saved a lot of time and effort from that perspective because it is easy to build ETL pipelines.

RicardoDíaz - PeerSpot reviewer
Real User
Top 10
2022-05-19T16:25:00Z
May 19, 2022

Its drag-and-drop interface lets me and my team implement all the solutions that we need in our company very quickly. It's a very good tool for that.

KM
Reseller
Top 20
2022-05-11T06:00:00Z
May 11, 2022

One of the valuable features is the ability to use PL/SQL statements inside the data transformations and jobs.

Learn what your peers think about Pentaho Data Integration and Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.
Anton Abrarov - PeerSpot reviewer
Real User
Top 10
2022-05-11T04:07:00Z
May 11, 2022

It has a really friendly user interface, which is its main feature. The process of automating or combining SQL code with some databases and doing the automation is great and really convenient.

RE
Real User
Top 20
2022-05-10T13:38:00Z
May 10, 2022

I can use Python, which is open-source, and I can run other scripts, including Linux scripts. It's user-friendly for running any object-based language. That's a very important feature because we live in a world of open-source.

RV
Real User
Top 20
2022-05-02T05:34:00Z
May 2, 2022

I can create faster instructions than writing with SQL or code. Also, I am able to do some background control of the data process with this tool. Therefore, I use it as an ELT tool. I have a station area where I can work with all the information that I have in my production databases, then I can work with the data that I created.

Renan Guedert - PeerSpot reviewer
Real User
Top 20
2022-04-12T20:49:00Z
Apr 12, 2022

Sometimes, it took a whole team about two weeks to get all the data to prepare and present it. After the optimization of the data, it took about one to two hours to do the whole process. Therefore, it has helped a lot when you talk about money, because it doesn't take a whole team to do it, just one person to do one project at a time and run it when you want to run it. So, it has helped a lot on that side.

José Orlando Maia - PeerSpot reviewer
Real User
Top 10
2022-04-11T18:31:00Z
Apr 11, 2022

The area where Lumada has helped us is in the commercial area. There are many extractions to compose reports about our sales team performance and production steps. Since we are using Lumada to gather data from each industry in each country. We can get data from Argentina, Chile, Brazil, and Colombia at the same time. We can then concentrate and consolidate it in only one place, like our data warehouse. This improves our production performance and need for information about the industry, production data, and commercial data.

Jacopo Zaccariotto - PeerSpot reviewer
Real User
Top 20
2022-04-05T10:31:00Z
Apr 5, 2022

We can schedule job execution in the BA Server, which is the front-end product we're using right now. That scheduling interface is nice.

Ryan Ferdon - PeerSpot reviewer
Real User
Top 10
2022-03-24T15:23:00Z
Mar 24, 2022

The fact that it's a low-code solution is valuable. It's good for more junior people who may not be as experienced with programming.

Dale Bloom - PeerSpot reviewer
Real User
2022-01-20T22:28:00Z
Jan 20, 2022

I absolutely love Hitachi. I'm one of the forefront supporters of Hitachi for my firm. It's so easy to integrate within our environments. In terms of being able to quickly build ETL jobs, transform, and then automate them, it's really easy to integrate throughout for data analytics.

NA
Real User
2021-12-22T20:41:00Z
Dec 22, 2021

The fact that it enables us to leverage metadata to automate data pipeline templates and reuse them is definitely one of the features that we like the best. The metadata injection is helpful because it reduces the need to create and maintain additional ETLs. If we didn't have that feature, we would have lots of duplicated ETLs that we would have to create and maintain. The data pipeline templates have definitely been helpful when looking at productivity and costs.

TG
Real User
2021-12-22T20:35:00Z
Dec 22, 2021

We're using the PDI and the repository function, and they give us the ability to easily generate reporting and output, and to access data. We also like the ability to schedule.

DP
Real User
2021-12-14T21:23:00Z
Dec 14, 2021

Lumada has allowed us to interact with our employees more effectively and compensate them properly. One of the cool things is that we use it to generate commissions for our salespeople and bonuses for our warehouse people. It allows us to get information out to them in a timely fashion. We can also see where they're at and how they're doing.

PR
Real User
2021-12-13T16:49:00Z
Dec 13, 2021

The graphical nature of the development interface is most useful because we've got people with quite mixed skills in the team. We've got some very junior, apprentice-level people, and we've got support analysts who don't have an IT background. It allows us to have quite complicated data flows and embed logic in them. Rather than having to troll through lines and lines of code and try and work out what it's doing, you get a visual representation, which makes it quite easy for people with mixed skills to support and maintain the product. That's one side of it.

OM
Real User
2021-07-14T17:56:24Z
Jul 14, 2021

It's my understanding that the product can scale.

VM
Real User
2021-02-22T14:48:00Z
Feb 22, 2021

Pentaho Data Integration is quite simple to learn, and there is a lot of information available online.

AG
Real User
2021-01-08T09:43:51Z
Jan 8, 2021

The amount of data that it loads and processes is good.

VD
Real User
2020-07-15T07:11:00Z
Jul 15, 2020

The solution has a free to use community version.

Pentaho Data Integration stands as a versatile platform designed to cater to the data integration and analytics needs of organizations, regardless of their size. This powerful solution is the go-to choice for businesses seeking to seamlessly integrate data from diverse sources, including databases, files, and applications. Pentaho Data Integration facilitates the essential tasks of cleaning and transforming data, ensuring it's primed for meaningful analysis. With a wide array of tools...
Download Pentaho Data Integration and Analytics ReportRead more