Skip to Content
avatar image
Former Member

MDM Data Manager step-by-step process with an example

Hi All,

I recently started reading MDM. I am clear with MDM-Console concepts. But I have problem with MDM Data Manager. I am confused with data entries in qualified tables, work flows(using microsoft studio), Matching mode- rules(High treshold, low threshold) etc.. I read material posted in forums- but still I am not clear.

I need a step-by-step process for data entries with *examples*. A good example which covers all Data Manager concepts. PDF's with screen shots, videos any thing would help.

Please help me......It would be of great help.

Thanks in Advance.

Suchir

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 12, 2009 at 02:29 AM

    Hey Suchir,

    Check these links it might be helpful

    http://help.sap.com/saphelp_mdm550/helpdata/en/43/e0615f82b40a2ee10000000a11466f/frameset.htm

    http://help.sap.com/saphelp_mdm550/helpdata/en/43/e0677c82b40a2ee10000000a11466f/frameset.htm

    and also refer:

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/c01f54a2-99f1-2a10-5aa5-dcc50870e7f6 (PDF IMPORTING)

    /people/michael.reil/blog/2006/05/18/mdm-matching-strategies-for-master-data-consolidation (matching merging in mdm)

    http://help.sap.com/saphelp_mdm550/helpdata/en/43/e0615f82b40a2ee10000000a11466f/frameset.htm

    /people/klaus.david/blog/2005/09/16/mdm-validations(validations)

    Regards

    SR

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 12, 2009 at 03:45 AM

    Hi Suchir ,

    MDM 5.5 has 4 MDM clients to perform 4 main functionality on the MDM master records.

    - Console- This is where all the Administrative work is performed

    - Data Manager- This is where the actual maintainence work is done on the master data like consolidation deduplication etc.

    - Import manager- Thsi is from where the source matser records are taken into MDM repoistory

    - Syndicator- This is from where teh consolidated master data is send back to the target systems.

    MDM Data Manager is the heart of MDM

    The activities that can be performed in the MDM Data manager are:

    - Data Consolidation

    - Data Validation

    - Data Deduplication

    - Data Assignment

    - Data Governanace

    etc......

    Qualified Table:

    - Qulaified tables are used to store relational records where one field value is determining the other field or fields value.

    - Qualified tables are maintained in Console and can be viewed in Data Manager

    - Qualified Table are viewed under a separate section in Data Manager in the right hand side.

    - Qualified table has Non qualifiers and Qualifiers.

    - Non qualifiers can be seen in the Qualified table and in the linking Qualified field

    - Qualifiers can be seen separately under the Qualified section in the data manager

    Kindly refer the below link to know more on this:

    https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00a15239-684e-2b10-b8ae-b936b7d1c1fe

    Workflows

    - Workflows are designed in MDM for Governanace

    - You can create the MDM workflow using the MS Visio 2003 stencils in the MDM Data manager in the record mode under the workflow table

    - The saved workflow in DM can then be executed either mnaully or automatically based on teh trigger actions

    - The trigger action for teh MDM wf are record Add,Update,Import,Manual

    Kindly refer the below link to know more on this:

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/60559952-ff62-2910-49a5-b4fb8e94f167 (MDM Workflows Overview)

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/90990743-91c0-2a10-fd8f-fad371c7ee40 (Demo of MDM Workflows)

    Matching Mode

    - This mode is exclusively for Master data deduplication

    - We need to create Rules,Strategies,Transformation in MDM data manager in teh record mode

    - Then you need to run these strategies on the selected records

    - Based on your score and threshold set in the strategy MDM will identify duplicate records

    - This score will be seen in teh Matching mode

    - Colour coding is used along with scores to find out dupliactes

    - Green - 100%dupliacte Blue- 50?% Red- No duplicate

    Kindly refer the below link to know more on this:

    /people/michael.reil/blog/2006/05/18/mdm-matching-strategies-for-master-data-consolidation (matching merging in mdm)

    Hope It Helped

    Thanks & Regards

    Simona Pinto

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 12, 2009 at 06:17 AM

    Hey Simona, Shilpa,

    Thanks for the reply. I tried to go through the links which you refered, but I am not able to open/access them. So, it was not that helpful. Please can you please tell me if there is any other way to acess these links.

    Simona, its for you I really do appreciate the way you answer or deal with a problem step by step. How can I master the subject like you.

    Thanks

    Suchir.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Suchir,

      If you are able to access the links and your Query has been resolved.

      Kindly mark the thread as answered and close it.

      So that others will similar query can access it later.

      Hope It Helped

      Thanks & Regards

      Simona Pinto