What users are saying about
12 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100
22 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 3.3 out of 100

Likelihood to Recommend

Azure Data Factory

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
Anonymous | TrustRadius Reviewer

Informatica MDM

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.
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

Azure Data Factory
8.4
Informatica MDM
Connect to traditional data sources
Azure Data Factory
8.2
Informatica MDM
Connecto to Big Data and NoSQL
Azure Data Factory
8.6
Informatica MDM

Data Transformations

Azure Data Factory
8.4
Informatica MDM
Simple transformations
Azure Data Factory
9.1
Informatica MDM
Complex transformations
Azure Data Factory
7.7
Informatica MDM

Data Modeling

Azure Data Factory
8.2
Informatica MDM
Data model creation
Azure Data Factory
9.0
Informatica MDM
Metadata management
Azure Data Factory
9.0
Informatica MDM
Business rules and workflow
Azure Data Factory
7.7
Informatica MDM
Collaboration
Azure Data Factory
9.0
Informatica MDM
Testing and debugging
Azure Data Factory
6.5
Informatica MDM

Data Governance

Azure Data Factory
7.7
Informatica MDM
Integration with data quality tools
Azure Data Factory
8.1
Informatica MDM
Integration with MDM tools
Azure Data Factory
7.2
Informatica MDM

Pros

Azure Data Factory

  • Cloud-based
  • Fast
  • Reliable
Marco Urrea | TrustRadius Reviewer

Informatica MDM

  • Gather data.
  • Manage data.
  • Present data to the user.
  • Correlate data.
  • Data manipulation.
Anonymous | TrustRadius Reviewer

Cons

Azure Data Factory

  • Limited source/sink (target) connectors depending on which area of Azure Data Factory you are using.
  • Does not yet have parity with SSIS as far as the transforms available.
Anonymous | TrustRadius Reviewer

Informatica MDM

  • 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.
Brian Randolph | TrustRadius Reviewer

Support Rating

Azure Data Factory

Azure Data Factory 7.0
Based on 2 answers
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
Anonymous | TrustRadius Reviewer

Informatica MDM

Informatica MDM 8.0
Based on 1 answer
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.
Anonymous | TrustRadius Reviewer

Alternatives Considered

Azure Data Factory

I'd chose data factory because its very easy to use, its UI is beautiful, it's library for .net is very useful and it lives within the microsoft ecosystem.
Marco Urrea | TrustRadius Reviewer

Informatica MDM

Less expensive then the competitors, modules are self-sustained and able to function directly. It involves less coding, and a lot of things can be done in house!
Anonymous | TrustRadius Reviewer

Return on Investment

Azure Data Factory

  • It is very useful and make things easier
  • Debugging can improve
  • Its better suited than other products with the same objective
Marco Urrea | TrustRadius Reviewer

Informatica MDM

  • 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.
Brian Randolph | TrustRadius Reviewer

Pricing Details

Azure Data Factory

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Informatica MDM

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Rating Summary

Likelihood to Recommend

Azure Data Factory
8.5
Informatica MDM
3.2

Support Rating

Azure Data Factory
7.0
Informatica MDM
8.0

Add comparison