Dynamic mapping of 3rd party applications with SAP Business One

[Mari_Ma]

Hello Experts ;

I want to do a dynamic mapping between whatever 3rd party application and my backend SAP Business one and this dynamic mapping will map the fields of the 3rd party application (like Shopify,Magento ...) with the appropriate fields in SAP Business one.

I have to mention that whenever i want to change the third party application from one to another i don't have to create another mapping for it here is the dynamic aspect will reveal. I want to use SAP CPI for the integration process.

Any suggestion please ?

[bdBais]

To achive a dynamic mapping between 3rd part application you must to use XSLT or Groovy Script, not Message Mapping, the xsd dynamic is not supported and probably is not enougth. About your requirements you must to understand the fragility of this implementation, if you doesn't recognize the field (with different name, structure, format) and you put value dynamically on other field you will be in trouble. If you want to add "any structure" to a destination that accept "any structure" and create new fields when they are not present (I doubt this kind of approach exist in your architecture) you can try to use a normal xslt or groovy script.

[rasjoshi]

Hi @Mari_Ma,

Is your source structure same irrespective of application? Also do you have any message transformation logic to apply?

BR,

RJ

[Mari_Ma]

Hi @rasjoshi;

No, they're not the same. For example, integrating Magento with SAP Business One is different from integrating Shopify with SAP Business One. I need to create a dynamic mapping using a JSON file for this requirement.

Do you have any idea please