1. Using the Oracle Mapper with Oracle Integration 3
  2. Work with Functions, Operators, and XSLT Statements
  3. Add Functions, Operators, and XSLT Statements

Add Functions, Operators, and XSLT Statements

You can add functions, operators, and XSLT statements to your mappings.

Working with Functions

  1. In the Target section, highlight the element node to which to connect.

  2. In the upper right corner, click Toggle functions Mapper functions icon to launch the Components panel.

  3. Expand Functions.

  4. Select a function. For this example, String is expanded and concat is dragged to the target element node. The element can be an existing or ghost (not yet created) element.

    A function icon is added to the Mapping Canvas section for the target element node and the function XPath expression is added to the Expression Builder at the bottom of the page. This icon indicates that a function is used in this mapping.


    Three icons are shown in the upper left. Below this is the Sources section. In the middle is the Mapping Canvas section. To the right is the Targets section. To the far right is the Components section, with Functions appearing below. Function categories are shown: Advanced, Boolean, Conversion, Data, Integration Cloud, Mathematical, Node-set, and String. Below this is the Operations category. In the upper right are the Developer icon, XSLT icon, and six other icons.

    Note:

    You can also initially drag functions to the Expression Builder and then connect the source element(s) to the function.

  5. In the Sources section, drag the source element nodes to the function in the Expression Builder. For this example, startTime and endTime are dragged to the two sides of the comma in the concat( , ) function in the Expression Builder. Do not drag source element nodes to the function icon in the Mapping Canvas section.

  6. Click Save Save expression icon to save your updates.


    The Sources section endTime and startTime elements have been dragged to the concat function in the Expression Builder. The Target section shows the activityId with the attached concat function.

Working with Operators

  1. Expand the Operators section.

  2. Drag an operator to the target element node (for this example, a = is added). The = operator is also added to the Expression Builder. The element node can be a created or ghost element node.


    The Sources tree is shown. To the right is Mapping Canvas section and the Target section. To the right is the Components section, with the Operators subsection shown. The Equal operator has been dragged to the Filename element in the Target section tree, resulting in an equal sign appearing. At the bottom, the Expression Builder shows an equal sign.

  3. Drag appropriate source elements to both sides of the operator or manually enter values.

  4. Click Save Save expression icon to save the operation.

    The operator icon is displayed in the Mapping Canvas.

Working with XSLT Statements

  1. Click Toggle Functions Mapper functions icon.

  2. Click XSLT.

    An XSLT Constructors header is added to the Components panel.

  3. Expand XSLT Constructors.

  4. Browse for and drag the appropriate XSLT statement onto the target element node or use the search facility to manually enter and search for the XSLT statement.

    Note the following conventions:

    • You can drag statements onto parent or child elements. Note the following conventions about dragging XSLT statements:

      • A green icon is displayed when you drag the XSLT statement to the front or the back of the element.

      • If a green icon is not displayed, you cannot insert as a parent.

      • Drag the statement to the end of the name to insert it as a parent.

      • Drag the statement to the front of the name to insert it as a child.

    • You can only drag XSLT statements onto created elements. If the element on which you want to drag the statement is grayed out (is a ghost node), right-click the element and select Create Target Node.

    For example, drag an if statement to the target element, then map a source element to the target element.


    The eventType source elements is mapped to a target if statement. The Functions, Operators, and XSL Constructors (which is expanded) categories are displayed on the right.

    Or drag a for-each statement to a repeatable element.


    The Record source element is mapped to a target for-each XSL construct. The Functions, Operators, and XSL Constructors (which is expanded) categories are displayed on the right.