One of the key tasks to any integration is defining how data is transferred, or mapped, between two applications.
In most cases, the messages you want to transfer between the applications in an integration have different data structures. A visual mapper enables you to map fields between applications by dragging source fields onto target fields. When you open the mapper for a request or response message in an integration, the data structures are automatically populated with the information pulled from the source and target connections. You can expand and the load data structure levels on demand to display additional levels. There is no limit on the levels of display.
Description of the illustration mapper_about_mapping.png
The maps you create are called transformation maps, and use the eXtensible Stylesheet Language (XSL) to describe the data mappings, which lets you perform complex data manipulation and transformation. A standard set of XPath functions are provided for you to define how data is modified when moving from one application to another. A specialized function is also provided for you to reference lookups directly from the mapper.
The mapper supports both qualified and unqualified schemas (that is, schemas without
elementFormDefault=”qualified”). Elements and attributes with and without namespace prefixes are also supported.
Substitution groups in schemas are supported. You can see all the substitutable elements in a base element in the mapper, and select the one to use.
Elements and attributes for which mapping is required are identified by a blue asterisk (*) to the left of their names. To display only required fields, click the Filter icon, select Required Fields, and click Apply.
Description of the illustration mapper_elem_details.png
You can also place your cursor over elements and attributes to display specific schema details such as the data type, if mapping is required, and so on. When you place your cursor over some elements and attributes, additional custom annotations can also be displayed. These annotations are currently only available with the Oracle Sales Cloud Adapter. The Oracle Sales Cloud Adapter obtains this information from the applications and annotates it in the integration WSDL. This information is then read and made visible as annotations in the mapper (for example, title and description). This information can help you better understand what data is being mapped.
Description of the illustration mapper_annotations.png