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.
"Informatica Cloud Data Integration is stable."
"Replication allows us to fully replicate all objects from Shop Floor Data Collection (SFDC) to in-house/on-premises database in one job."
"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."
"It is quite easy to use and flexible."
"The serverless capability and the packaging application of the solution are valuable."
"Informatica is good for integrating data and cloud applications. We have connectors for integrating cloud applications like Salesforce. You can quickly integrate anything with an exposed API or a REST API. The industry is increasingly shifting to the cloud, so we need more products that can connect to cloud-based applications. The integration is seamless and works in real time. It's also secure because you don't need to expose databases or tables."
"We have a lot of integrations, and it's very easy to create integrations. They have a lot of connectors."
"Data integration is the most valuable feature. The ability to connect to any of the sources and enterprise applications makes our lives easier."
"The interface is very clean and clear."
"It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years."
"What I like the most is that we have to deal with less while writing the queries."
"The product's initial setup phase is very easy."
"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."
"The ability to scale through partitions helped us to improve the performance."
"The technical support for Informatica PowerCenter is good."
"There are a small number of UI bugs that occur on occasion."
"I would like to see support for more data sources."
"There may be some types of limitations with the performance."
"Certain shortcomings in the product's UI make it an area where improvements are required."
"Connectivity could be improved, it can be a little slow."
"User/group administration could use improvement."
"While my company operates on the cloud, we have seen that Informatica Cloud Data Integration has some performance issues causing it to lag."
"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."
"Its interface can be modernized. It is an old product. I have been working with it for 14 years, and it still looks the same. It hasn't been modernized much. It also needs to handle more modern formats, such as JSON files. It works with the old text files and databases, but it does not always work with the newer, modern stuff. You need to make your own programs to support that kind of stuff. Support is also a kind of difficult with Informatica. They don't do direct support and rely on using their distributors around the globe for support, which means that you kind of have to go through this layer of different companies before you get help."
"I would like to see it be able to import data from NoSQL."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"It would be better if I could do all the work within a single window. If I'm working on any mapping and if I have to switch to sessions, I have to open a new window altogether. If I have to get into workflows, I have to open a new window. It was also very expensive. In the next release, I would like it to be more user-friendly."
"The developer tool documentation can be enhanced with a more clear explanation of each utility, accompanied by relevant examples, so that developers are able to create programs with ease."
"I found it is kind of weird that not all of the mapping changes are treated as true changes."
"The solution can improve by providing more connectivity by having native ODBC or JDBC connections available. It will be easier and more people could start using it."
"It should be more cloud-centric than on-prem-centric."
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, Mule Anypoint Platform and Matillion ETL, 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