We performed a comparison between Informatica PowerCenter, SAS Access, and Zapier based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."Can manage a huge quantity of data and provide reliability."
"It has good standard features for ETL development."
"The number of docs has been reduced drastically, which is very good."
"The setup is straightforward."
"I found the map links, work links, and workflows valuable. They are important features."
"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."
"Technical support, and their approach is good. They have a support portal and support tickets. If you open a ticket it has multiple levels of severity from level one to very high or critical."
"Has a good visual tool for data mapping."
"The most valuable part of SAS/ACCESS is what it is made for: connecting to remote systems that are not part of your physical SAS environment."
"The most valuable aspect of the solution is the ease of access to the data in those databases."
"The most valuable feature is you have native access to the external databases."
"The most valuable feature of Zapier is it saves me time doing repetitive tasks."
"The product's most valuable feature is automation."
"With the previous CRM we were using – the Google Ads landing pages we had – we were collecting leads manually. That process was not efficient and took a sales team a lot of time to insert these leads manually. Currently, the process is smooth and we use Zapier to collect the leads for us."
"The product's initial setup phase was very easy."
"The solution is a SaaS and does not require a complex setup."
"We can connect Zapier with Zoho CRM for lead generation. I like the tool's drag and drop feature."
"There are a few valuable features, like the stability that it comes with and also the number of features that it offers. I've used other services like Pabbly, but they don't offer similar numbers of applications that Zapier has or allows to integrate with – it's maximum."
"Zapier handles everything under the sun that you would think you need in automation. It is the most mature integration platform and service on the market."
"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."
"Now they are migrating to a new version, and they have something that is called Informatica Developer. Previously, they just had PowerCenter. Now, when they move everything to Informatica Developer it's not as good or stable like it was when it was PowerCenter, though it has some nice features. This Developer tool could be better."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"The performance of Informatica PowerCenter could improve."
"The reputation of Informatica is that it is expensive."
"PowerCenter could integrate better with cloud applications. We had to do a lot of configuration work using API integrations to connect with cloud applications. Informatica Cloud Data Integration has a generic connector that you can use directly, so it's much easier."
"What I didn't like about it is that the platform itself is not great at distributed processing. When you need high parallel processing, it has some inherent issues. We had to use Java transformation, and it did not go very well. I have heard that it is going to the cloud, but we haven't tried that."
"In the future, I would like to see Informatica PowerCenter integrate a more powerful dashboard."
"The pricing model needs to be reconsidered and adjusted."
"I can't really recall any missing feature or general improvement that is needed. We don't really add too many new kinds of databases and therefore our needs are already met."
"The solution can provide access to the newer databases that come out sooner."
"It is not worth the money if you have a little bit of a technical mind...Zapier is not able to set up different modules. When automation doesn't work, it's not that easy to find why it didn't work."
"Zapier needs more YouTube or video tutorials or more training for people. That would help a lot. In particular, Zapier should have documentation for every connector. Its documentation needs to be more detailed and visual."
"The pricing of the solution is quite expensive."
"I think that this solution should have more apps connected to it."
"After mapping them out, and they'd worked for a while, I've had Zapier fail."
"At the moment, they allow a limited number of apps. I look forward to getting more apps for each package."
"There is room for improvement in the support. They are not responsive, and they don't take much time to get resolved."
"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."