We performed a comparison between Pentaho Data Integration and Analytics, SSIS, and Unifi based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."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."
"The abstraction is quite good."
"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."
"One of the valuable features is the ability to use PL/SQL statements inside the data transformations and jobs."
"This solution allows us to create pipelines using a minimal amount of custom coding."
"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."
"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."
"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."
"The performance is good."
"It's already very user-friendly and has a good dashboard."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"It has good data integration and good processes."
"We can connect with multiple data sources easily using an external connector in SSIS."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"The data reader is the most valuable feature."
"It is easy to set up the solution."
"The controller makes it easy to control everything from one platform. The management is easy."
"It's easy to manage and support the user, our guests, and our customers if they have a problem."
"The support for the Enterprise Edition is okay, but what they have done in the last three or four years is move more and more things to that edition. The result is that they are breaking the Community Edition. That's what our impression is."
"It's not very stable, at least not in the case of the community edition. I'm working with the community edition right now and I think perhaps it is because of that it is not very stable, it causes the system to sometimes hang. I'm not sure if this is the case for pair tiers."
"As far as I remember, not all connectors worked very well. They can add more connectors and more drivers to the process to integrate with more flows."
"I have been facing some difficulties when working with large datasets. It seems that when there is a large amount of data, I experience memory errors."
"If you develop it on MacBook, it'll be quite a hassle."
"I would like to see more improvements with AS400 DB2."
"There is not a data quality or MDM solution in the Pentaho DI suite."
"I would like to see improvements made for real-time data processing."
"At one point, we did have to purchase an add-on."
"Performance could be better."
"I would like to see better technical documentation because many times information is missing."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"It would be nice if you could run SSIS on other environments besides Windows."
"Video training would be a helpful addition."
"It's a legacy tool, that is nearing the end of its useful life."
"It's stable, but it depends on the office and location."
"There are issues with certain Apple devices."
More Pentaho Data Integration and Analytics Pricing and Cost Advice →