System and method for intelligently mapping a source element to a target element in an integration cloud service design time

A method for modifying a mapping expression in a cloud-based integration service to create an advanced mapping in the cloud-based integration service, the method comprising:

• providing a cloud service, executing on a computer comprising a microprocessor, wherein the cloud service comprises a web interface application for creating an integration flow between a source application and a target application, and a runtime for executing the integration flow;
• displaying, in the web interface application, a mapping area for a target element of the target application, wherein the mapping area comprises a plurality of target items, the plurality of target items comprising a mapping expression that defines a mapping between a source element of the source application and the target element of the target application;
• displaying, in the web interface application, a plurality of mapping components, wherein each mapping component is configured to be dragged and dropped onto one or more the plurality of target items, wherein a first mapping component represents one or more of a condition for modifying the mapping expression and/or a function for modifying the mapping expression;
• providing an application programming interface that defines a plurality of rules, wherein each rule specifies one or more actions for a combination of a dragged and dropped mapping component and a catching target item catching the dragged and dropped mapping component;
• receiving, in the mapping area, the first mapping component dragged and dropped onto the mapping expression;
• and
• triggering the application programming interface to apply one or more rules of the plurality of rules to automatically generate one or more mapping statements, the one or more mapping statements modifying the mapping expression by one or more of:
• wrapping a function around the mapping expression and/or adding a reference lookup to the mapping expression to create an advanced mapping between the source element and the target element,
• wherein the advanced mapping is deployed and executed by the cloud service as the integration flow between the source application and the target application on the runtime.

A non-transitory computer-readable storage medium storing a set of instructions for modifying a mapping expression in a cloud-based integration service to create an advanced mapping in the cloud-based integration service design time, said instructions, when executed by one or more processors, causing the one or more processors to perform steps comprising:

• providing a cloud service, executing on a computer comprising a microprocessor, wherein the cloud service comprises a web interface application for creating an integration flow between a source application and a target application, and a runtime for executing the integration flow;
• displaying, in the web interface application, a mapping area for a target element of the target application, wherein the mapping area comprises a plurality of target items, the plurality of target items comprising a mapping expression that defines a mapping between a source element of the source application and the target element of the target application;
• displaying, in the web interface application, a plurality of mapping components, wherein each mapping component is configured to be dragged and dropped onto one or more the plurality of target items, wherein a first mapping component represents one or more of a condition for modifying the mapping expression and/or a function for modifying the mapping expression;
• providing an application programming interface that defines a plurality of rules, wherein each rule specifies one or more actions for a combination of a dragged and dropped mapping component and a catching target item catching the dragged and dropped mapping component;
• receiving, in the mapping area, the first mapping component dragged and dropped onto the mapping expression;
• and
• triggering the application programming interface to apply one or more rules of the plurality of rules to automatically generate one or more mapping statements, the one or more mapping statements modifying the mapping expression by one or more of:
• wrapping a function around the mapping expression and/or adding a reference lookup to the mapping expression to create an advanced mapping between the source element and the target element,
• wherein the advanced mapping is deployed and executed by the cloud service as the integration flow between the source application and the target application on the runtime.