Informatica Intelligent Data Management Cloud vs. Zapier

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.

Incentivized

If you have processes that are now managed and controlled using a spreadsheet, Zapier will give you a lot more control over what is happening and will help you increase productivity by eliminating simple steps such as sending emails and sharing information with your colleagues. It frees time for very transactional activities.

Incentivized

• 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.

Incentivized

• 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.

Incentivized

• 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.

Incentivized

• 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

Incentivized

Zapier is now very much an integral part of our business and we could not operate without it!

Incentivized

The interface is very user-friendly, and there are also many tools to help a brand-new user get started. For example, you can put your Zap idea into the AI bot, and it will basically build a shell of your Zap to get started on. The format for each step within a Zap is also very helpful (set up the connection/app, set up the fields/details, then test).

Incentivized

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.

Incentivized

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.

Incentivized

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.

Incentivized

We actually utilize both Integromat and Zapier at our company, for all the reasons detailed in this review. Though Zapier is excellent for simple client integrations, we often run into internal use cases that require complexity that Zapier cannot provide. Specifically working with API calls (not just webhooks), complex multi-step integrations with Routing/parsing/etc, and large volume integrations. Integromat is perfect for these use cases, but doesn’t provide the simplicity and account scalability that Zapier offers.

Incentivized

• 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.

Incentivized

• It has saved me the money in hiring an administrative assistant
• It also saved me the time it took to do these tasks
• It also allowed me to automate things that increased my lead generation
• It also allowed me to automate several processes

Incentivized