Likelihood to Recommend Informatica Cloud is a great tool for use when data must be formatted consistently. Once configured, it is very robust and reliable. It is also well-suited for an organization without a robust IT staff to maintain a full server infrastructure. It offers a cost-effective approach to high-quality data integration for even the largest organizations. Organizations without staff experienced in data analytics may find it challenging to take advantage of the more complex results of this tool.
Read full review Zapier is perfect for simple integrations and setting up generally low-volume accounts that require very little configuration and maintenance. For a distributed structure where a client/outside party is responsible for billing, it’s easy to create an account, put them on a low-cost plan, configure a simple integration and teach them how to alter the setup. Its webhook-based setup is perfect for many simple use cases and there’s no reason to use a more complex or expensive solution.
However, if you have integrations that are increasingly complex (involve parsing, multiple non-linear steps, the integration of non-native APIs), significant in overall volume/data or require additional features (time delays for API limits), Zapier likely isn’t your best choice. Other integration platforms offer higher levels of customization and capability, though they’re typically significantly more complex and expensive.
Read full review Pros Once the secure connection is established it’s quite easy to operate and create new jobs. The controls are simple, and we appreciate the fact there are not a lot of complex fine-tunings required. Navigation is also easy, and we enjoy the ability to open multiple tabs in the browser to work on multiple projects. The monitoring functionality works well to help track the progress of the jobs, again, without too much complication. In a fast dev environment, speed is essential and we quickly seeing the status/progress of jobs as well as any errors if the jobs fail helps us maintain speed. The web interface is a lot easier to interact with than the client/on-prem version. Putting much of the heavy lifting of interacting with the tool onto the shoulders of the browser makes it easier to keep multiple sessions open and get in/out quickly without having to VPN into the office. Read full review Ease of use - multiple people in the organization can set up and run Zaps per their specific use cases without much training. Connectivity - Zapier is able to connect to multiple applications we use on a regular basis. Functionality - Zapier provides embedded functionality within the app itself (email, data conversion), but also appropriate triggers and actions for apps it connects to. Versatile - Zapier can execute complicated and simple tasks and thus has many use cases. Read full review Cons The User Interface can be a bit difficult to get in initial stages. Error messages are hard to understand which sometimes takes a lot of time for the resolution Cannot Implement complex SQL queries which should be fixed in future release. Read full review Being able to turn off one leg of a Zap without having to delete it or turn the whole Zap off Not all fields populate when using certain aspects of Salesforce, but that could be an SF issue Communication when support is actually needed basically doesn't happen Read full review Likelihood to Renew Zapier is now very much an integral part of our business and we could not operate without it!
Read full review Usability Zapier is very user-friendly. They walk you through each step of the zap-building process in an orderly and easy to understand way. Each step of the zap is tested before moving onto the next step. For simple zaps, you can have them up and running within minutes. For more complicated zaps, it may take some experimentation, but Zapier is there to help you troubleshoot.
Read full review Support Rating I've never had trouble getting into contact with Informatica's support for technical help. I give it a nine because it does pretty well for mid to enterprise-scale workflows.
Read full review Before we purchased Zapier, I contacted support and asked them if Zapier could support my intended workflow (this is actually a selection on their support form - awesome). Within 2 hours, I was contacted by a support team member who seemed sure it would work, but granted me premium access for 2 weeks to try it out for myself. Sure enough, it did! Ever since then, support has replied rapidly to any problems I have experienced and answered my questions within a few sentences.
Read full review Alternatives Considered First, the wizard is easy to use making the learning curve for simple ETL tasks nice. Second, since Informatica is mature there are a good variety of connectors available. Finally, we have driven some fairly complex ETL solutions using only the cloud.
Read full review Zapier is a much more mature platform with much more software that you can integrate into and they add to their portfolio every month Zapier has more functions for each software they connect Zapier has their own services that are very useful They have so many existing work flows that you can easily add Read full review Return on Investment Cut costs on the number of staff we need for data import. Cut costs for automation that can be done for data that no longer has to be manually imported. We've saved countless dollars by eliminating duplicates in our system with this tool. Read full review It saves us hours of time every week being able to connect services automatically. It enables automations to happen that would not otherwise be possible at all. It allows us to choose other software for specific purposes without the limitations of only the built-in connectivity. Read full review ScreenShots