April 28, 2020
Score 3 out of 10
Read this authenticated review
Pros and Cons
- It has exceptional functionality for customizing and combining data, like filtering and unifying. This is important if multiple sources can contain data from single customers.
- It has a very advanced flow editor where you can add logic and rules in a clean flow-like environment.
- It can connect to almost any datasource, with unlimited scheduling options.
- As far as I can see it exclusively uses the concept of "point to point" connectivity for fetching data. What this means is that Informatica MDM must have "knowledge" of all other systems, and keeps a direct connection to these systems. This is bad practice in environments that would benefit more from a microservice architecture. In those cases, it's especially bad, because not only does this break the SOA architecture, but it also "promotes" the idea of "point to point" connections among developers. The "point to point" mentality is the single most important danger to any SOA environment.
- It's very hard to use! The learning curve is really steep. Also, it's really boring by design: having to open a large application, learning all of its intricate details, maintaining all connections and scheduled data load moments means you need developers that are seriously devoted to this application. This means those developers are kept from working in the field they know best and caused them to become developers in the first place, which is Oracle/Database developing. This makes it hard to find employees willing to perform this function.