ID Mapping for Integration – Employees
In this blog I will show how to do the ID Mapping for Integration for Employees, that is required in C4C implementations where Integration with ERP is in scope.
The basic idea is that C4C keeps an internal ascending ID list, which in our case starts with an “8” where in ERP side, every employee is considered as a Vendor, with Account Group Z007 so it starts with a “7“.
What we want, is to map these values so these system can communicate in the same language, understanding the same things, about the same person.
To do that, navigate to “APPLICATION & USER MANAGEMENT“, click on “ID MAPPING FOR INTEGRATION“, and then click on “Edit ID Mapping for Integration“.
In the upcoming screen, in the field “Mapping of:” select the “ERP Employees”
In the “System Instance ID:” field, insert the corresponding system ID of your ERP system, and click on “Go”
Then click on “ID Mapping from Microsoft Excel” and save the document locally.
When the Excel file opens, (you must have downloaded that Microsoft Excel Add-in from the Downloads area inside C4C) navigate to the “SAP HYBRIS CLOUD FOR CUSTOMER” tab, and click on “Logon“.
In the popup window, enter your credentials along with the URL of the tenant
after a successful logon you should be able to see this icon saying “Log off”
Then, click on cell C4 (next to Mapping of), press “Lookup” and in the popup window, click on “Search” with an empty value.
Same actions are needed for the “System Instance ID” cell C5.
Once done, under the Local ID column, enter the C4C internal ID for the employee you want and in the next cell, the External ID as found inside ERP.
Once done, press the “Save Data to” and the popup window will inform you for the success or failure of the process.
If the process is done correctly, you see the message
If not, please comment here or contact me personally at firstname.lastname@example.org
Hello Christoforos Verras
Thank you for detailed explanation. I have loaded employees data by using standard template now I would like to maintain the ID mapping for those employees but I am getting below error.
The above issue resolved by changing the external id
That's great Former Member!
Happy to help 🙂
Thank you for the blog. Is there a way to remove id mappings using the excel add-in. Keeping a blank entry is not helping as the system is expecting a value there.
I have the same requirement. Have you found a solution?
Unfortunately none so far, will update if I happen to find one.
What is solution to remove ID mappings from C4C system?
Haven't tried anything since. However I think you can try to remove the external ID using mass upload (Data Workbench). I hope it works.
Nice idea but not possible.
Even creating custom ODATA doesn't expose the External ID.
Hi Christoforos Verras,
what to do if the “Lookup” feature is not working and there is no value help to chose from for the “Mapping Of” and “System Instance ID”?
When the data is saved to C4C there is an error message saying the object reference was not defined for an object instance…
Thank you, Deborah
Hi Christoforos Verras,
Is the solution for removing ID mapping available now?
Hi at all,
if you need to upload ID Mappings to Cloud for Customer (Sales Cloud), I recommend to use the Data Workbench.
The feature with the Excel Plugin worked at my side only for a very limited number of records. It´s better to download the "Object Identifier Mapping" via Workbench, insert mappings in this file and then it upload again. In my case, this saved me a lot of work.