Overall Satisfaction with Informatica Master Data Management
Informatica MDM is used by our organization to synchronize data between our legacy customer relation management system and our new customer data management system, Salesforce, as we did our initial implementation of Salesforce. We sourced data from the legacy system, used the tool to identify the best version of the truth for our customers and to cleanse associated addresses. We then published the master data to Salesforce. We also used the tool to keep the systems in synch. When changes occurred in one system the data would flow into our master data management hub, and based on the trust and validation rules, the master data would be updated. All CRM systems were updated with the master data.
- Allows you to implement detailed business rules to apply to your data.
- Works well with any ETL tool, but especially well with Informatica PowerCenter.
- Provides a browser based interface to facilitate ease of use.
- Mapping within the tool can be difficult. But that is slated for upgrade with the next version.
- Many detailed screens for the developer interface. This makes it hard to find options sometimes.
- Address validation sometimes leads to incorrect results. This is my biggest issue with the product.
- Informatica MDM allowed for a faster standup of our Salesforce environment.
- Informatica MDM provided a means to keep our multiple source systems synchronized.
- Informatica MDM can be pricey but is definitely a leader in the space.
Informatica Cloud MDM was not available at the time of implementation. It has a direct connection with Salesforce, but as far as I can determine it is a solution that only addresses Salesforce and does not enable the sourcing of data from multiple external systems. Flat file support is lacking.