MDM Key Mapping.

[Former Member]

Hi,

I tranfered mdm customer data into r/3 and sql server.

Customer Id is created differently in r/3 and sql server.

How to get back this ids and store them in mdm as romote keys?

Please explain me in detail how it works.

Thanks in Advance.

[Former Member]

Hello Rama:

First you have to create Client Systems on the MDM console, of type Inbound/Outbound.

Then Enable the Keymapping feature for the table you are using (on MDM). Choose your repository, on the right pane choose the table, and on Table Details, choose Keymapping = Yes.

When importing data on Import Manager, map the desired source field into the Remote Key field on MDM.

When syndicating, depending on your client system, the right key will be retrieved, if for instance, customers are duplicated on both systems (r/3 and sql server) you'll get the corresponding key for each one.

I hope that helps

Regards

Alejandro

[Former Member]

Thanks for your reply.

In my Scanario,

1) I Created customer data in mdm data manager.Say Customer auto id as 11.

2) Using syndicator,i generated output.xml file.

3) Through XI,file to IDoc and File to Rdbms scanarios,I added customer data in r/3 and oracle.

4) In R/3 Customer Id generated as say "C1" and in sql server customer id as "120".

5) Now,How to update "C1" and "120" in mdm key mapping?

5) How to update xi value mapping for the same?

[Former Member]

Hello Rama:

You can re-import the data, choosing all the fields as matching fields so you can assure you will match the newly created customer with the one already on MDM

When match, now do map the remote key. As default import action choose Update null fields only.

Atfter import, the keymapping will be updated.

BTW, you can create the keymapping from the begining too, if after creating the Customer, right click on it->keymappings and click on Add.

Greetings!

Alejandro

[Former Member]

Hi,

Thanks for your reply.

I dont want to use import manager to update key mapping in mdm.

I want to create webservice method to add/update key mapping data in mdm.

Plz tell me how to do this using mdm api.

[Former Member]

Hello Rama:

I just noticed you opened a new thread, that's good, because this is another issue.

I just answered about using the MDM Api for keymapping too 😃

Greetings

Alejandro

[Former Member]

In the latest version (MDM 5.5 sp4) SAP ships a webservice with the core.

The file you are looking for is in the sub directory \MDM\Web_Services in the download and is called: MDMWEBSERVICES00_1.sca

The service allows for reading, updating of key mappings.

I hope I haven't missed the point with my first post.