You can access Data Mapper to map source schema elements to target schema elements.
Prerequisites:
To open Data Mapper applet:
...
Go to Develop > Services > Data Transformation > Data Mapping.
Click Create New.
- Type the name and description of the new mapping activity in the Name and Description text boxes.
- You may find Metadata option. This feature is available in Beta version only. Type the keywords in Metadata. iMap will use these keywords to fetch the mapping for future use. All the keywords are stored in Adeptia secure cloud that will help iMap to fetch the mapping suggestions.
Click Data Mapper. A file - startMapper.jnlp will get downloaded to your computer. Double-click the file to view the Data Mapper screen. Click here to know how to map source and target elements.
Info If you are starting the Data Mapper on your system for the first time, then a warning message is displayed that prevents you from starting this application. Ignore this message and click Start to continue.
Info If you have read-only permissions, you can view a mapping activity in read-only mode. You can view the applied mapping, create new mapping rules, edit existing mapping rules and even run the simulation. For details, refer to the View Mapping in Read-Only Mode section.
Expand Advanced Properties to set options for splitting data. You can split the source data into different chunks. You can specify the size of chunks in terms of the number of records. In the output, however, only one file is generated at the location specified in the target activity. To know more about splitting data, refer to the Splitting Source Data.
Info You can set the Advanced Properties at any time of the mapping activity.
- Click Save to save mapping.
Anchor Data_Mapper Data_Mapper
Understanding Data Mapper
| Data_Mapper | |
| Data_Mapper |
The Data Mapper screen is displayed below:
...
The Data Mapper screen is divided into eight sections. These are outlined as:
- Menu Bar
- Tabs Panel
- Tool Bar
- Source Panel
- Target Panel
- Mapping Functions Panel
- Mapping Graph Area
- Parameters Panel
Menu BarAnchor MB MB
Menu Option | Sub-Option | Function |
|---|---|---|
File
| Load Schema | Loads the source and target schema activity into Data Mapper. |
Save | Saves the mapping activity. | |
Exit | Exits the Data Mapper. | |
View
| Enable Tool Tips For Source/Target Tree | Activates or deactivate tooltips to be displayed at the source or target leaf elements. Tool Tips are always displayed as active for root elements. |
Move Connection Ends | Sets the width of connecting lines. By default, it is set to 50px. | |
View Mapping XML | Displays the generated XML file with line numbers. It is displayed in read-only mode. | |
Actions
| Validate XSL | Validates the generated XSL file. |
Global Custom XSL Before | Adds a custom XSL code at the top of the mapping XSL. | |
Global Custom XSL After | Adds a custom XSL code at the bottom of the mapping XSL. | |
On demand (optimized) loading of XML Schema tree | Process only the root level element; not the complete XSD, if the XSD is complex. When you expand the hierarchy elements, it processes child elements and loads them into memory. The hierarchy elements expansion is now displayed in the applet. This option is applicable only on XML schemas. It optimizes the processing of XML schemas and loads the XSD elements only up to 2 levels in the source and target panels. You need to click a hierarchy element to load its further child elements. | |
Cache Included Schemas | Set whether or not to cache the included XML schemas instead of inlining them as specified by the XML schema specification. This is applicable to all XML Schema which uses XSD. | |
Tree Expand Level for Optimized Loading | Defines the hierarchy level up to which the source and target files will be displayed for the schema loaded in Data Mapper. Hierarchy level is defined in the Tree Expand Level Dialog, which is opened when a user clicks this menu option. By default, its value is 3, that is, Data Mapper will display the hierarchy of source and target files for the respective schema up to level 3. | |
Easy Schema Parser Configuration | Defines the hierarchy level up to which the source and target files will process the schema to load it into the Data Mapper. You can define the hierarchy level in the Tree Expand Level Dialog box, it appears when you click on this menu option. The default value in the Tree Expand Level Dialog box is 10. This means that the Data Mapper will display the hierarchy of source and target files for the respective schema up to level 10. | |
Namespace | Manages Namespace. | |
Enable DBQuery caching | Enables DBQuery cache. This implies that if the same DBquery is fired on another element, it will generate the result from the existing query, instead of creating a new connection. | |
Search Element | Searches an element in the Source or Target schema hierarchy on the basis of Wild Card character(s) Comments, Data Type, Current Mapping Rules, Documentation, and Extension Node Element in the tree node of the Data Mapper. | |
Set Data Viewer Record Count | Sets the maximum number of records that can be shown in the data viewer. | |
Custom Auto Map Options | Adds a custom option for the Auto Mapper. | |
Value Map | Adds an option for value map. | |
Enable Quick Splitting | Splits data at the source and merges at the target end automatically. | |
Import Mapping | Maps the elements in a pattern similar to an existing mapping. | |
Set Character Set Encoding for Data Parsing | Sets the character set encoding for the target schema before mapping the data elements. | |
Create Context Schema Definition | Contains the name of the context variable that you want to map to another element. | |
XSL Settings | XSL Version: Gives you options to change the XSL version used in data mapping. The available options are - Version 1.1, Version 2.0, and Version 3.0. XSL Transformer: Gives you a choice to select a parser to parse your mapping activity in the Data Mapper from the options - SAXON and XALAN. XALAN is supported only in Version 1.1 XSL Version. Streaming Mode: Enables streaming to process large file size while mapping Source and Destination elements. This option is supported only with XSL version 3.0. | |
| Set Font for Mapping | Sets the font for mapping elements. | |
Output Settings | Exclude Result Prefixes: Excludes a namespace prefix from the target element. CData Section Elements: Define CDATA elements for the target schema which will be displayed on the Output section of the Debugger screen. Filter Unmapped Elements: Filter elements or attributes from appearing in the target XML. Indent Output XML: Generates an indented mapping output (XML). Filter Empty Elements: Filters the empty elements from appearing in the output mapping XML. | |
Help
| Data Mapper Help | Displays online help for the Data Mapper section. |
Mapping Functions Help | Displays online help for mapping functions. | |
Tip of the Day | Displays the tips on startup. | |
About Data Mapper | Displays the About box for the Data Mapper tool. |
...