MDM remote system addition automation

[Former Member]

We have a requirement to automate the process of second 'remote system' addition to reference data values.

Reference data values are coming from ERP system to MDM and remote systems are added automatically in MDM for these values. Main records comes (along with values in look up/reference fields) from a different remote system (eg. legacy system). Currently, when any reference values are added from ERP to MDM through MDMGX, we manually add this legacy system as remote system for each reference value. Is there way we can automate this legacy system 'remote system' addition in MDM whenever a new reference value is added to MDM from ERP through MDMGX.

Let me know if any of have any thoughts around this.

[Former Member · Accepted solution]

Subin,

My understanding about your question is: You want to add dual key mapping for both the remote systems (ECC & Legacy) using one file, which is coming from ECC.

This not possible to import key mappings for two different remote systems, as the communication map can be configured only for one remote system at a time.

The following workarounds can be helpful for you to achieve your requirement:

First: Perform manual import for every reference table to update the key mapping for Legacy remote system, after the import of ECC reference data.

Second: If you have PI in your project landscape then follow the below steps. Lets say you are going to import Country reference table data, which is coming from ECC to MDM, using MDMGX:

1. Create a Country port under Legacy remote system.
2. PI will create a copy of Country table data file from archive folder of Country (ECC) port.
3. PI will place this file in Country (Legacy) port.
4. Create a import map for Country (Legacy) port, which will update only key mapping.
5. Configure the same import map in Country (Legacy) port.

Third: If you have Unix environment then

1. Create a Unix script, which will move/copy Country table data file from archive folder of Country (ECC) port to Country (Legacy) port.
2. Create a import map for Country (Legacy) port, which will update only key mapping.
3. Configure the same import map in Country (Legacy) port.

Note: You will have to do this for all your reference tables.

Hope, it will help..!!

Thx/ -Tarun

[Former Member]

Hi Subin,

• It would be easiest if you are using PI system as connecting system between ECC and MDM for MDMGX transaction. Then you can simply ask PI system to paste the file in Ready folder of Legacy remote system so that remote keys are updated.

• Other way would be to again involve PI team in picking the files from the archive folders of the ECC remote system and paste it in the Ready folder of corresponding port in Legacy remote system.

• Otherwise you need to do this manually itself as you are doing it currently.

So you can choose the option which suits you best. Also you can explore the options mentioned in the above post. Please let us know.

Thanks and Regards,

Ankush Bhardwaj

[Former Member]

Thanks Guys.

Since MDMGX is already executed as a background job in ECC, easiest for us is to create another set of variants in ECC which sends reference files to legacy ports.

[Former Member]

Hi Subin,

Yes, that would be the easiest way. Thanks for sharing.