Microsoft MDS vs Talend Open Studio for MDM comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Microsoft MDS and Talend Open Studio for MDM based on real PeerSpot user reviews.

Find out in this report how the two Master Data Management (MDM) Software solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed Microsoft MDS vs. Talend Open Studio for MDM Report (Updated: March 2024).
765,386 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"Enables non-technical people to directly interact with the BI system.""Unlike specialized tools, MDS is adaptable for various industries, making it a versatile choice for master data management.""What I like about Microsoft, is that it has a huge database with many users.""One of the main features I have found useful is the integration with Azure active directory.""It's very easy to use.""It is very easy to deploy and provision a machine.""The most valuable feature of Microsoft MDS is its management.""The solution is easy to install."

More Microsoft MDS Pros →

"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.""The most valuable features are the stewardship and the data prep.""I really like the data fabric."

More Talend Open Studio for MDM Pros →

Cons
"The stability could be improved.""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.""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.""The Microsoft license cost could be lower.""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.""It would be a better option to have an on-cloud version.""There are occasions when the solution maintains SD and we get duplications of MDS.""From my understanding, MS, as of 2021, will not maintain the product going forward."

More Microsoft MDS Cons →

"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.""Creating a model and deploying it is a little bit tricky in Talend, compared to other tools.""I do not have notes for improvement."

More Talend Open Studio for MDM Cons →

Pricing and Cost Advice
  • "The pricing of this solution is good."
  • "With Microsoft, we buy everything though an agreement, so we purchase volume licensing every year."
  • "I would like to see better pricing."
  • "MDS is a part of the SQL Server enterprise license. I am not aware of any additional costs."
  • "SAP is more expensive than Microsoft."
  • "The solution does require a license and we have enterprise licenses."
  • "Microsoft MDS is an expensive solution."
  • More Microsoft MDS Pricing and Cost Advice →

  • "The licensing fees vary depending on the products that you purchase."
  • "It has one single license, and everything is included in it."
  • More Talend Open Studio for MDM Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Master Data Management (MDM) Software solutions are best for your needs.
    765,386 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:Unlike specialized tools, MDS is adaptable for various industries, making it a versatile choice for master data management.
    Top Answer:Microsoft MDS is cost-effective because it comes with SQL Server Enterprise Edition at no extra software cost. The main expenses are for deployment, but it saves money by reducing the need for custom… more »
    Top Answer:Microsoft MDS isn't getting strong support because Microsoft is focusing more on cloud solutions. Profisee initially made MDS, which Microsoft bought. Profisee now handles the cloud version. There are… more »
    Top Answer:I don't have any idea about the commercial part. It's handled by a separate team. It has one single license, and everything is included in it.
    Top Answer:The solution is fine as is. I do not have notes for improvement. I do not need any extra features.
    Ranking
    Views
    2,109
    Comparisons
    1,029
    Reviews
    7
    Average Words per Review
    391
    Rating
    8.0
    Views
    687
    Comparisons
    492
    Reviews
    1
    Average Words per Review
    232
    Rating
    8.0
    Comparisons
    Also Known As
    Microsoft Master Data Services, Microsoft MDM, Microsoft SQL Server Master Data Services, MS MDS
    Learn More
    Talend
    Video Not Available
    Overview

    Microsoft Master Data Services (MDS) is an SQL server solution for master data. MDS enables users to organize and manage a business's master set of data into models while also creating rules for updating the data and control over who can edit it. In addition, the master dataset can be shared with other people in your organization through Excel.

    In Master Data Services, you create a model, which is the highest level container in the structure of your master data. This model can then be used to group similar data. Within the model, there can be one or more entities that are similar to a table. Those entities contain members that are the data records. For example, your model can include commodities such as style, color, and product if you manage online product data. The color entity may contain members for various colors. Models may also have attributes that contain values that describe entity members and can be defined within the entities.

    There are also attributes that contain values that help describe entities within entity members. There are two different types of attributes:

    • Free-form attributes - include numbers, dates, text, or files.
    • Domain-based attributes - includes values that can be used as attribute values for other entities.

    Features of Microsoft MDS

    Microsoft MDS offers a variety of features that provide a central management of master data, while accommodating access to editors and other consumers of the information. These features include:

    • Data Validation: With a proactive monitoring process in Business Rules, users can ensure data validity before the lists are used.

    • Domain Agnostic: Any data type or data schema can be supported by the MDS system.

    • Security: Without risking unauthorized changes, IT teams are empowered to control access at the attribute, entity, and record levels.

    • Web-based UI: There is no need to install software, as the web-based user interface gives access to a vast user base.

    • Versioning: Each model in MDS can be versioned, allowing for users to tab particular versions for subscribing systems.

    • Hierarchy Management: MDS offers functional and versatile management of business hierarchies with various hierarchy types and specialized controls.

    • Transaction Logging: MDS offers a transaction log to keep track of changes, as well as the ability to explain why changes were made.

    Reviews from Real Users

    For those managing large quantities of master data, Microsoft MDS is a solution of choice for a number of reasons. Two of those are its ability to empower everyone to interact with the BI system as well as its integration with Azure active directory.

    Satyam S., a senior software developer at a manufacturing company, notes, "Enables non-technical people to directly interact with the BI system."

    An individual contributor at a pharma/biotech company writes, "One of the main features I have found useful is the integration with Azure active directory."

    With Talend Open Studio for MDM, you can download a fully-functional MDM solution today and use it for free, for as long as you want. Available under a GPL open source license, Talend Open Studio for MDM delivers the key data integration, data quality, and data governance functionality that you need to get started with MDM in your company.

    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
    Top Industries
    REVIEWERS
    Non Profit17%
    Manufacturing Company17%
    Retailer8%
    Government8%
    VISITORS READING REVIEWS
    Computer Software Company15%
    Financial Services Firm10%
    Manufacturing Company8%
    Government7%
    VISITORS READING REVIEWS
    Financial Services Firm14%
    Computer Software Company12%
    Retailer9%
    Educational Organization8%
    Company Size
    REVIEWERS
    Small Business40%
    Midsize Enterprise10%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise15%
    Large Enterprise69%
    VISITORS READING REVIEWS
    Small Business25%
    Midsize Enterprise12%
    Large Enterprise63%
    Buyer's Guide
    Microsoft MDS vs. Talend Open Studio for MDM
    March 2024
    Find out what your peers are saying about Microsoft MDS vs. Talend Open Studio for MDM and other solutions. Updated: March 2024.
    765,386 professionals have used our research since 2012.

    Microsoft MDS is ranked 2nd in Master Data Management (MDM) Software with 18 reviews while Talend Open Studio for MDM is ranked 6th in Master Data Management (MDM) Software with 3 reviews. Microsoft MDS is rated 7.6, while Talend Open Studio for MDM is rated 7.6. The top reviewer of Microsoft MDS writes "Useful Excel plug-in, good scalability, and good integration with SQL Server and other Microsoft products". On the other hand, the top reviewer of Talend Open Studio for MDM writes "With the help of their active community, we can resolve any issue quickly, but they should improve the UI and make it user-friendly". Microsoft MDS is most compared with Informatica MDM, SAP Master Data Governance, Profisee, TIBCO EBX and Informatica PIM, whereas Talend Open Studio for MDM is most compared with Talend MDM Platform, Semarchy xDM, Informatica MDM, TIBCO EBX and Reltio Cloud. See our Microsoft MDS vs. Talend Open Studio for MDM report.

    See our list of best Master Data Management (MDM) Software vendors.

    We monitor all Master Data Management (MDM) Software reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.