Steps to load Source and Target Schemas
- Click Load Schema (
If you create a new schema then it will not be displayed in this list. To refresh the list of schemas, click Synchronize.
) 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. - 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 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 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.
- 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.
Click Load 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
to expand and display all elements of the schemas in their respective panels.
The Data Mapper now gives you the choice to select an XSLT transformer for your data mapping activity. It now supports a new transformer Saxon along with the old transformer Xalan. For more details on the new transformer, please refer to the Configuring XSLT Transformer section.
The Data Mapper tool allows you to remove a loaded schema. For details, please refer to the Removing Schema section.
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
Legend | Description |
---|---|
Leaf Element | |
Attribute Element |
If you do not load any schema then all the tabs of the Data Mapper appear as disabled.
Configuring XSLT Transformer
Adeptia Suite provides two XSLT processors for transforming data mapping activity.
- Saxon (New Transformer)
- 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 following the steps below:
Click Edit from the Action menu.
On the Edit Data Mapping screen, click Data Mapper to edit the mapping activity.
- In the Data Mapper, click Actions > XSL Transformer.
- In the XSL Transformer dialog box, select Saxon.
- Click OK.
- Click Save to save the mapping of the Data Mapper.
- 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:
- In the Data Mapper, click Actions > XSL Transformer.
- In the XSL Transformer dialog box, select Xalan.
- Click OK.
Click Save to save the mapping activity.
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
- Ensure that the source and target schemas are loaded and all their elements are listed under their respective nodes.
Click Actions > Search Element.
Alternately you can press <Ctrl> + <F> on the keyboard.
The Element Search Dialog window appears.
- 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.
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.
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.
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.
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.
- Click Yes to search again else click No to close this screen.