We performed a comparison between Informatica Cloud Data Integration and Informatica PowerCenter based on our users’ reviews in four categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: These are two exceptional solutions under the Informatica Brand, which is synonymous with quality, reliability, and high price. Informatica Cloud Data is created and best suited for small to medium organizations and it remains somewhat limited in the regions it can be used. Informatica PowerCenter is best for large enterprises that can utilize all of the numerous options PowerCenter has to offer. Large enterprises can more easily absorb the high cost and make better use of their current bundle licensing tier.
"REST API: Excellent for scripting control and reporting mechanisms"
"The mass ingestion functionality and the elasticity of the solution are great."
"Their new licensing is very flexible. With Informatica Cloud, you have plenty of items under the same umbrella, such as services, offerings, data quality, and data masking. You have also got master data management and API management. What I really like about them is that you don't need to go to Informatica and say that you need a data integration module. You would say that you need iPaaS or Informatica Cloud. They'll then try to understand your needs and give you IPUs, which are the processing units. If I purchased a hundred IPUs from Informatica as a customer, I can use 70 IPUs for data integration. I would also need data quality, so I can use 10 IPUs for data quality. I can use the remaining 20 IPUs for API management. Down the line, if I see that my initial data integration needs for the development phase are met, then out of the 70 IPUs assigned for data integration, I can use 30 IPUs for data masking. I can shuffle these numbers in any way within the Informatica Cloud umbrella for the tenure for which I have subscribed to these IPUs. I can use all services the way I want. This flexibility is what I really love about Informatica. It also has got good connectors."
"The Mapping Configuration and PowerCenter wizards are valuable. We use them to run our business logic."
"The program is stable and scalable."
"The most valuable feature of Informatica Cloud Data Integration is Pushback. You are able to push the data to the solution itself, and it can handle the queries. It helps us a lot. With other tools, the burden is kept on the server."
"The solution is straightforward."
"We have a lot of integrations, and it's very easy to create integrations. They have a lot of connectors."
"The most valuable features are the monitoring tools and the reporting manager."
"Good product if you are trying implement data quality, data integration, and data management projects."
"It works with any multi-databases, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use."
"Good interface, reasonable documentation."
"It's a complete package, which is why we use this solution."
"The most valuable features are the dynamic reading of the file metadata profile, and the ability to define business rules that are used to verify and validate the uploaded files."
"Has a good visual tool for data mapping."
"The reliability of the product and the way of orchestration of different services is valuable to us."
"Error reporting and debugging need improvement."
"The regions in which the data resides are still limited. This could be an issue in terms of the data residency laws of some of the countries. They should get more regions."
"The cloud version could be better in terms of pricing."
"The error information provided is not informative, as compared to Power Center."
"The cloud version of the Informatica, it's a very substandard product. They might say it's enterprise-ready but it's not at all ready. They need to add more features, such as improved data replication features. If you look at other tools, such as Matillion they are now cloud-native and flexible. Additionally, Informatica Cloud Data Integration should have a good migration strategy from Informatica PowerCenter to Informatica Cloud Data Integration."
"Its features for partitioning and optimization could be better."
"The integration process is not easy."
"With the solution, we had some issues, and we have every day, and we used to open a ticket. Sometimes, there are data issues and transformation issues."
"Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"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."
"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together."
"The solution could have better documentation on basic steps or blocks that specify what to do."
"In terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"While on-premises is a better product, we really need to move to the cloud and need the cloud to be as robust as this product."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"Requires an established data center because there is no option for software as a service."
More Informatica Cloud Data Integration Pricing and Cost Advice →
Informatica Cloud Data Integration is ranked 5th in Cloud Data Integration with 40 reviews while Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews. Informatica Cloud Data Integration is rated 7.8, while Informatica PowerCenter is rated 8.0. The top reviewer of Informatica Cloud Data Integration writes "A stable, scalable, and user-friendly solution". 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 Cloud Data Integration is most compared with Azure Data Factory, AWS Glue, Fivetran, IBM Cloud Pak for Data and Mule Anypoint Platform, whereas Informatica PowerCenter is most compared with Azure Data Factory, SSIS, Databricks, AWS Glue and Oracle Data Integrator (ODI). See our Informatica Cloud Data Integration vs. Informatica PowerCenter report.
See our list of best Cloud Data Integration vendors.
We monitor all Cloud 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.
Both are powerful solutions and most of the actions can be done by both.
You should choose based on your organization and the business requirements taking a valid decision in terms of the quality and price.
Cloud Data Integration