Resetting a Domain-Value Map to Its Last Saved State
As you are creating or editing a domain-value map, it is best to save it frequently, especially if you are adding numerous rows manually.
Suppose, for example, you save a domain value map, and then add multiple
additional rows. You realize that entered many incorrect rows since the last time you saved the domain-value map. You can reset the domain-value map to its last saved state by clicking the Reset button. Any changes made after the last time you clicked the Save button are removed.
Resizing Columns in a Domain-Value Map
If the values you add to the cells in a domain value map are wider than the default cell width, you might want to resize the columns, by following these steps:
1. Place the cursor on the boundary between two column headers so that the cursor shape changes to a double-headed arrow; this is the resize cursor.
2. Left-click the double-headed arrow – a dotted line appears at the column boundary.
3. Drag the dotted line left or right, as desired, to indicate the new placement of the boundary.
4. Release the mouse button.
Deleting a Domain-Value Map
If you a domain-value map is no longer used in any routing rule transformations and you want to delete it, follow these steps:
1. Click Maps in the Oracle ESB Control.
2. In the Domain-Value Maps navigator, select the name of the domain-value map that you want to delete.
3. Click the Delete button within the Domain-Value Maps navigator.
The Delete Map dialog box opens.
4. Click Yes.
The selected domain-value map is deleted from the Domain-Value Maps navigator and from the ESB repository.
Using a Domain-Value Map in a Transformation
To include a domain-value map in a transformation, you drag and drop a
lookup-dvm function from the component palette onto the connection between the source and target elements where you want the domain-value map to be used.
Note: If you have previously used Oracle BPEL Process Manager, you may be familiar with the lookup-xml and lookup-table functions. Using these functions you can accomplish operations similar to using the Oracle Enterprise Service Bus lookup-dvm function. However, the lookup-xml and lookup-table functions are independent of the domain-value map infrastructure; a
lookup-table function, for example, cannot be used with an ESB domain-value map.
1. Open an ESB project in Oracle JDeveloper.
For example, open the CustomerData project to display the routing service icons in the Design tab. See Figure 2–2 on page 2-3 for a sample screenshot of the CustomerData project.
2. Select a routing icon in the Design tab and then double-click the transformation XSL icon to display the Data Mapper window.
For example, select CustOut_RS in the Design tab and double click the XSL icon.
3. Expand the trees in the Source and Target panes in the Data Mapper window.
4. Drag and drop the source element to the target element.
For example, State to top:state as shown in Figure 7–8.
Figure 7–8 Data Mapper – Source to Target Map
5. In the Components palette, click the down-arrow and then select Advanced Functions.
The lookup-dvm function is listed in the component palette, as shown in Figure 7–9.
Figure 7–9 Component Palette – lookup-dvm Function
Using a Domain-Value Map in a Transformation
6. Drag and drop lookup-dvm onto the line that connects the source object to the target object.
A lookup-dvm icon appears on the connecting line, as shown in Figure 7–10. The yellow warning triangles indicate that the definition of the lookup-dvm function is not complete.
Figure 7–10 Data Mapper – look-up dvm Function Added
7. Double-click the look-up dvm icon.
The Edit Function – look-up dvm dialog box opens.
8. Specify values for the fields in the Edit Function – look-up dvm dialog box.
Figure 7–11 Edit Function – lookup-dvm
a. You can manually enter a value in sourceValue or the following methods:
Move the source value that appears in the dvmName field to the sourceValue field by clicking Move Down twice.
Press Ctrl-Space to launch Expression Builder. Press the up and down keys to locate an object in the list and press enter to select that item.
b. In the dvmName field, enter the name of the domain-value map schema that you previously defined using the Oracle ESB Control.
Click the flashlight icon to the right of the dvmName field to select the name from a list of domain-value maps stored in the ESB repository.
For example, select 'StateCodes' that was described in "Creating a New Domain-Value Map from Scratch" on page 7-2.
c. In the sourceColumnName field, enter the name of the column in the domain-value map that is associated with the source element value.
Click the flashlight icon to the right of the sourceColumnName field to select the name from the columns defined for the domain-value map you previously selected.
For example, 'Long'
d. In the targetColumnName field, enter the name of the column in the domain-value map that is associated with the target element value.
Click the flashlight icon to the right of the targetColumnName field to select the name from the columns defined for the domain-value map you previously selected.
For example, 'Short'
e. Enter an optional default value.
For example, ""
f. Click OK.
The data mapper appears in the Design tab with the lookup-dvm function icon, as shown in Figure 7–12.
Using a Domain-Value Map in a Transformation
Figure 7–12 Data Mapper – look-up dvm Function Defined
9. From the File menu, click Save All.
10. Register the project with the ESB Server.
When the transformation is included in an ESB routing rule, the transformation is applied at run time. For example, if the StatesCodes domain-value map is used in the transformation, the transformation from the user-specified state value to the state code value required by the target application is applied at run time.
You can view the results of a transformation if you have set up the field in the Trackable Fields tab of the Oracle ESB Control Services view. The tracking data is displayed in the Details tab of the Oracle ESB Control Instances view, as shown in Figure 9–1 on page 9-2.