Azure Data Factory vs Informatica MDM

If you are just getting started and all your data is resident in the Azure cloud, then Azure Data Factory is likely to work fine without having to jump through too many hoops. However, in a hybrid environment (which is most of them these days), ADF will likely need a leg up. It works well for scheduling and basic scheduling/orchestration tasks, but the feature set is not at a level with SSIS (which has been around for 15 years so...). As ADF now supports deploying SSIS, it is also a good candidate if large amounts of your data are resident in the Azure cloud and you have an existing SSIS investment in code and licensing. We are using it in a hybrid fashion for the data warehouse and will slowly transition over to ADF as the feature set improves. We are also using it for cloud-native applications that only require supplemental data from on-prem resources

If your environment is clean and well organized, but at the same time has many application domains with their own data sources, Informatica MDM can be a really good factor in maintaining "single points of truth" for all this data. However, the more application domains you have, the less "clean" your environment becomes. If your application domain landscape consists of multiple technologies (C#, Oracle, JAVA, web-based, windows services, console apps, third-party tools, etc), your environment becomes a real nightmare to maintain unless you implement a service-oriented approach. And this is where Informatica MDM fails completely since it promotes a "point to point" scenario. At least this is my experience. It could be that Informatica MDM supports a service-oriented approach, but I have not seen this. I could be that the developers in my organization who have expert Informatica MDM knowledge are just more "point to point" oriented. But even if that is the case, it's a valid argument against Informatica MDM, since it's already hard enough to find developers who are dedicated to this product, it becomes impossible to find SOA oriented developers.

We have not had need to engage with Microsoft much on Azure Data Factory, but they have been responsive and helpful when needed. This being said, we have not had a major emergency or outage requiring their intervention. The score of seven is a representation that they have done well for now, but have not proved out their support for a significant issue

I'm not sure since I never used support. My colleagues never had any issues with it, therefore my rating would be an 8 with a certain range of uncertainty.