We performed a comparison between Informatica Cloud Data Integration, Informatica PowerCenter, and Zapier based on real PeerSpot user reviews.
Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration."The solution's initial setup is quite straightforward."
"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."
"The product is scalable and excellent for enterprise-level organizations."
"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."
"The Mapping Designer allows for declarative ETL development (visual scripting) that leverages a wide array of different transformations."
"It is quite easy to use and flexible."
"I do a quite a lot of data transformations, and the fact that I can do them without changing any of my SQL queries from the code, using the inbuilt tools, is very helpful."
"It reduces a lot of legacy coding."
"In the end, you have structured, proper data for use in an integrated BI solution."
"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."
"Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology."
"The product's initial setup phase is very easy."
"Once you figure it out, it is a powerful and simple ETL tool. Its stability has been very satisfactory."
"Technical support is great. It's one of the reasons we really like them. When you compare support from IBM and support from Informatica, Informatica is much better."
"The most valuable feature of Zapier is it saves me time doing repetitive tasks."
"Zapier is user friendly and makes it easy to integrate different tools. It has a drag and drop functionality which makes it easy to connect environments."
"We find it effortless to set up. We really don't have to do anything other than finding the application in the Zapier catalog. And as long as the application has been re-integrated into Zapier, they're able to then just provide the connection details and hook it up."
"The ability to connect web applications to trigger actions in another app after having enriched, formatted, delayed, grouped, and filtered is really valuable for many businesses."
"Zapier's interface, for me, is the solution's greatest value proposition. It is designed and developed for people who don't have a clue about what they're trying to do. It has a very user-friendly interface."
"The most valuable aspect of this solution is that it is very intuitive and has a very flat learning curve."
"The solution is a SaaS and does not require a complex setup."
"The product's initial setup phase was very easy."
"Cost-wise, it could be better."
"It could be improved by including a buffer that saves data when there is a connectivity issue."
"Its pricing model can be improved. The response time from technical support can also be improved."
"The vendor should have more training resources: online classes, free tutorial videos, etc."
"The main issue preventing Brazilian companies from migrating to Informatica Cloud Data Integration from on-prem is the price."
"There is room for improvement at the highest level in terms of useability and connectors for various types of new applications. The row processing performance could be better because you experience some latency dealing with high volumes of data. Most organizations will be dealing with multiple cloud applications, so you could see performance issues moving from one system to another."
"I would also like to have profiling functionalities and quality transformations in the cloud."
"Connectivity could be improved, it can be a little slow."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"Lacks ability to calculate cost of the product."
"It should be more cloud-centric than on-prem-centric."
"Compared to solutions offering similar functionalities, Informatica PowerCenter is not very flexible regarding customized integrations."
"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."
"While Informatica is great for data-integration, it does not have any analytics features. Thus, organizations have to always look for another product for their BI needs."
"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."
"The licensing is difficult."
"The pricing of the solution is quite expensive."
"System-to-system is fine, but when it comes to system-to-user, where Zapier is helping to communicate to a user, that's a one-way communication. If that user has to perform some action on that notification, the action isn't handled by Zapier. So there's no way to orchestrate that and it's very cumbersome."
"The user interface for Zapier could be improved. It also takes some time to sync the data between different environments."
"After mapping them out, and they'd worked for a while, I've had Zapier fail."
"Some apps are not available yet. For instance, a connection with Joomla! would be great. In general, all the most-used apps are available, but I bumped into Joomla! with a client."
"I think that this solution should have more apps connected to it."
"I would like to see them improve the Quickbase integration. Currently, it only allows triggering actions when records are added, but it would be more useful if we could also trigger actions when records are modified or deleted."
"Some recent changes to the solution have made it bulky and not as intuitive to use as it previously was."
More Informatica Cloud Data Integration Pricing and Cost Advice →