We performed a comparison between Informatica PowerCenter, Pentaho Data Integration and Analytics, and Unifi based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."Enterprise-scale ETL solution that's very stable and is easy to scale. It integrates and connects with multiple new systems, both structured and semi-structured."
"Deployment was simple and straightforward."
"The number of docs has been reduced drastically, which is very good."
"Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse."
"It reduces a lot of legacy coding."
"The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness."
"The partitioning and optimization to help enhance our development is a very valuable aspect of Informatica PowerCenter."
"It's very easy to use it to develop mappings and workflows."
"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."
"The amount of data that it loads and processes is good."
"Provides a good open source option."
"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."
"This solution allows us to create pipelines using a minimal amount of custom coding."
"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."
"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."
"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."
"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 solution does not scale."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"PowerCenter has three clients. I wish they would consolidate everything into one GUI, not three. Also, we had a persistent issue with the Informatica Developer tool but it was solved when we migrated to the newest one."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
"There is some room for improvement in terms of pricing."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"I would like to see an improvement in the digital adoption."
"The reputation of Informatica is that it is expensive."
"If you're working with a larger data set, I'm not so sure it would be the best solution. The larger things got the slower it was."
"If you develop it on MacBook, it'll be quite a hassle."
"Since Hitachi took over, I don't feel that the documentation is as good within the solution. It used to have very good help built right in."
"In the Community edition, it would be nice to have more modules that allow you to code directly within the application. It could have R or Python completely integrated into it, but this could also be because I'm using an older version."
"The testing and quality could really improve. Every time that there is a major release, we are very nervous about what is going to get broken. We have had a lot of experience with that, as even the latest one was broken. Some basic things get broken. That doesn't look good for Hitachi at all. If there is one place I would advise them to spend some money and do some effort, it is with the quality. It is not that hard to start putting in some unit tests so basic things don't get broken when they do a new release. That just looks horrible, especially for an organization like Hitachi."
"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."
"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."
"One thing that I don't like, just a little, is the backward compatibility."
"There are issues with certain Apple devices."
"It's stable, but it depends on the office and location."
More Pentaho Data Integration and Analytics Pricing and Cost Advice →