Load Source and Target Schemas

Steps to load Source and Target Schemas

1. Click Load Schema () on the Tool Bar or click Load Schema from the File menu. This will show you the Select Schema screen which displays a list of existing schemas.          

   
   
   

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

2. Select the schema that you want to load. 
   The Select Schema window supports the following functionality:
   • At times, the list of schemas is very long. In such cases, you can search for schemas to be loaded, based on the schema name or type. Provide 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 a different source and target schema type. This way, you can load multiple schemas at the same time. You can also select all the check boxes to load all the schemas. There is no limit to the number of schemas that you can load at the same time.
   • If you have not created any particular schema type then no schema will be displayed on clicking the respective schema type button.

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

4. Click   to expand and display all elements of the schemas in their respective panels.

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

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, 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 the following steps:

1. Click Edit from the Action menu.

   
   
   

2. On the Edit Data Mapping screen, click Data Mapper to edit the mapping activity.

   
   
   

3. In the Data Mapper, click Actions > XSL Transformer.
4. In the XSL Transformer dialog box, select Saxon.
5. Click OK.
6. Click Save to save the mapping of the Data Mapper.
7. On the Edit Data Mapping screen, click Save to edit the mapping activity. This action will display you a confirmation message.

Changing Xalan to Saxon

If you wish to revert to the old transformer (Xalan Transformer) then do the following:

1. In the Data Mapper, click Actions > XSL Transformer.
2. In the XSL Transformer dialog box, select Xalan.
3. Click OK.

4. Click Save to save the mapping activity.

5. Repeat the steps to change Xalan to Saxon.

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 Actions > Search Element.

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

   

    

   The Element Search Dialog window appears.

   

    

3. Provide the name of the element that you want to search for in the Search Value text box. 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 text box.

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.

   

    

   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 text box.

   

    

6. If multiple matches are found for the search criteria then the Direction panel and the Find Next button is activated. 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.

   

    

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.

   

    

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