Pre- Requisites
- JRE 1.6 needs to be installed on your system to open the Data Mapper applet.
- Pop-up Blocker needs to be disabled in the web browser, to open the Data Mapper applet. By default, the Pop-up Blocker is enabled.
Steps to access Data Mapper
On the Adeptia Suite homepage, go to Configure > Services > Data Transform and then click Data Mapping.
This action will show you the Manage Data Mapping screen (see Figure 376).
Figure 376: Manage Data Mapping
Click the Create New link. The Create Data Mapping screen is displayed (see Figure 377).
Figure 377: Create Data Mapping
- Enter the name and description of the new mapping activity in the textboxes Name and Description respectively.
Click the Data Mapper button. This displays the Data Mapper screen (refer to Figure 378).
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.
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.
Click Advanced Properties if you want 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 section.
You can set the Advanced Properties at any time of the mapping activity.
- Once you have set the Advanced Properties, click Save to save the splitting options.
- Understanding Data Mapper Applet
The Data Mapper screen is displayed below:
Figure 378: Data Mapper Applet
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 Bar
Options of the Menu Bar are explained in the table below.
Table 1: Options of Menu Bar
Menu Option | Sub-Option | Function |
|---|---|---|
File
| Load Schema | Load a source and target schema activity into the Data Mapper |
Save | Save mapping activity | |
Exit | Exit Data Mapper | |
View
| Enable Tool Tips For Source/Target Tree | Activate or deactivate Tool Tips to be displayed at source or target leaf elements. Tool Tips are always displayed as active for root elements. |
Move Connection Ends | Set the width of connecting lines. By default, it is set to 50px. | |
View Mapping XML | Display generated XML file with line numbers. It is displayed in read-only mode. | |
Actions
| Validate XSL | Validate the generated XSL file. |
Global Custom XSL Before | Add custom XSL code at the top of the mapping XSL. | |
Global Custom XSL After | Add custom XSL code at the bottom of the mapping XSL. | |
On Demand (optimized) loading of XML Schema tree | If the XSD is complex, then this option allows you to process only the root level element and not the complete XSD. Only when you expand the hierarchy elements, it processes the child elements and loads them into the 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 | This is applicable to all XML Schema which uses XMD. This option sets whether or not to cache the included xml schemas instead of inlining them as specified by the XML Specification. | |
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 user clicks this menu option. | |
Tree Expand Level for Easy Schema Parser | 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. | |
Namespace | Manage Namespace | |
Exclude Result Prefixes | Exclude a namespace prefix from the target element | |
Enable DBQuery caching | Enable 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. By default, the DBQuery cache is disabled. | |
Search Element | Search 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 | Set maximum number of records that can be shown in data viewer | |
Custom Auto Map Options | Add custom options for Auto Mapper | |
Value Map | Add options for value map | |
Enable Quick Splitting | Splits data at source end and merges at target end automatically | |
Import Mapping | Enables to map elements in a pattern that is similar to an existing mapping | |
Set Character Set Encoding for Data Parsing | Enables to set character set encoding for the target schema before mapping the data elements | |
Create Context Schema Definition | Context schema definition contains name of the context variable that you want to map to other element. | |
Filter Unmapped Elements | Filter elements or attributes from appearing in the target XML | |
C Data Section Elements | Enables to define C Data elements for the target schema which will be displayed on the Output section of the Debugger screen | |
XSL Transformer | This option gives you the choice to select the parser that you would want to use to parse your mapping activity in the Data Mapper. | |
Help
| Data Mapper Help | Display online help for the Data Mapper section. |
Mapping Functions Help | Display online help for mapping functions. | |
Tip of the Day | Displays the tips on start up. | |
About Data Mapper | Display the About box for the Data Mapper tool. |
Tabs Panel
Options of the Tabs Panel are explained in the table below.
Table 2: Options of Tabs Panel
Button | Name | Function |
|---|---|---|
| Data Mapper | Display the Data Mapper screen for mapping source and target elements. |
| XSL | Display the generated XSL code with line numbers for the mapping activity. |
| Debugger | Validate and view output of the mapping activity. |
Tool Bar
Options of the Tool Bar are explained in the table below.
Table 3: Options of Tool Bar
Button | Name | Function |
|---|---|---|
| Save Mapping | Save mapping activity |
| Remove All Mappings | Remove all the mapping between the source and the target elements |
| Validate XSL | Validate generated XSL |
| Auto Mapper | Map the source and the target elements if the structure of the source and the target schemas and the names of the source and the target elements are similar |
| One to One Mapping | Map all the source and the target elements under a parent element if the number of elements in the source and the target schemas are same |
| Toggle Element Properties | Displays the property of the source or target element, if it is defined in the schema. |
| Value Map | Opens the Value Map Options dialog box. |
| Custom Auto Map | To automatically map elements of source and target schemas where hierarchy and elements are different. |
| XSL Template(s) | To create XSL Template and further manage XSL templates from the Manage XSL Template screen |
| Load Schema | Open source and target schemas |
Source Panel
The Source Panel is used to display a source schema. All the elements of the source schema are listed in the Source Panel. When multiple source schemas are loaded, then all elements of each schema are listed under their respective source nodes.
Target Panel
The Target Panel is used to display a target schema. All the elements of the target schema are listed in the Target Panel. When multiple target schemas are loaded, then all elements of each schema are listed under their respective target nodes.
Mapping Functions Panel
The Mapping Functions Panel displays all mapping functions that can be used to map source and target schema elements. Mapping functions are supported by XSLT. However, the Data Mapper also includes some customized functions, which are not standard of XSLT. Refer to Using Mapping Functions for details on mapping elements using these functions.
In addition to the mapping functions, an option of XSL Template is also displayed on the Mapping Functions Panel. This option enables you to Add XSL Template and further manage XSL templates from the Manage XSL Template screen.
Mapping Graph Area
The Mapping Graph Area is used to map the source and the target elements. You can apply the mapping function between source and target elements in this section. Mapping of the selected target element is displayed in the Mapping Graph Area. This mapping is displayed in the form of Mapping Rules (graphical representation) or as Textual Rules (code representation). Additionally, you can view and set target element properties such as adding comments for target elements and also repeat occurrences of a target element based on the occurrences of a source element, by applying the For Each property. Further, you can apply sorting rules for elements and also set the Disable-Output-Escaping property.
Additionally, you can create Local, Global and Context Variables in Mapping Graph Area. You can also define Custom Methods and Key Functions in this section.
The Mapping Graph Area comprises of two tabs. These tabs further list sub tabs using which you can perform various functions. These are outlined in the table below.
Table 4: Tabs of Mapping Graph Area
Tab | Sub-Tabs | Function |
|---|---|---|
Node
| Mapping Rules | Display graphical representation of the mapping of source and target elements. |
Textual Rule | Display the textual code representation of the mapping of source and target elements. | |
Local Variables | Create and define local variables for mapping source and target elements. | |
Properties | Display and set properties for source and target elements. Enables you to add comments for elements and applies sorting rules for target elements. It allows you to set the Disable-Output-Escaping property. | |
Global
| Global Variables | Create and define global variables for mapping source and target elements. |
Custom Methods | Create global methods for mapping source and target elements. | |
Key Functions | Create and define keys for mapping source and target elements. | |
Context Variables | Create and define context variables for mapping source and target elements. | |
Connection Info | Create and define connection info variables for mapping source and target elements. | |
Data Viewer
| Source | Preview Data of the uploaded file at the source end. |
Target | Preview Data at the target end according the uploaded source file and mapping rule applied. |
The Mapping Graph Area also comprises of buttons. These buttons are displayed based on the selected tabs. All buttons of the Mapping Graph Area are explained in the table below.
Table 5: Buttons of Mapping Graph Area
Button | Name | Function |
|---|---|---|
| Apply Mapping | Map the selected source elements to the selected target elements. |
| Remove Mapping | Remove the mapping between the selected source and the target elements |
| Pop Out Parameters Panel | Pop out the Parameters Panel and display it as maximized. |
| Add Global/Local/Context Variable/Key | Add a new global, local, context variable or a key. |
| Save Global / Local /Context Variable/Key | Save a new local, global, context variable or a key. |
| Remove Selected Global/Local /Context Variable/Key | Remove the selected global variable, local variable, context variable or key. |
| Remove all Global/Local/Context Variables/Keys | Remove all existing global variables, local variables, context variables or keys. |
| Clears Global / Local variable name and value text fields | Clear all data entry fields while adding a local or global variable. |
| Add New Method | Add a new custom method. |
| Remove Selected Method | Remove the selected custom method. |
You can expand the Mapping Graph Area by clicking Maximize (
) button displayed on the Split Bar below the Source and Target Panels. Similarly, by clicking Minimize (
) button, you can restore the Mapping Graph Area to its original size. Alternately, you can drag the Split Bar to resize the Mapping Graph Area and Source and Target Panels.
Parameters Panel
The parameters listed in the Parameters Panel are explained in the table below.
Table 6: Parameters Listed in the Parameters Panel
Parameters | Description |
|---|---|
Global Variables | Display a list of all the global variables defined for the mapping of source and target elements in the current mapping object. |
Local Variables | Display a list of all the local variables defined for the mapping of source and target elements in the current mapping object. |
Custom Methods | Display a list of all the methods defined for the mapping of source and target elements in the current mapping object. |
Keys | Display a list of all the keys defined for the mapping of source and target elements in the current mapping object. |
Context Variables | Display a list of all the context variables defined for the mapping of source and target elements in the current mapping object. All context variables created in the Data Mapper are transferred to the Process Flow Designer. |
Templates | Display a list of all the XSL templates created for the mapping of source and target elements in the current mapping object. |
Connection Info | Display a list of all connection info variables. |
Global Methods | Display a list of all class files present in the Custom Classes folder. |
Value Map | Display a list of value maps created for the elements |
All parameters are displayed in this section as and when they are created in the mapping process.
You can remove a parameter by right-clicking the parameter and selecting the Remove option.
You can expand the Mapping Graph Area by clicking Maximize () button displayed on the Split Bar below the Source and Target Panels. Similarly, by clicking Minimize () button, you can restore the Mapping Graph Area to its original size. Alternately, you can drag the Split Bar to resize the Mapping Graph Area and Source and Target Panels.