We changed our name from IT Central Station: Here's why

How does Microsoft MDS (vs Informatica MDM) fit with Azure architecture?

Hi community,

I work as an Information Architect at a Government company with 5000+ employees.

I need a solution to manage client data across multiple systems:

  • 4000 users
  • 500,000 records
  • Federal Government regulatory agency

How does Microsoft Master Data Services (MDS) compare to Informatica MDM (or even Profisee) for integration with Azure?

Which of the solutions above will fit with Azure Data Lake Reference Architecture?

What about integration with Microsoft Dynamics CRM?

Thanks for your help!

    ITCS user
    11 Answer

    author avatar
    Top 5LeaderboardReal User

    Hi @Richard Tibbetts,

    There's no short answer to your question. Nearly all existing MDM solutions on the market offer a broad range of patterns to ingest master data from various sources and distribute cleanse and consolidated information, also to the Azure stack. Many vendors offer prebuilt connectors for the most common sources (databases, various file types, storages, business applications including MS Dynamics, Salesforce, etc.), but also support a generic way of ingesting/exposing data via Rest APIs, file drops, etc.

    MS MDS is an extension of the MS SQL server 2016. I don't know Microsoft plans to extend it, but I know that Profisee and CluedIn are very active in promoting their solutions as-built having Azure in mind and being a part of the stack.

    Informatica MDM has three types of offerings these days: on-prem, hosted MDM, and cloud-native option - they differ in the functionality and integration options.

    Obviously, there are many more MDM tools on the market particularly good in various data domains (products, customers/suppliers - so yours, multi-domain, etc).

    I think that you should start your MDM journey by answering which current challenges you try to solve or what new capabilities you need to enable to the organisation. Once these questions are answered and based on your organization's Enterprise Architecture principles, look for the best fitting tool. It may (or may not) be the one that fits the best into the Azure Reference Architecture.

    I hope this helped.

    Find out what your peers are saying about Informatica, Microsoft, SAP and others in Master Data Management (MDM) Software. Updated: January 2022.
    564,322 professionals have used our research since 2012.