Make vs. Informatica Intelligent Data Management Cloud

Integrating your CRM with Marketing Applications for data transmission and unity, GDPR compliance, syncing. Build a scenario for each specific (language or location) action. Managing certain actions and triggers based on links, some of the workflow solutions were not present in marketing tools and we need to create more complex process in Make to meet our needs. Lead and contact tracking from Social Media, updating our inventory based on user actions.

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 ability to integrate with any API
• The drag and the drop builder makes the process of automating tasks easier
• Rich library of the most used apps

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

• Better navigational capabilities from scenarios
• Better use of AI or prompting for complex things like iterators/aggregators
• A "test mode" so that you don't have a ton of runs that are invalid or to be able to populate dummy data without wasting unnecessary operations to create it.

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

At this point, it is firmly embedded in the DNA of the business and to give up the ability to automate workflows and create integrations on the fly would be a terrible idea.

I think it is the easiest workflow tool that I have ever used. Drag and drop works perfectly, helping less computer friendly users to simplify and nest their workflows. Managers without IT experience are now dealing separately with most of issues on their own. Handover of tasks and workflows is also easier as it is possible to comment and explain everything inside one.

The pricing schema is very attractive, almost 50% lower than the competition. You could start from free and then grow. It has a pretty big library of connections to other apps and services, which really helps you when everything is a mess. Integromat has a really easy-to-use interface. You could do almost everything with fewer than 5 clicks. Scenarios (automation steps to complete a routine) have graphics so you can configure them more easily.

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

Integromat allows us to do everything we used to do on Zapier but it doesn't limit us to only the popular apps, with Integromat we're integrating custom APIs and we get data from different servers through GET requests and it's exactly what we needed and Zapier couldn't provide it.

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

• Enabled us to solve use cases for hundreds of clients and hundreds of different platforms
• Provided the customization capabilities to automate accounting/invoicing processes that save dozens of man-hours a month
• Allowed us to build custom churn/retention/engagement scores that have driven a 20% reduction in churn

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