Try our new research platform with insights from 80,000+ expert users

Microsoft MDS pros and cons

Vendor: Microsoft

3.7 out of 5

23 reviews
91% willing to recommend

Pros & Cons summary

Microsoft MDS integrates seamlessly with SQL Server and Azure Active Directory, offering an Excel plug-in for direct data management. Despite being easy to deploy and valued for its administration console, it could better integrate with other Microsoft products. The stability is sometimes fragile, lacking modern updates as Microsoft shifts focus to cloud solutions, and it requires additional tools for true MDM capabilities due to missing components for data matching and merging.

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.

Prominent pros & cons

PROS

Microsoft MDS offers excellent technical support.

The administration console is a highly valuable feature.

It integrates seamlessly with SQL Server and SSIS for ETL processes.

Its compatibility with ETL tools like SSIS simplifies operations for end-users.

It is an adaptable choice for master data management across various industries.

CONS

Microsoft MDS lacks integration with other Microsoft products and a true MDM component, requiring additional tools like DQS and SSIS.

The lack of an on-cloud version limits users seeking more flexible deployment options.

Support and updates for Microsoft MDS are diminishing as Microsoft focuses more on cloud solutions.

The stability of Microsoft MDS can be fragile, with potential issues arising if not properly managed.

Microsoft MDS is considered outdated, lacking modern capabilities and ease of use.

Microsoft MDS Pros review quotes

Data Architect at a government with 10,001+ employees

Jul 31, 2019

Technical support is very good.

Read full review

reviewer1153395

Decision Consultant at a consultancy with 1-10 employees

Oct 6, 2019

The most valuable feature is the administration console.

Read full review

reviewer1222620

System Engineer at a university with 1,001-5,000 employees

Dec 15, 2019

It is very easy to deploy and provision a machine.

Read full review

Free Report: Microsoft MDS Reviews and More

Learn what your peers think about Microsoft MDS. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.

879,310 professionals have used our research since 2012.

SJ

Sr. Database Developer at Hill Physicians Medical Group

Mar 4, 2021

It has a very good feature called Excel plug-in. You just have to install the plug-in, and then it directly connects to the MDS instance where you can maintain and manage your data and publish it right through Excel. You don't need to go to the front end to make any changes. It has easy integration with SQL Server, and you can use SSIS to do the ETLs. It is a part of the Microsoft stack. It works with most of the Microsoft stuff.

Read full review

AM

Global Data Architecture and Data Science Director at FH

Apr 1, 2021

It's very easy to use.

Read full review

reviewer1545213

Individual Contributor at a pharma/biotech company with 1,001-5,000 employees

Apr 15, 2021

One of the main features I have found useful is the integration with Azure active directory.

Read full review

Technical Lead at a computer software company with 5,001-10,000 employees

Oct 12, 2021

Enables non-technical people to directly interact with the BI system.

Read full review

Fabian Pieterse

Lead Developer at HaynesPro

Sep 6, 2022

The backup and restore functionality are the solution's most valuable aspects.

Read full review

reviewer2083734

Senior system engineer for Microsoft, network and ICT systems at a manufacturing company with 5,001-10,000 employees

Jan 26, 2023

The most valuable feature of Microsoft MDS is its management.

Read full review

Srinivas Nandula

Lead Developer at Liberty Specialty Markets

Jan 26, 2023

The ease of use is valuable.

Read full review

Show 8 more reviews (out of 18)

Microsoft MDS Cons review quotes

Data Architect at a government with 10,001+ employees

Jul 31, 2019

The solution could be better integrated into Microsoft's other products.

Read full review

reviewer1153395

Decision Consultant at a consultancy with 1-10 employees

Oct 6, 2019

In the next version, I would like to see integration with Azure.

Read full review

reviewer1222620

System Engineer at a university with 1,001-5,000 employees

Dec 15, 2019

Most of the Microsoft partners, especially digitally, are separate. Personnel are business people, and they do not have technical expertise, so you end up as a company spending a lot of money training your staff and your engineers.

Read full review

Free Report: Microsoft MDS Reviews and More

Learn what your peers think about Microsoft MDS. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.

879,310 professionals have used our research since 2012.

SJ

Sr. Database Developer at Hill Physicians Medical Group

Mar 4, 2021

The only drawback is that it does not have the matching, merging, and all true MDM components. For these, you have to use another competent called Data Quality Services (DQS). You need to plug it in and use it along with MDS for true MDM. Both of these are integrated together, but you have to do them separately, whereas, in Profisee, there are a couple of screens where you can configure the matching process, create matching rules, and other things, and everything is in one product, which is not the case with MDS. In order to implement a true MDM, you need MDS, DQS, and SSIS. You have to use MDS to store your golden records, DQS to configure and standardize all your rules and matching percentages, and SSIS to load the data to DQS and MDS. At the same time, you also need Melissa Data to clean up your addresses to validate and standardize the addresses. That's the main component of true MDM. It would be good if they can create a true matching component inside MDS and merge MDS and DQS.

Read full review

AM

Global Data Architecture and Data Science Director at FH

Apr 1, 2021

It would be a better option to have an on-cloud version.

Read full review

reviewer1545213

Individual Contributor at a pharma/biotech company with 1,001-5,000 employees

Apr 15, 2021

I do not like using Silverlight and Internet Explorer. The new 2019 version gets rid of that, which is one of the reasons why we are looking to switch.

Read full review

Technical Lead at a computer software company with 5,001-10,000 employees

Oct 12, 2021

There are occasions when the solution maintains SD and we get duplications of MDS.

Read full review

Fabian Pieterse

Lead Developer at HaynesPro

Sep 6, 2022

The Microsoft license cost could be lower.

Read full review

reviewer2083734

Senior system engineer for Microsoft, network and ICT systems at a manufacturing company with 5,001-10,000 employees

Jan 26, 2023

The stability could be improved.

Read full review

Srinivas Nandula

Lead Developer at Liberty Specialty Markets

Jan 26, 2023

JMD repositories have records that come in thousands and millions, which takes a long time to process.

Read full review

Show 8 more reviews (out of 18)

Product Categories

Product Categories

Master Data Management (MDM) Software

Popular Comparisons

Popular Comparisons

Qlik Talend Cloud vs Microsoft MDS

Ataccama ONE Platform vs Microsoft MDS

SAP Master Data Governance vs Microsoft MDS

TIBCO EBX vs Microsoft MDS

Semarchy xDM vs Microsoft MDS

IBM InfoSphere MDM vs Microsoft MDS

Pimcore vs Microsoft MDS

Oracle Data Relationship Management vs Microsoft MDS

SAS MDM vs Microsoft MDS

See all alternatives

Product Categories

Product Categories

Master Data Management (MDM) Software

Popular Comparisons

Popular Comparisons

Qlik Talend Cloud vs Microsoft MDS

Ataccama ONE Platform vs Microsoft MDS

SAP Master Data Governance vs Microsoft MDS

TIBCO EBX vs Microsoft MDS

Semarchy xDM vs Microsoft MDS

IBM InfoSphere MDM vs Microsoft MDS

Pimcore vs Microsoft MDS

Oracle Data Relationship Management vs Microsoft MDS

SAS MDM vs Microsoft MDS

See all alternatives

Related questions

135

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

14

What are the strengths and weaknesses of using Informatica PIM as opposed to Stibo STEP?

89

Reltio: Question about Master Data Management Capabilities

58

Test Cases for MDM Implementation

55

What are the biggest challenges in master data management implementation?

49

What is the difference between master data management and data governance?

15

Has anyone compared Informaticta to IBM to SAS for an MDM solution?

11

Informatica MDM or Hybris PCM? Buy vs. Build?

12

When evaluating Master Data Management, what aspect do you think is the most important to look for?

35

Centralized Master Data Management (MDM) architecture: questions about out-of-the-box functionality and user-friendly environment