Informatica Intelligent Data Management Cloud vs. Pabbly

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

I feel like Pabbly is helpful for many businesses, espeically those who have to connect google sheets for automations, for various calendar automations, or connect to email applications if this isn't native to your software. If you are heavy wordpress user than this is very helpful as well. You don't need this tool unless you need to connect various software together

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

• Connect software applications that are not already integrated or connected
• Automate processes within a single software
• Transform data and then using that data across different software applications

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

• The trigger action needs improvement
• The method of connecting different software also needs to be simplified
• The actions for some software applications need to have more capability (things that can be done between different software)

Incentivized

I really enjoy using Pabbly, it is fast, pretty simple, has lot of connections and support has been fairly helpful. I would give it just a higher rating if it came with a faster live chat and more templates for non techies like myself but overall has been reliable, usable with no bugs, and helpful to connect tasks especially any google sheet/doc/form etc task

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

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

Most platforms do one thing well so you are limited to that one thing. And then those platforms add some functionality later, plus most systems don't have native integration between other systems. From our experience, Pabbly Plus was birthed by connecting different platforms/software so it works well in that regard. It is also easier than most systems as most other platforms charge a premium for integration systems, where as Pabbly doesn't.

Incentivized

• 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

• Saved us thousands of dollars in manual labor costs
• Made us more profitable due to automating our marketing effort
• Allowed us to meet with more prospects by reducing our effort
• Made us more intelligent by capturing important information that we were not able to capture

Incentivized