Informatica Intelligent Data Management Cloud vs. Salesforce Data Cloud

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

Being a mid sized organization, the costing is achievable, but can’t say for those of startups. So I believe not suitable for small scale organizations and very well suited for large data analytics companies to gain market. Also, the maintenance is slightly difficulty and support for the product is comparatively slower than other similar products.

• 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

• Analysing customer trends
• Detailing information to gain market
• Reporting and analytics
• Improved security
• Providing data analytical tools and less scope of error

• 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

• Very expensive
• Does not integrate with HubSpot (another CRM). We have tried many times and it does not seem to connect
• Sometimes the website will load very slow where other websites are much quicker

Incentivized

it is easy to use after you get the hang of it. If you have an internal team of developers you will be able to maximise the usage a lot better. I would recommend it to people who need to organise data in a more unified way but I can’t speak to it from an infrastructure perspective as I’m not from the infrastructure team

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

I like Salesforce Data Cloud because like mentioned before, it is easy to use, easy to generate reports, create workflows, keep track of customer data, sales data, house data, etc. You can also import excel sheets with customer data as well and it will create the fields for you which is nice

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

• Salesforce Data Cloud has a positive impact on me as a realtor because it is easy to generate reports on customer data and see what is needed to be bumped to the next level. We have to earn a certain commission by the end of the year and it makes it easy to see how close you are
• It has a positive impact on keeping track of customers because it is nice to have it all in one place which is a nice time saver
• I like that you can even see customer info from other agents making it nice to compare and try and pass others
• Makes the customers journey smooth sailing because everything is in one place

Incentivized