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.
Find out what your peers are saying about Informatica Intelligent Data Management Cloud (IDMC) vs. Informatica PowerCenter and other solutions. Updated: November 2024.
Informatica PowerCenter and Informatica Intelligent Data Management Cloud compete in data integration and management. IDMC appears to have the upper hand due to its adaptability and innovation in a cloud environment.Features: PowerCenter provides robust ETL capabilities, customization options for on-premises deployments, and support for a wide range of data sources. IDMC includes machine learning, data governance tools, and offers enhanced scalability with automated data integration...
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.
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
@Rob Carney can you please explain why?