locked
High overview for a data alignment across systems scenario - MDS 2012-2014 RRS feed

  • Question

  • Hi,

    I need to analyze a scenario as the following one:

    more heterogeneous source systems have the own no transactional business entities (e.g. customers, products, contracts, etc.) but it occurs to ensure the quality of these data. In order to ensure the data consistency, it is necessary to produce an unique hub entity from the all source entities; so, I need to obtain an unique customers entity, an unique products entity and so on. The resulting set of certified hub entities must allows to suggest the data adjustments on to the source systems or to apply the necessary data corrections on to the source systems. In such context, it seems that the source systems maintain the SOE role and the master data management system the SOR role, first the DQS technology allows to ensure the data quality for each business entity of the corresponding source system and then the MDS technology permits to manage the resulting master data and to align data across source systems.

    As a further step, the master data database could represent the certified data source to the underlying data warehouses, data marts and reporting systems.

    Well, I'm searching a paper and/or a ppt to describe this scenario in an high level manner to show to the management people.

    Any helps to me, please? Many thanks

    Monday, January 11, 2016 11:53 AM

Answers

  • Hi,

    I'm not sure if there will be an existing paper for your specific scenario, for such advisory questions, I'd rather recommend you to contact Microsoft Consulting Services to assist you to an efficient solution and best result. For more information on MCS, please see: https://www.microsoft.com/en-us/microsoftservices

    For your reference, a white paper papers for a similar scenario:

    https://msdn.microsoft.com/en-us/library/jj836269.aspx (Cleanse and Match Master Data by Using EIM)

    Sunday, January 17, 2016 5:34 PM
  • Hi pscorca,

    Unfortunately, there is not many white papers about MDS on your particular scenario. The white paper mentioned by Charlies is probably the closest one. There is also another article discussing the MDS architecture, but it may not help you too much. 

    https://msdn.microsoft.com/en-us/library/bb410798.aspx

    For all SQL Server white papers, you can find them at here:

    http://social.technet.microsoft.com/wiki/contents/articles/13146.white-paper-gallery-for-sql-server.aspx

    Thanks

    Monday, April 11, 2016 6:55 PM

All replies

  • Hi Pscorca,

    Thank you for your question. 

    I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated. 

    Thank you for your understanding and support.

    Regards,


    Charlie Liao
    TechNet Community Support

    Friday, January 15, 2016 7:39 AM
  • Hi,

    I'm not sure if there will be an existing paper for your specific scenario, for such advisory questions, I'd rather recommend you to contact Microsoft Consulting Services to assist you to an efficient solution and best result. For more information on MCS, please see: https://www.microsoft.com/en-us/microsoftservices

    For your reference, a white paper papers for a similar scenario:

    https://msdn.microsoft.com/en-us/library/jj836269.aspx (Cleanse and Match Master Data by Using EIM)

    Sunday, January 17, 2016 5:34 PM
  • Other references?

    Thanks

    Monday, April 11, 2016 2:27 PM
  • Hi pscorca,

    Unfortunately, there is not many white papers about MDS on your particular scenario. The white paper mentioned by Charlies is probably the closest one. There is also another article discussing the MDS architecture, but it may not help you too much. 

    https://msdn.microsoft.com/en-us/library/bb410798.aspx

    For all SQL Server white papers, you can find them at here:

    http://social.technet.microsoft.com/wiki/contents/articles/13146.white-paper-gallery-for-sql-server.aspx

    Thanks

    Monday, April 11, 2016 6:55 PM