Automate.io vs. Informatica Intelligent Data Management Cloud

Any information transfer between systems. They have a lot of different applications that integrate with their system, which saves a lot of tedious follow-ups.

Informatica Cloud is an excellent tool for freeing up trapped data in your internal systems and exporting it into a cloud data warehouse or SQL container. Especially if you have any internal SQL query generators that allow you to copy and paste into the Source setup. For example, we use Business Objects internally, and you can build out the query you need inside the firewall with that, then paste it into the query within Informatica Cloud while establishing the Source connection. This way you are not writing all your source parameters by hand, cutting new jobs setup time by 50%. Where Cloud will not suit you well is if you need significant visibility to the health of the system from a tracking, monitoring or error handling standpoint. Cloud will tell you it failed, maybe give you an example error, but has no further troubleshooting or diagnostic assistance to offer.

Incentivized

• The bot config process is really easy and intuitive
• Their Tech Support is really helpful
• It works with almost all the tools i actually use
• It doesnt give me errors
• It interaction with tools apis is really good

Incentivized

• Informatica Cloud is a great tool for automating data imports. Raw data files can be scheduled to run at designated times, and using pre-built mappings ensures that the data goes into the system accurately each time.
• It is also a great tool for converting raw data into specific formatting. For example, configuring the mapping so that the first letter of a first, middle or last name is always capitalized.
• Additionally, Informatica Cloud has a built-in field-matching tool so that records that already exist are updated rather than having duplicates created.

Incentivized

• Speed. Screens sometimes take a long time to load, and data lists occasionally load very slowly or not at all, requiring a refresh.

• 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

Excellent tool, offering excellent ROI.

It is brilliantly superb.

Amazing customer service! You can schedule a time to chat through the issue or use the chat. I've used each method once and both times they understood my issue and helped me resolve it. They were very thorough and persistent in determining the issue and fixing it. For example, July 1 on a Google Form was showing up as January 7 in Monday.com due to formatting conversions. After trying multiple versions to fix it myself, I couldn't get it corrected. Abhijeet from Automate fixed my bot to ensure the date was being reflected correctly in Monday.com and was patient enough to wait for me to test it several times. Customer service makes all the difference when you run into an issue and happy to report this crew rates an A+

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

Make sure the person managing it knows APIs and Databases, so they can 'understand' what Automate does and offers. Without such conceptual understanding, Automate is too geeky. WITH such conceptual understanding, Automate is a Church Picnic easy.

• Automate.io is way more friendly and easy to use
• Zapier is more expensive
• Way too many errors
• Zapier Api interaction is not the best

Incentivized

Having used SQL Server Integration Services (SSIS) in the past, Informatica Cloud was a huge-step up in functionality, usability and performance. Hands-down, Informatica Cloud is a much more robust product overall. While SSIS is well-suited for specific instances (i.e. SQL Server-specific implementations), Informatica Cloud is a much better product as an overall integration/transformation tool.

Incentivized

• Saves me 1-3 hours of work every single day.
• Automating data entry has allowed me to keep a great visual record of numbers and customers in Google Sheets instead of relying on checking individual orders on Shopify or individual emails, etc.

• A positive impact is bringing more projects.
• Getting data out of various systems such as Salesforce.com or FTP and consolidating it into tables in one central database.
• Having the ability to run data transformation tasks (the equivalent of batch jobs in SF or stored procedures in SQL) on a schedule without consuming those resources on the target or source systems.

Incentivized