Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
MDS Use

Answered MDS Use

  • Monday, January 28, 2013 12:43 PM
     
     
    Sign In to Vote
    0

    Hi all,
    As per my understanding by reading articles in internet,MDS is useful when multiple application(departments in organisation) are accessing the same master data.
    But when we have only one department and master data data sources are different( some master data coming from one source and another one is from another source like etc,.),in this scenario will MDS is use full? Or any other major advantage of using MDS?

    Thanks in advance


    • Edited by rahul4321 Monday, January 28, 2013 1:21 PM
    •  
     

All Replies

  • Monday, January 28, 2013 9:41 PM
     
     Answered
    Sign In to Vote
    0

    <snip>
    But when we have only one department and master data data sources are different( some master data coming from one source and another one is from another source like etc,.),in this scenario will MDS is use full? 


    Absolutely.  Whenever there are multiple data sources in an environment, there is typically some overlap in the entities (ex. Customer, Product, Supplier, etc). In this scenario, MDS can be used to manage the values for each entity across all data sources in the enterprise.  DQS will aid in the process of combining the values from each system (remove duplicates, clean up, etc).  

    The value is realized when new applications are built/added to the environment, because they can now use MDS.  Over time, as legacy systems are retired, eventually there will be a stable-state where all systems are using clean and managed data from MDS.  Existing applications can be updated to use data from MDS...but that needs to be determined on a case by case basis to make sure the benefit outweighs the cost.


     
  • Tuesday, January 29, 2013 6:57 AM
     
     
    Sign In to Vote
    0
    Is there any disadvantage or some difficulty of using Master data services?
     
  • Tuesday, January 29, 2013 7:02 AM
     
     
    Sign In to Vote
    0

    Hi Billanton,

     We can remove duplicates ,clean up in ordinary oltp database only right?then why we required MDS?

     
  • Thursday, January 31, 2013 8:01 AM
    Moderator
     
     Answered
    Sign In to Vote
    0
    Is there any disadvantage or some difficulty of using Master data services?

    Hello,

    It is hard to answer your question. But I recommend you refer to the following article to get started with SQL Server Master Data Services:
    Getting Started (Master Data Services): http://msdn.microsoft.com/en-us/library/ee633731(v=sql.105).aspx

    Master Data Services (MDS) is the SQL Server solution for master data management. Master data management (MDM) describes the efforts made by an organization to discover and define non-transactional lists of data, with the goal of compiling maintainable master lists. SQL Server MDS provides a central data hub that ensures the integrity of information and consistency of data is constant across different applications. This is why we need Master Data Services.

    Here is an article for your reference, please see:
    Why Do We Need Master Data Management – Importance and Significance of Master Data Management (MDM): http://blog.sqlauthority.com/2012/09/11/sql-server-why-do-we-need-master-data-management-importance-and-significance-of-master-data-management-mdm/

    Regards,

    Elvis Long
    TechNet Community Support