What users are saying about

Azure Data Factory vs Informatica MDM

Azure Data Factory
46 Ratings
Informatica MDM
31 Ratings

Azure Data Factory

46 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.6 out of 100

Based on 46 reviews and ratings

Informatica MDM

31 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 7.9 out of 100

Based on 31 reviews and ratings

Feature Set Ratings

    Data Source Connection

    8.9

    Azure Data Factory

    89%

    Informatica MDM

    Feature Set Not Supported
    N/A
    Azure Data Factory ranks higher in 2/2 features
    Azure Data Factory ranks higher in 2/2 features

    Connect to traditional data sources

    9.1
    91%
    6 Ratings
    N/A
    0 Ratings

    Connecto to Big Data and NoSQL

    8.8
    88%
    6 Ratings
    N/A
    0 Ratings

    Data Transformations

    8.3

    Azure Data Factory

    83%

    Informatica MDM

    Feature Set Not Supported
    N/A
    Azure Data Factory ranks higher in 2/2 features
    Azure Data Factory ranks higher in 2/2 features

    Simple transformations

    8.9
    89%
    6 Ratings
    N/A
    0 Ratings

    Complex transformations

    7.7
    77%
    6 Ratings
    N/A
    0 Ratings

    Data Modeling

    8.8

    Azure Data Factory

    88%

    Informatica MDM

    Feature Set Not Supported
    N/A
    Azure Data Factory ranks higher in 6/6 features
    Azure Data Factory ranks higher in 6/6 features

    Data model creation

    9.3
    93%
    4 Ratings
    N/A
    0 Ratings

    Metadata management

    8.4
    84%
    5 Ratings
    N/A
    0 Ratings

    Business rules and workflow

    8.5
    85%
    6 Ratings
    N/A
    0 Ratings

    Collaboration

    9.2
    92%
    5 Ratings
    N/A
    0 Ratings

    Testing and debugging

    8.7
    87%
    6 Ratings
    N/A
    0 Ratings

    feature 1

    9.0
    90%
    2 Ratings
    N/A
    0 Ratings

    Data Governance

    8.1

    Azure Data Factory

    81%

    Informatica MDM

    Feature Set Not Supported
    N/A
    Azure Data Factory ranks higher in 2/2 features
    Azure Data Factory ranks higher in 2/2 features

    Integration with data quality tools

    8.1
    81%
    6 Ratings
    N/A
    0 Ratings

    Integration with MDM tools

    8.1
    81%
    6 Ratings
    N/A
    0 Ratings

    Attribute Ratings

    • Azure Data Factory is rated higher in 1 area: Likelihood to Recommend
    • Informatica MDM is rated higher in 1 area: Support Rating

    Likelihood to Recommend

    9.0

    Azure Data Factory

    90%
    6 Ratings
    7.8

    Informatica MDM

    78%
    4 Ratings

    Support Rating

    7.0

    Azure Data Factory

    70%
    2 Ratings
    8.0

    Informatica MDM

    80%
    1 Rating

    Likelihood to Recommend

    Azure Data Factory

    Suitable for virtually any scenario that involves working with linked Service, so that it is possible to connect Azure Data Factory to storage services for SQL data in the cloud, and that it is possible to access them at any time. Serves to make the information much cleaner and have the desired formats and structures in case of working with time tracking or general employee work tracking applications, so it is easy to create accurate and aesthetically acceptable analysis for general tracking software. It is extremely useful if you do not have any data server service, as Azure Data Factory has the ability to maintain almost 90 different data connectors without the need to use a server.

    Read full review

    Murray Clear | TrustRadius Reviewer
    Murray Clear
    View all 6 answers on this topic

    Informatica MDM

    Informatica MDM features have extreme power over large data extraction and its data integration functionality are effective and powerful data analytics tools and the overall data quality management using Informatica MDM is effective and profitable. The development project easy management and Applications performance monitoring with Informatica MDM is excellent.

    Read full review

    Veronica Derrick | TrustRadius Reviewer
    Veronica Derrick
    View all 4 answers on this topic

    Pros

    Azure Data Factory

    • Easy to set up and get started.
    • Runtimes make integration with on-prem data simple and also allow for support of existing investments in SSIS.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 6 answers on this topic

    Informatica MDM

    • Fuzzy matching in built features are excellent.
    • Data workflow creation process is smooth.
    • Creating child parent relation using UI is excellent.

    Read full review

    Mahadev Mohite | TrustRadius Reviewer
    Mahadev Mohite
    View all 4 answers on this topic

    Cons

    Azure Data Factory

    • Error Flagging, Details of the error code is not specific especially faced this during Azure Table load
    • Missing feature of Data exploration functionality similar to Synapse Data explorer
    • missing access to orchestrate/create stream analytics job

    Read full review

    Gorthy Rohith | TrustRadius Reviewer
    Gorthy Rohith
    View all 6 answers on this topic

    Informatica MDM

    • 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.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 4 answers on this topic

    Pricing Details

    Azure Data Factory

    General

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

    Starting Price

    —

    Informatica MDM

    General

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

    Starting Price

    —

    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

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 2 answers on this topic

    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.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 1 answers on this topic

    Alternatives Considered

    Azure Data Factory

    The easy integration with other Microsoft software as well as high processing speed, very flexible cost, and high level of security of Microsoft Azure products and services stack up against other similar products.

    Read full review

    Niloofar Keshvari Nia | TrustRadius Reviewer
    Niloofar Keshvari Nia
    View all 6 answers on this topic

    Informatica MDM

    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

    Read full review

    Brian Randolph | TrustRadius Reviewer
    Brian Randolph
    View all 4 answers on this topic

    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

    Read full review

    Marco Urrea | TrustRadius Reviewer
    Marco Urrea
    View all 6 answers on this topic

    Informatica MDM

    • Easy pulling many project data across other data management solutions through the entire infrastructure.
    • Useful and powerful software for data mining and its capability for real-time data analytics production is effective.
    • Informatica MDM tools are reliable like its reporting features and the data security offered is amazing.

    Read full review

    Veronica Derrick | TrustRadius Reviewer
    Veronica Derrick
    View all 4 answers on this topic

    Add comparison