IT Central Station is now PeerSpot: Here's why

Informatica MDM vs Microsoft MDS comparison

You must select at least 2 products to compare!
Informatica Logo
9,492 views|7,239 comparisons
Microsoft Logo
6,213 views|2,860 comparisons
Featured Review
Buyer's Guide
Informatica MDM vs. Microsoft MDS
July 2022
Find out what your peers are saying about Informatica MDM vs. Microsoft MDS and other solutions. Updated: July 2022.
620,600 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
"The most valuable feature of Informatica MDM is hierarchy management. It's not something that's typically available and effective within ERPs.""The data quality component is very good.""The most valuable features of Informatica MDM are its reliability, match functions, and integration capabilities. The out-of-box functionality of deduplication and built-in data models ensure faster implementation.""Informatica MDM's most valuable feature is the interconnection between multiple Master Data domains.""It has been leading the market with hierarchy management and all the different match concepts and algorithms. They're very robust.""It has flexibility in extending the data model.""New tools are coming out that will enable you to achieve 90 percent of use cases with the out-of-the-box configuration, but I would like to keep Informatica tight here. Otherwise, you need a Java user edit course and other things to do multiple things that you cannot configure out of the box. They have to go through those use cases to do something if those can also be configured rather than coded.""The Provisioning tool is something that is really handy for everyone. It is my pick as the best feature."

More Informatica MDM Pros →

"It's very easy to use.""One of the main features I have found useful is the integration with Azure active directory.""Enables non-technical people to directly interact with the BI system.""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."

More Microsoft MDS Pros →

"Pre-sales technical support is much better than post-sales technical support.""Informatica MDM could improve the interdependency with integration. The solution sometimes becomes a bit difficult to change considering a lot of interdependency with the integration. There can be some improvement in the workflows and they can introduce more artificial intelligence.""The biggest pain point for us is the documentation. Typically, you have to go through knowledge forums and knowledge groups to find out about the syntax issues for interfacing with new products. Typically, you've got to deal with someone who has been through the pain before. Their documents are not really up to date with current innovations happening in the industry. As big as they are, you can't really expect it, but that's our pain point.""The configuration process is pretty lengthy and challenging and could be made easier to understand.""We promote our code changes from a lower to a higher environment, which is highly complex when working with a multi-domain MDM like Informatica. This is the biggest obstacle for Informatica MDM, and I think they should change it because that's very time consuming.""The on-prem solution is harder to learn than the cloud-based versions.""Informatica MDM can improve the data catalog and data marketplace.""The integration could be a bit better. The process is something new."

More Informatica MDM Cons →

"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.""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.""There are occasions when the solution maintains SD and we get duplications of MDS.""It would be a better option to have an on-cloud version."

More Microsoft MDS Cons →

Pricing and Cost Advice
  • "It's pretty high for us. It's more on the higher side, like low to middle high."
  • "It is expensive. That's probably the biggest drawback. The business has heartache paying the license, but that's mainly because they don't realize what value it brings. The key thing about the MDM solution is that it is in the backend, and no one sees what it is actually doing. You don't know it is a problem until it is not there."
  • "Informatica MDM's pricetag should come down. They have to cut some costs."
  • "There is no doubt that it is very expensive, but the brand value comes at a cost. Other MDM solutions in the market that haven't proven themselves like Informatica are also pretty expensive. We need to understand that MDM itself is very expensive to implement. So, Informatica is also pretty expensive. I would rate it a two out of five for being pretty expensive."
  • "It's offers value for money. They're more competitive with respect to pricing and offerings."
  • "Informatica MDM recently changed its pricing model. It's usage-based but I don't have much insight into the current pricing."
  • "Informatica MDM's price could be lower."
  • "I rate the licensing cost of Informatica MDM a five out of ten."
  • More Informatica MDM Pricing and Cost Advice →

  • "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."
  • More Microsoft MDS Pricing and Cost Advice →

    Use our free recommendation engine to learn which Customer Data Integration solutions are best for your needs.
    620,600 professionals have used our research since 2012.
    Answers from the Community
    Richard Tibbetts
    InitZero - PeerSpot reviewerInitZero
    Real 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.

    InitZero - PeerSpot reviewerInitZero
    Real User

    It's probably worth to add the Microsoft promotes using CluedIn as MDM solution on Azure stack. Please have a look at the Microsoft documentation:

    Last week Microsoft and CluedIn had a joined demo seesion. Perhaps you can ask for a link to a recording:

    GaryM - PeerSpot reviewerGaryM
    Real User

    I agree with @InitZero... 

    I would add that there's no future roadmap for MDS and they don't have an Azure solution for it.  Since it's a free product with an SQL license, don't expect Microsoft to invest in it.  

    Even though we are highly dependent upon it currently I'm starting to look towards the future where we need to find a replacement - hopefully, a PaaS solution. It would be great if Microsoft came out with something in Azure but I'm not hopeful at this point.

    Questions from the Community
    Top Answer:Informatica Cloud MDM is built on a completely redesigned platform, comparing to the older Informatica MDM platform. Currently, cloud MDM offering includes a few business solutions like Reference 360… more »
    Top Answer:Informatica MDM's most valuable feature is the interconnection between multiple Master Data domains.
    Top Answer:The solution does require a license and we have enterprise licenses.
    Top Answer:The version that I work with is on-premises and it required an additional virtual machine on the cloud. It would be a better option to have an on-cloud version.
    Average Words per Review
    Average Words per Review
    Also Known As
    Siperian, Customer 360
    Microsoft Master Data Services, Microsoft MDM, Microsoft SQL Server Master Data Services, MS MDS
    Learn More

    Informatica MDM solution delivers the market-leading foundation on which to build that trusted 360-degree view. Companies around the globe rely on Informatica MDM to give business users easy access to the data that drives their strategic decisions about cutting costs, increasing revenues, improving operations, reducing risk, and capitalizing on opportunities. As the industry’s only true end-to-end MDM solution, it incorporates data integration, data quality, data governance, business process management, and master data management on a single vendor-agnostic platform to ensure faster time-to-value.

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

    Learn more about Informatica MDM
    Learn more about Microsoft MDS
    Sample Customers
    UPMC, Citrix
    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
    Top Industries
    Financial Services Firm17%
    Computer Software Company17%
    Manufacturing Company11%
    Energy/Utilities Company11%
    Computer Software Company27%
    Comms Service Provider12%
    Financial Services Firm8%
    Energy/Utilities Company8%
    Non Profit25%
    Computer Software Company25%
    Comms Service Provider16%
    Financial Services Firm7%
    Company Size
    Small Business13%
    Midsize Enterprise3%
    Large Enterprise84%
    Small Business14%
    Midsize Enterprise13%
    Large Enterprise74%
    Small Business31%
    Midsize Enterprise8%
    Large Enterprise62%
    Small Business16%
    Midsize Enterprise18%
    Large Enterprise66%
    Buyer's Guide
    Informatica MDM vs. Microsoft MDS
    July 2022
    Find out what your peers are saying about Informatica MDM vs. Microsoft MDS and other solutions. Updated: July 2022.
    620,600 professionals have used our research since 2012.

    Informatica MDM is ranked 1st in Customer Data Integration with 16 reviews while Microsoft MDS is ranked 2nd in Master Data Management (MDM) Software with 5 reviews. Informatica MDM is rated 8.0, while Microsoft MDS is rated 7.6. The top reviewer of Informatica MDM writes "A mature product that comes with a handy Provisioning tool and can be used for data deduplication purposes in any industry". On the other hand, the top reviewer of Microsoft MDS writes "MDS 2016 - Primitive but the price is right". Informatica MDM is most compared with SAP Master Data Governance, TIBCO EBX, Stibo STEP MDM, IBM InfoSphere MDM and Informatica PIM, whereas Microsoft MDS is most compared with Profisee, SAP Master Data Governance, TIBCO EBX, Boomi AtomSphere Master Data Hub and IBM InfoSphere MDM. See our Informatica MDM vs. Microsoft MDS report.

    We monitor all Customer Data Integration 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.