Great data quality tools and any issues are easily identified
Pros and Cons
"MDM doesn't require a separate IDQ."
"The solution doesn't directly connect to any of the analytical tools."
What is our primary use case?
Primary use case is generally for product items and demonstration.
What is most valuable?
I like that Informatica MDM doesn't require a separate IDQ. In the IBM InfoSphere, we need exclusive data quality to identify the issues in the source system. But if you use Informatica MDM, that's not the case. The MDM itself identifies the issues and we can use the data quality tools and the score card. It's good compared to other tools. Troubleshooting is very easy and I believe performance is better than any other tool. It solves any complex queries you can connect, any complex route, any complex mappings, you can do it all with Informatica MDM.
What needs improvement?
I'd like the ability to directly connect from MDM to any of the analytical tools. It's a feature that would be very helpful for analytical reporting. When you connect to the cloud, there are multi-cloud technologies that will have some problem and when you connect from on-prem to cloud, there are more data latency issues than with other tools. The product is more expensive than other similar solutions.
For how long have I used the solution?
I have six years of experience with Informatica.
What do I think about the stability of the solution?
It is a stable product compared to other MDM products. Other solutions like Oracle CLM and CDH are similar tools but they're not great when compared to Informatica MDM. Of course, it is very stable compared to any other MDM products.
What do I think about the scalability of the solution?
The solution is scalable but when you do the design, you have to know what the data load will be and the number of concurrent users. Based on that you have to design the infrastructure and measure capacity.
How was the initial setup?
I've implemented this solution in three or four different projects.
What other advice do I have?
I rate this solution a nine out of 10.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner