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

Microsoft MDS vs Talend Open Studio for MDM comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Microsoft MDS
Ranking in Master Data Management (MDM) Software
2nd
Average Rating
7.6
Reviews Sentiment
8.9
Number of Reviews
21
Ranking in other categories
No ranking in other categories
Talend Open Studio for MDM
Ranking in Master Data Management (MDM) Software
6th
Average Rating
7.6
Number of Reviews
3
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of January 2025, in the Master Data Management (MDM) Software category, the mindshare of Microsoft MDS is 13.2%, down from 14.6% compared to the previous year. The mindshare of Talend Open Studio for MDM is 8.1%, up from 7.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Master Data Management (MDM) Software
 

Featured Reviews

RaymundoAvila - PeerSpot reviewer
Easy-to-use product with valuable data management functionality
Microsoft MDS is simple to use. Compared to other databases, it is easier to manage and administer The program's navigation tools could be improved. The process of changing the database and uninstalling should be easier, perhaps by making some changes in one program without reinstalling…
Sivanandam Krishnan - PeerSpot reviewer
With the help of their active community, we can resolve any issue quickly, but they should improve the UI and make it user-friendly
It can definitely be improved on the UI side. They can provide a better UI as compared to what is currently available. I'm trying to set up the UI to capture some information, and when I try to use the native feature of Talend, I'm finding it difficult. It could be improved a bit. Only when it comes to MDM, it is not user-friendly, but when it comes to data integration of Big Data, it's extremely user-friendly. The features are available in silos, but I need a complete package that is capable of doing some sort of profiling and defining stewardship.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The best thing about it is that it comes with the Microsoft package."
"Compared to other databases, it is easier to manage and administer."
"The tool is easy to use."
"The most valuable feature of Microsoft MDS is its management."
"Enables non-technical people to directly interact with the BI system."
"What I like about Microsoft, is that it has a huge database with many users."
"The solution is easy to install."
"The most valuable feature of Microsoft MDS is its compatibility with ETL tools like SSIS, which simplifies operations for end-users."
"The most valuable features are the stewardship and the data prep."
"I really like the data fabric."
"The biggest advantage of Talend is that they have an active community. If we face any issue, we can get input in a short duration of time."
 

Cons

"In the next version, I would like to see integration with Azure."
"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."
"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."
"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."
"If Microsoft MDS were part of Azure, it would be significantly more helpful."
"The program's navigation tools could be improved."
"Microsoft MDS' language should be simple so everyone can use it easily."
"The stability could be improved."
"Creating a model and deploying it is a little bit tricky in Talend, compared to other tools."
"I do not have notes for improvement."
"It can definitely be improved on the UI side. They can provide a better UI as compared to what is currently available. I'm trying to set up the UI to capture some information, and when I try to use the native feature of Talend, I'm finding it difficult. It could be improved a bit. Only when it comes to MDM, it is not user-friendly, but when it comes to data integration of Big Data, it's extremely user-friendly."
 

Pricing and Cost Advice

"The solution does require a license and we have enterprise licenses."
"SAP is more expensive than Microsoft."
"With Microsoft, we buy everything though an agreement, so we purchase volume licensing every year."
"The pricing of this solution is good."
"MDS is a part of the SQL Server enterprise license. I am not aware of any additional costs."
"Product licensing is very complicated. It would be helpful to have an online calculator to estimate the cost of a license."
"I would like to see better pricing."
"Microsoft MDS is an expensive solution."
"It has one single license, and everything is included in it."
"The licensing fees vary depending on the products that you purchase."
report
Use our free recommendation engine to learn which Master Data Management (MDM) Software solutions are best for your needs.
830,726 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
15%
Financial Services Firm
11%
Manufacturing Company
10%
Government
7%
Educational Organization
11%
Financial Services Firm
11%
Retailer
10%
Computer Software Company
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What do you like most about Microsoft MDS?
More generic related things can be included in the services.
What is your experience regarding pricing and costs for Microsoft MDS?
Microsoft MDS is cost-effective because it comes free with SQL Server.
What needs improvement with Microsoft MDS?
If Microsoft MDS were part of Azure, it would be significantly more helpful. Additionally, integrating fuzzy duplication within MDS itself, rather than relying on SSIS, would streamline operations....
What needs improvement with Talend Open Studio for MDM?
The solution is fine as is. I do not have notes for improvement. I do not need any extra features.
What is your primary use case for Talend Open Studio for MDM?
I use the solution for various reasons in projects. It helps with data warehousing, file cleansing, and various business transformations.
 

Also Known As

Microsoft Master Data Services, Microsoft MDM, Microsoft SQL Server Master Data Services, MS MDS
No data available
 

Learn More

Video not available
 

Overview

 

Sample Customers

ETA a.s., Apeejay Surrendra Group, Blue Star Infotech, Rotherham Doncaster and South Humber NHS Foundation, The Sydney Children's Hospitals Network, New Belgium Brewing
Information Not Available
Find out what your peers are saying about Microsoft MDS vs. Talend Open Studio for MDM and other solutions. Updated: January 2025.
830,726 professionals have used our research since 2012.