Can you clone Remote System key mappings?

[Former Member]

We have 2 Remote Systems set up for our MDM repository with key mappings for 60 tables. I now need to add an additional Remote System which is similar to one of the existing ones, but with a few different values. Is there any way I can clone the existing one or do I have to go through all 60 tables one by one, export the info, edit it to show the new Remote System name and re-import it? I have searched the sources but can't find anything on this precise topic.

Thanks for any help you can give.

Peter Croft

[Former Member · Accepted solution]

Hi Peter,

No, you can not clone Remote Key values for New Remote System.

You have to import Remote keys for new remote system

Thanks,

Maheshwari

[Former Member · Accepted solution]

Thanks Maheshwari. Is there any way I can automate the process? To export and import 60 tables one by one is a bit daunting.

Peter

[Former Member · Accepted solution]

Hi Peter

If the tables are coming from ECC from MDMGX this can be automated. You will have to prepare variants for new system and schedule for job run.

If the source for the lookup tables is manual import(one time) its advisable to do separately for all 60 tables. The maps can be saved for later use also.

bets regards

Ravi

[Former Member]

Peter,

No you cannot.

Prepare a source having Just two columns ex., new Remote Keys of the system and an common identifier field in the table which you are planning to import with the data. Import it and get it to the data manager as records with just two fields(Remote Key and Common identifier). If you have the import maps already stored for the tables when you have done for the previous imports for the other two remote systems, use them and automate the importing process for this particular remote system (via port configuration in console and Data manager) for the remaining fields of the table.