Task 6: How to Specify Routing Rules

You must specify the path that messages take from the ReadOrders adapter service to the external reference.

To specify routing rules:

  1. Connect the ProcessOrders Oracle Mediator to the WriteCommonOrder reference, as shown in Figure 45-15.

    Figure 45-15 ProcessOrders Mediator Connected to the WriteCommonOrder Reference

    Description of Figure 45-15 follows
    Description of "Figure 45-15 ProcessOrders Mediator Connected to the WriteCommonOrder Reference"
  2. Double-click the ProcessOrders Oracle Mediator.
  3. To the right of the Transform Using field, click the icon.

    The Request Transformation Map dialog appears.

  4. Select Create New Mapper File and click OK.

    A listOfOrder_To_listOfOrder.xsl file appears in the XSLT Mapper.

  5. Drag and drop the imp1:listOfOrder source element onto the imp1:listOfOrder target element.

    The Auto Map Preferences dialog appears.

  6. From the During Auto Map options, deselect Match Elements Considering their Ancestor Names.
  7. Click OK.

    The listOfOrder_To_listOfOrder.xsl file appears, as shown in Figure 45-16.

    Figure 45-16 imp1:listOfOrder To imp1:listOfOrder Transformation

    Description of Figure 45-16 follows
    Description of "Figure 45-16 imp1:listOfOrder To imp1:listOfOrder Transformation"
  8. In the Components window, select Advanced.
  9. Click DVM Functions.
  10. Drag and drop lookupValue on the line connecting the unitsOfMeasure elements, as shown in Figure 45-17.

    Figure 45-17 Adding lookupValue Function to imp1:listOfOrder To imp1:listOfOrder.xsl

    Description of Figure 45-17 follows
    Description of "Figure 45-17 Adding lookupValue Function to imp1:listOfOrder To imp1:listOfOrder.xsl"
  11. Double-click the lookupvalue icon.

    The Edit Function-lookupValue dialog appears.

  12. To the right of the dvmLocation field, click Search.

    The SOA Resource Lookup dialog appears.

  13. Select UnitsofMeasure.dvm and click OK.
  14. To the right of the sourceColumnName field, click Search.

    The Select DVM Column dialog appears.

  15. Select Siebel and click OK.
  16. In the sourceValue column, enter the following:

    /imp1:listOfOrder/imp1:order/imp1:baseData/imp1:unitOfMeasure

  17. To the right of the targetColumnName field, click Search.

    The Select DVM Column dialog appears.

  18. Select Common and click OK.
  19. In the defaultValue field, enter "No_Value_Found".
  20. Click Add.

    A qualifierColumnName row is added.

  21. In the qualifierColumnName field, enter "StandardCode".
  22. Click Add.

    A qualifierValue row is added.

  23. In the qualifierValue field, enter the following:

    /imp1:listOfOrder/imp1:order/imp1:baseData/imp1:standard.

  24. Click Add to insert another qualifierColumnName row.
  25. In the qualifierColumnName field, enter "TradingPartner".
  26. Click Add to insert another qualifierValue row.
  27. In the qualifierValue field, enter the following:

    /imp1:listOfOrder/imp1:order/imp1:baseData/imp1:tp.

    The Edit Function-lookupValue dialog appears, as shown in Figure 45-18.

    Figure 45-18 Edit Function-lookupValue Function Dialog: Hierarchical Lookup Use Case

    Description of Figure 45-18 follows
    Description of "Figure 45-18 Edit Function-lookupValue Function Dialog: Hierarchical Lookup Use Case"
  28. Click OK.

    The transformation appears, as shown in Figure 45-19.

    Figure 45-19 Complete imp1:listOfOrder To imp1:listOfOrder Transformation

    Description of Figure 45-19 follows
    Description of "Figure 45-19 Complete imp1:listOfOrder To imp1:listOfOrder Transformation"
  29. From the File menu, select Save All and close the listOfOrder_To_listOfOrder.xsl file at the top.