Steps to load Source and Target Schemas

1. Click the Load Schema (  ) button on the Tool Bar (see Figure 379)
   

   
   Figure 379: Load Schema button

   Or click the File menu and select the Load Schema option (see Figure 380).

   
   Figure 380: File Menu in Data Mapper

   
   This action will show you the Select Schema screen which displays a list of existing schemas (see Figure 381).
             

   
   Figure 381: Select Schema

   If you create a new schema, then it will not be displayed in this list. To refresh the list of schemas click the Synchronize button.

2. Select the schema that you want to load.     This action will enable the Load button.
   The Select Schema window supports the following functionality:
   • At times, the list of schemas is very long. In such a case, you can search for schemas to be loaded, based on the schema name or type. Enter the name of the schema to be searched in the Quick Search text box and as you type letters, the search field will dynamically search for the values defined in all the schema types and update the table accordingly.
   • To refine the search, you can select the schema type from the Schema Type column. The table will display you only the schema types that you would select. For example, if you select the Excel schema type button then, you will only see the Excel Schemas and the table will be updated accordingly. By default, you will be able to see all the schema types in alphabetical order.
   • To load a schema, search the schema type and select the checkbox(s) corresponding to the schema type. You can select both the source and target schemas for the schema type. In addition, you can select different source and target schema type. This way, you can load multiple schemas at the same time. You can also select all the checkboxes to load all the schemas. There is no limit to the number of schemas that you can load at the same time.
   • You can simultaneously load multiple web service schemas along with other schemas.
   • If you have not created any a particular schema type the no schema will be displayed on clicking the respective schema type button.

3. Click the Load button after you have selected the schema(s) to open. The schema(s) that you will select, will be loaded into the Data Mapper window.

   Click the Close button to close the Select Schema window.

4. Click the Expand  button to expand and display all elements of the schemas in their respective panels (see Figure 382).

Figure 382: Source and Target Schema Elements

You can identify the elements in the Source and Target Panels by the legends displayed before the name of the element. These legends are explained in the table below.

Table 7: Legends of Elements

Configuring XSLT Transformer

The Adeptia Suite provides two XSLT processors for transforming data mapping activity.

1. 1. Saxon (New Transformer)
   2. Xalan (Old Transformer)

Saxon transformer is much faster than Xalan. By default, the Data Mapper selects the Saxon transformer to transform all of your new mapping activity.
You can change the parser of any existing Data Mapping activity by following the steps below:

1. Click on the Action menu of the Data Mapping activity of your choice and then select the Edit menu option (see Figure 383).

   
   Figure 383: Editing A Data Mapping Activity

2. On the Edit Data Mapping screen, click on the Data Mapper button to edit the mapping activity (see Figure 384).

   
   Figure 384: Edit Data Mapping Activity Screen

3. In the Data Mapper, click on the Actions menu and then select the XSL Transformer menu option.
4. In the XSL Transformer dialog box, select the Saxon radio button and click Ok.
5. Click on Save button to save the mapping of the Data Mapper.
6. On the Edit Data Mapping screen, click on the Save button to edit the mapping activity. This action will display you a confirmation message (see Figure 385).

Figure 385: Confirmation Message

If you wish to revert to the old transformer (Xalan Transformer) then, you can achieve
that by the following steps:

1. In the Data Mapper, click on the Actions menu and then select the XSL Transformer menu option.
2. In the XSL Transformer dialog box, select the Xalan radio button and click the OK button.

3. Click on the Save button to save the mapping activity.

   If you want to use the Saxon Transformer then follow these steps:

   1. In the XSL Transformer dialog box, select the Saxon radio button and click the OK button.
   2. Click on Save button to save the mapping activity.

Search Element in Source or Target Schema Tree

At times, when the source or target schemas are quite large, then searching an element can be very cumbersome. The Data Mapper applet eases this task by allowing you to search for an element in a source or target schema.

Steps to search an element in a source or target schema hierarchy

1. Ensure that the source and target schemas are loaded and all their elements are listed under their respective nodes.

2. Click the Actions menu and select Search Element option (see Figure 386).

   Alternately you can press <Ctrl> + <F> on the keyboard.

   

   Figure 386: Select Search Element from Actions menu

   The Element Search Dialog window is displayed (see Figure 387).

   

   Figure 387: Element Search Dialog Box

3. Enter the name of the element that you want to search for, in the Search Value field. You can also use Wild Card character(s) to search for an element. The Xpath of the element is automatically displayed in the Element Path field.

4. Select the appropriate option in the Scope Panel, to search the element in the Source or Target schema hierarchy. For example, if you want to search in the Source schema hierarchy, then select Source Tree option. Only one option can be selected at a time. By default, Target Tree is selected (see Figure 388).

   

   Figure 388: Enter Parameters in Element Search Dialog Box

   As per the enhanced functionality of the search element, you can now also search the element on the basis of comments, Data Type, Current Mapping (Rules), Documentation and Extension Node Element in the tree node of the Data Mapper.

5. Click Find. This searches for the first occurrence of the element in the selected hierarchy. If the element match is found, then that element is selected and highlighted. The Xpath of that node is displayed in the Element Path field (see Figure 389).

   

   Figure 389: Element Match Found

6. If multiple matches are found for the search criteria, then the Direction Panel and the Find Next button is activated (see Figure 390). You can select the direction in which you want to search in the selected hierarchy. For example, if you want to search upwards in the hierarchy, select Up option. Only one option can be selected at a time. By default, Down is selected.

   

   Figure 390: Multiple Matches Found

7. Click Find Next to search for the next element in the hierarchy, based on the selected direction. Once the element match is found, click Close to close the Search Element dialog box. 

   In case no element match is found, then a warning message is displayed (see Figure 391).

   

   Figure 391: Adeptia Mapper Warning

8. Click Yes to search again, else click No to close this screen.