I hope I can explain this clearly.....
We have a requirement to do key mapping transalations...
The scenario is system A sends an ID to system B and the requirement is to translate the ID before submitting it to system B. This can be accomplished using the standard XI value mapping capabilites/functions which is working fine.
My question is:
Is there any standard XI capability to dynamically add data to the value table?
The scenario would then go as follows:
For an insert/new ID
1) system A sends an new ID (insert), we then add the row to the value table.
2) Next, the new request (ID) is sent to system B (insert). On successful execution, the system B's ID is returned to XI, which is then added to the Value table and correlated to the record that was inserted in step 1 above.
For an update to an ID
1) system A send ID for update, XI then does a lookup and gets the corresponding system B ID
2) XI sends converted ID to system B for update.
I know there are variety of options available to solve this...whether we use ccBPM or get the source or target systems to do the translations themselves or query the target system to determine the correct ID to use....but I just wanted to know if there was any core XI functionality to do this type of thing in XI.
Should XI be used to even do key mapping translations? Is this part of the integration layer's responsibilities?
Any ideas or help would be greatly appreciated.