2021-12-15T14:59:00Z
RT
Information Architect at Canadian Food Inspection Agency
  • 2
  • 341

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

http://clickthru.peerspot.com/...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!

    3
    PeerSpot user
    3 Answers
    MW
    Enterprise MDM Architect / Solution Arch at a energy/utilities company with 10,001+ employees
    Real User
    Top 5Leaderboard
    2022-01-14T10:21:50Z
    Jan 14, 2022

    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.

    Product comparison that may be of interest to you
    MW
    Enterprise MDM Architect / Solution Arch at a energy/utilities company with 10,001+ employees
    Real User
    Top 5Leaderboard
    2022-02-07T10:06:11Z
    Feb 7, 2022

    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:


    https://docs.microsoft.com/en-...


    Last week Microsoft and CluedIn had a joined demo seesion. Perhaps you can ask for a link to a recording: https://www.linkedin.com/posts...


    MW
    Enterprise MDM Architect / Solution Arch at a energy/utilities company with 10,001+ employees
    Real User
    Top 5Leaderboard
    Feb 10, 2022

    @GaryM - What data do you manage in MDS currently? That could be one of the leading factor which tool or type of tools to look for. Is it just the reference data which you mentioned in one place? If so, then indeed you can look for something rather simple and prebuilt, for example Reference 360 from Informatica or build your own bespoke solution. I have seen such bespoke systems working well for years in large organizations. Reference Data Management tools are in a nutshell very simple in terms of the data model: there are reference lists (let's take an example of ISO Country list Alpha-2) with reference codes, values and a few extra attributes (for example NL - The Netherlands), cross-references (cross-walks with source systems providing the reference lists, so for example they may use their own codes and have their own values), hierarchies (example: continent -> country -> state) and pretty much that's it. Then you need a simple UI, probably no workflows or a simple one, ability to specify basic business rules and finally pretty good support for various integration patterns. 

    PeerSpot user
    GM
    Data Architect at World Vision
    Real User
    Top 5Leaderboard
    2022-02-04T21:55:09Z
    Feb 4, 2022

    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.

    Find out what your peers are saying about Informatica MDM vs. Microsoft MDS and other solutions. Updated: July 2022.
    690,226 professionals have used our research since 2012.
    Related Questions
    VM
    Senior Manager INFOSEC AND Risk ASSESSMENT Engineering at a tech services company with 201-500 employees
    Feb 8, 2023
    Hello community,  I am a Senior Manager at a medium-sized tech services company. My company is planning to migrate from AWS to Azure. We would like to know the benefits of Azure versus AWS. Which one do you prefer? In addition, what should be on our checklist during this migration? Thank you for your help.
    See 2 answers
    AS
    IT Support at a tech services company with 51-200 employees
    Feb 8, 2023
    At one level both providers are about the same. The biggest difference is the billing and service models.If you have a business relationship with Microsoft for other products and services then bundling in Azure could be a win. It may reduce some costs but at the very least you have 1 fewer service providers to deal with.I tend to like AWS but that is just because I am familiar with their services. One thing to keep track of is the costs. I have one client who really wants to move to AWS but cannot find a way to get over the 8-10 times increase in monthly costs over operating out of a shared data center with purchased equipment.
    Usman-Malik - PeerSpot reviewer
    Cloud Native Architect | Kubernetes | Security | DevOps | SRE | Consultant at a tech company with 1,001-5,000 employees
    Feb 8, 2023
    Hi,This totally depends on your organization, what identity management and other products are being used, etc. It can actually depend on a lot of factors. For me, it is hard to say that one is definitively "better" than the other as it largely depends on the specific needs and requirements of the organization. Both Amazon Web Services (AWS) and Microsoft Azure are highly capable cloud computing platforms with a wide range of features and services. For some organizations, AWS may be the better option due to its strong portfolio of infrastructure and platform services, extensive global network of data centers, and its mature and well-established ecosystem of third-party tools and services. For others, Azure may be the better choice due to its strong focus on big data and artificial intelligence (AI) services, its integration with other Microsoft products, and its hybrid cloud capabilities. Ultimately, the best solution will depend on the organization's specific use case and requirements. It is important to carefully evaluate both options and weigh the pros and cons of each before making a decision.
    Ratnodeep Roy - PeerSpot reviewer
    consultant at a tech services company with 201-500 employees
    Aug 3, 2022
    Hi peers, Are you aware of a backup and recovery solution that can backup Azure machines to its own (dedicated) cloud, outside Azure? Thanks.
    2 out of 4 answers
    Mostafa Atrash - PeerSpot reviewer
    Sr. Enterprise Solutions Engineer at Palpay
    Jul 26, 2022
    I once used Commvault. It can cross-backup and restore on a variety of platforms including Azure.
    RandeepPawar - PeerSpot reviewer
    Technical Director at Tecstaq
    Aug 1, 2022
    We have given Acronis Cyber Cloud Solution to most of our clients since it has the capability of any- to-any restoration and it can be achieved on any cloud. 
    Related Articles
    NC
    Content Manager at PeerSpot (formerly IT Central Station)
    Apr 6, 2022
    PeerSpot’s crowdsourced user review platform helps technology decision-makers around the world to better connect with peers and other independent experts who provide advice without vendor bias. Our users have ranked these solutions according to their valuable features, and discuss which features they like most and why. You can read user reviews for the Top 5 Master Data Management (MDM) Softw...
    EB
    Director of Community at PeerSpot (formerly IT Central Station)
    Apr 27, 2022
    Hi dear community members, Here we go again with a new bi-weekly Community Spotlight where we share with you recent contributions: articles, questions and discussions. Check them out below! Trending Cybersecurity Trends To Look Out For in 2022 Top 5 Network Access Control (NAC) Software Solutions Top 5 Performance Testing Tools 2022 PeerSpot Users' DevOps and DevSecOps prediction...
    See 1 comment
    RS
    Performance and Fault-tolerance Architect with 1,001-5,000 employees
    Apr 27, 2022
    very good and valuable information
    Product Comparisons
    Related Articles
    NC
    Content Manager at PeerSpot (formerly IT Central Station)
    Apr 6, 2022
    Top 5 Master Data Management (MDM) Software for 2022
    PeerSpot’s crowdsourced user review platform helps technology decision-makers around the world to...
    EB
    Director of Community at PeerSpot (formerly IT Central Station)
    Apr 27, 2022
    Community Spotlight #12: Top Solutions, Trends and More
    Hi dear community members, Here we go again with a new bi-weekly Community Spotlight where we ...
    Download Free Report
    Download our FREE report comparing Informatica MDM and Microsoft MDS based on reviews, features, and more! Updated: July 2022.
    DOWNLOAD NOW
    690,226 professionals have used our research since 2012.