We performed a comparison between Informatica Data Integration Hub and Informatica PowerCenter based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The MDM solution is capable of integrating multiple systems, so it helped us to solve the purpose of centralizing the depository as well as the standardization of mass data. It takes away all the ambiguity around data integrity issues or all the process challenges which happen when every stage of a process uses a different source as master data."
"The technical support services are good."
"Performance and flexibility-wise, they're very user-friendly."
"Informatica PowerCenter is a very good ETL tool."
"The setup is straightforward."
"It is easy to use, and it is quick for developing things. It is fairly powerful, and it can integrate with a lot of different platforms without much hassle."
"It has helped us monetize."
"To me, what's most valuable in Informatica PowerCenter is the flexibility in building the integration pipeline. Usually, you need to have a platform to be able to integrate with different technologies, including legacy data such as the mainframe. The platform should also be rich enough to transform the data per your business requirement, with no restrictions. Rich integration and rich transformation capabilities are the two key capabilities in Informatica PowerCenter. The solution also offers ease of use. Another valuable feature of Informatica PowerCenter is the drag-and-drop integration because it's GUI-based, similar to IBM and Oracle."
"What I like the most is that we have to deal with less while writing the queries."
"The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"Deployment was simple and straightforward."
"The initial setup was not very straightforward. Not complex, but not very simple either."
"They could provide more robust performance for data integration processes. It would help in improving the data quality more efficiently."
"When it comes to UI look and feel and user experience, Informatica is not as good as other solutions."
"The pricing could be improved."
"Informatica, in my opinion, is very rigid and not very flexible, whereas platforms like Alteryx or Matillion are very flexible and agile."
"PowerCenter could integrate better with cloud applications. We had to do a lot of configuration work using API integrations to connect with cloud applications. Informatica Cloud Data Integration has a generic connector that you can use directly, so it's much easier."
"Informatica are very rigid when it comes to cloud migrations which discourages customers in moving their solution to the cloud."
"We had to take on a large volume of data from the legacy Sybase system. This was taking a very long time, i.e., more than a day. We were trying to improve it with partitions to gpload, but we were told that we can't go more than four partitions."
"Integration with Artificial Intelligence would benefit this solution."
"What needs improvement in Informatica PowerCenter is the cloud experience because, nowadays, other companies, such as AWS, Azure, and Google, have more experience in the cloud. The pricing for Informatica PowerCenter on the cloud is also very expensive for customers, so some customers prefer open-source tools or lower-priced tools, such as Azure. From my point of view, Informatica must work on the pricing policy and review the policy on the cloud for Informatica PowerCenter or propose more tools with lower pricing. Clients want the automatic integration of Informatica PowerCenter with other tools. Currently, the integration process is manual, and you have to add other tools to facilitate the integration, especially with the DevOps methodology. You need scripts and tools for the integration, and you'll need to use other integration tools if you want automatic deployment for Informatica PowerCenter, so this is another area for improvement in the solution. What I'd like to see in the next release of the solution is for the integration with APIs to be simpler, because currently, the API integration feature of Informatica PowerCenter is very difficult. It's not intuitive. You have to facilitate API integration and the real-time streaming of messages in Kafka, for example, so that should be improved."
"It would be nice to have all tools in one place. CDC needs more effort, as it's only easy to develop if you are familiar with Linux."
More Informatica Data Integration Hub Pricing and Cost Advice →
Informatica Data Integration Hub is ranked 37th in Data Integration with 3 reviews while Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews. Informatica Data Integration Hub is rated 8.0, while Informatica PowerCenter is rated 8.0. The top reviewer of Informatica Data Integration Hub writes "Excellent at standardizing mass data and capable of integrating with multiple solutions ". On the other hand, the top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". Informatica Data Integration Hub is most compared with AWS Database Migration Service, Azure Data Factory, Mule Anypoint Platform, SAP Data Hub and SAS Data Management, whereas Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and AWS Glue.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.