Celigo vs. Informatica Intelligent Data Management Cloud

Celigo is great for transaction-based integrations (which is most), but not great for when you want to replicate data from one system to a database. For example, if you are trying to get all of your NetSuite data into a Snowflake database. However, if you are trying to get data out of NetSuite and create transactions in another system, it's perfect.

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

• Error Management is better than anything you can build on your own
• Celigo makes visibility of your data between platforms very nice
• Broad Capabilities. Anything with an API can be connected.

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

• EDI transactions are difficult to setup and use
• FTP transactions can be slow when using them for a lot of volume

• 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

There is a bit of a learning curve, but not bad. Once you get a flow or two under your belt, there will be no stopping you. You will start to see possibilities and ways to apply automation and integration throughout your business. It becomes fun to look for additional ways to save money, time, and improve accuracy

Incentivized

Had some rough patches in the beginning, but they were resolved.

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

We demoed some of these other integration options. The learning curve seemed a bit steeper and the offerings less robust, so we did not pursue very far. I cannot speak to the others much. We have not had a reason to stray from Celigo.

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

• Quickly Sync Sales Order from Shopify to NetSuite
• Sync back order fulfillments from NetSuite to Shopify
• Import order from Amazon Seller Central to NetSuite
• Sync customer information from Shopfiy to Saleforce

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