Coming October 25: PeerSpot Awards will be announced! Learn more

Informatica Cloud Data Integration vs Informatica PowerCenter comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary
Updated on May 3, 2022

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.

  • Ease of Deployment: For the most part, Informatica Cloud Data and Informatica PowerCenter users tell us the overall setup of both solutions is straightforward and simple. Some users with more complex architectures do feel that Informatica PowerCenter can be challenging to set up and may even require additional technical support to complete correctly.
  • Features: Informatica Cloud Data Integration users feel the mass ingestion functionality and the elasticity of the solution are great. Users tell us the licensing is very flexible. Valued features of the solution include the data quality, data masking, master data management, and API management. Some users feel there can be a steep learning curve with Informatica Cloud Integration. Users would like to see more regions added, as some of the current regions where data reside may be problematic.

    Informatica Powercenter users tell us the solution is very good for integrating a huge amount of data in a very short period of time. Once users provide the source and the target, mappings are automatically done, which makes it easy to use for the development team. Users especially like the enterprise-scale ETL solution; it is robust, very stable, and easy to scale. The solution integrates and connects seamlessly with multiple new systems, both structured and semi-structured. Users would like to see the solution modernized, as it seems to them a bit dated. It also should handle more modern formats, such as JSON.
  • Pricing: Users feel both solutions are expensive.
  • Service and Support: Overall, users are satisfied and feel the support they get for both products is timely, knowledgeable, and helpful. Informatica PowerCenter offers tiered support, which can make the problem-solving process even faster.

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.

To learn more, read our detailed Informatica Cloud Data Integration vs. Informatica PowerCenter report (Updated: August 2022).
635,513 professionals have used our research since 2012.
Q&A Highlights
Question: Which Informatica product would you choose - PowerCenter or Cloud Data Integration?
Answer: Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a real data governance strategy. Additionally, PowerCenter is able to manage huge quantities of data with a high level of reliability. We also like the metadata repository and the data warehouse application console. We would like to see the licensing improved, though. We would like to see a feature-wise option as opposed to the current bundle option. PowerCenter is a very expensive solution. The numerous levels of transformation and multiple interfaces can make it a very confusing solution to learn. Cloud Data Integration offers great options for data cleansing, data mastering, data masking, master data management, and API management. The UI is very easy to use and the setup is straightforward. The new licensing is very flexible. Cloud Data Integration has inbuilt tools that allow for a lot of data transformation without changing any SQL queries from the code. This is one of our favorite features. We would point out, though, that there are some limitations with performance using Cloud Data Integration. We experienced some connectivity issues, making things run a bit slow. There are some issues with data residency laws in some countries. More regions should be added. Finally, it would behoove Cloud DataIntegration to consider adding more data sources. Conclusion: These are two great solutions under Informatica Brand which is synonymous with quality, reliability, and price. (Very high price.) Cloud Data is best suited for small to medium organizations and is somewhat limited in the regions it can be used. PowerCenter is most applicable for large enterprises that can more easily absorb the cost and best utilize everything PowerCenter has to offer with their current bundle licensing tier.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"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 mass ingestion functionality and the elasticity of the solution are great.""It has all the advantages of the Cloud in that you can use it without worrying about infrastructure, upkeep, or upgrades.""The product is scalable and excellent for enterprise-level organizations.""We have a lot of integrations, and it's very easy to create integrations. They have a lot of connectors.""It has a more UI-based tool, and the scripting is good.""Informatica Cloud Data Integration is stable.""The solution's initial setup is quite straightforward."

More Informatica Cloud Data Integration Pros →

"The technical support for Informatica PowerCenter is good.""Deployment was simple and straightforward.""The interface is very clean and clear.""Can manage a huge quantity of data and provide reliability.""The solution is stable.""If the systems get migrated or upgraded, the amount of resources required are very minimal. We can change the connections and establish a new connection. It's very helpful.""Once you have learned Informatica, it is very easy to use.""One of the most valuable features for us is the metadata repository because it can easily understand the lineage of first target mapping. My company and I also find Informatica really easy to use—when a consultant joins our company, in just a few days to a few weeks, they can understand how to use it—so we prefer to use this ETL tool."

More Informatica PowerCenter Pros →

Cons
"The price modeling could be more flexible.""There may be some types of limitations with the performance.""Informatica Cloud Data Integration could improve the price by making it less expensive.""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 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.""The current features are a bit complicated, and we need to write big scripts and test.""Its pricing model can be improved. The response time from technical support can also be improved.""I have received feedback from certain teams and there is a steep learning curve to use this solution."

More Informatica Cloud Data Integration Cons →

"In terms of performance improvement and tuning, there should be a bit more guidance and documentation.""I would like to see it be able to import data from NoSQL.""I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases.""The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement.""In the future, I would like to see Informatica PowerCenter integrate a more powerful dashboard.""There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce.""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.""An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."

More Informatica PowerCenter Cons →

Pricing and Cost Advice
  • "Our customers sometimes are able to negotiate a much better price for Informatica Cloud Data Integration based on their relationship with the vendor."
  • "Its pricing model can be improved."
  • "I'm not sure about the most recent pricing trends, but I don't believe it's significantly different from PowerCenter. I believe it is nearly the same."
  • "The price of Informatica Cloud Data Integration could be reduced."
  • More Informatica Cloud Data Integration Pricing and Cost Advice →

  • "We are satisfied with the pricing."
  • "I consider this to be an expensive product."
  • "It is for big enterprises. We have leveraged Informatica for big enterprises but not for small and medium enterprises because it is a very costly product as compared to other products. We propose this solution only for enterprise customers. For small to medium enterprises, we would propose the Microsoft solution. Its licensing is currently bundle-wise. It should be features-wise and not bundle-wise."
  • "The price of this solution is high."
  • "Our client has purchased the license, and we are using it."
  • "The solution is in the middle price range compared to other solutions."
  • "Licensing costs are excessive and pose an obstacle to someone who lacks familiarity with the solution and wishes to have a proper understanding of it."
  • "Our customers pay a licensing fee yearly."
  • More Informatica PowerCenter Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
    635,513 professionals have used our research since 2012.
    Answers from the Community
    Netanya Carmi
    AmanyEldaly - PeerSpot reviewerAmanyEldaly
    Real User

    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. 

    Rob Carney - PeerSpot reviewerRob Carney
    User

    Cloud Data Integration

    Questions from the Community
    Top Answer:Azure Data Factory is a solid product offering many transformation functions; It has pre-load and post-load transformations, allowing users to apply transformations either in code by using Power… more »
    Top Answer:Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a real data governance strategy. Additionally, PowerCenter is able to manage huge… more »
    Top Answer:It has a more UI-based tool, and the scripting is good.
    Top Answer:Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability and reliability I am looking for, good scalability, and is easy to set up and… more »
    Top Answer:SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free… more »
    Top Answer:The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness.
    Ranking
    4th
    Views
    16,075
    Comparisons
    13,024
    Reviews
    9
    Average Words per Review
    389
    Rating
    8.0
    2nd
    Views
    35,496
    Comparisons
    30,214
    Reviews
    35
    Average Words per Review
    436
    Rating
    7.9
    Comparisons
    Also Known As
    PowerCenter
    Learn More
    Overview
    Informatica Cloud Data Integration is a unified and modern user experience across all iPaaS patterns, supported by a meta-data driven, modular, artificial intelligence-based microservices architecture tailored for IT, developers, and business users. It help delivers accessible, trusted, and secure data to facilitate more valuable business decisions and identify competitive advantages. Informatica Cloud Data Integration can help to distribute data warehouse and analytics projects. Features include the following: Deliver integrated and relevant data, Scale with data synchronization and replication, Integrate asset management, Support high-volume workloads, Design cloud mappings and Execute visual data integration flows.

    Enterprise data integration platform to help organizations access, transform, and integrate data from a variety of systems.

    Offer
    Learn more about Informatica Cloud Data Integration
    Learn more about Informatica PowerCenter
    Sample Customers
    Chicago Cubs, Telegraph Media Group
    University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
    Top Industries
    REVIEWERS
    Computer Software Company47%
    Pharma/Biotech Company13%
    Individual & Family Service7%
    Manufacturing Company7%
    VISITORS READING REVIEWS
    Computer Software Company20%
    Financial Services Firm12%
    Energy/Utilities Company8%
    Insurance Company8%
    REVIEWERS
    Computer Software Company27%
    Financial Services Firm16%
    Manufacturing Company9%
    Retailer9%
    VISITORS READING REVIEWS
    Computer Software Company19%
    Financial Services Firm13%
    Comms Service Provider8%
    Insurance Company8%
    Company Size
    REVIEWERS
    Small Business21%
    Midsize Enterprise25%
    Large Enterprise54%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise11%
    Large Enterprise75%
    REVIEWERS
    Small Business17%
    Midsize Enterprise12%
    Large Enterprise71%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise11%
    Large Enterprise75%
    Buyer's Guide
    Informatica Cloud Data Integration vs. Informatica PowerCenter
    August 2022
    Find out what your peers are saying about Informatica Cloud Data Integration vs. Informatica PowerCenter and other solutions. Updated: August 2022.
    635,513 professionals have used our research since 2012.

    Informatica Cloud Data Integration is ranked 4th in Cloud Data Integration with 10 reviews while Informatica PowerCenter is ranked 2nd in Data Integration Tools with 35 reviews. Informatica Cloud Data Integration is rated 8.0, while Informatica PowerCenter is rated 7.8. The top reviewer of Informatica Cloud Data Integration writes "A UI-based tool with great scripting ". On the other hand, the top reviewer of Informatica PowerCenter writes "A stable, scalable, and mature solution for complex transformations and data integration". Informatica Cloud Data Integration is most compared with Azure Data Factory, AWS Glue, Mule Anypoint Platform, Matillion ETL and SSIS, whereas Informatica PowerCenter is most compared with Azure Data Factory, SSIS, AWS Glue, Informatica PowerExchange and Oracle Data Integrator (ODI). See our Informatica Cloud Data Integration vs. Informatica PowerCenter report.

    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.