Using Data Mapper

Data Mapper is a visual data-mapping tool used for mapping elements in advanced data integration projects. This tool allows you to specify source and target schemas and to map data fields from source schema to target schema.

You can use the Data Mapper tool to map source schema elements to target schema elements. You can map one source schema element to a target schema element directly by drag and drop method. Additionally, this tool also offers certain mapping functions using which you can map source and target schema elements. Furthermore, the Data Mapper supports multiple source and target schemas. This implies that you can select more than one schema at a time, both at the source and the target end. This facilitates mapping of multiple source and target schema elements.

Following are the major subsections:

Section Name	Description
Accessing Data Mapper	Introduces Data Mapper user interface.
Mapping Elements	Learn how to map elements in the Data Mapper.
Using Data Viewer	Introduction to Data Viewer and its usage.
Viewing Mapping in PDF format	Know how to view mapping activity in PDF format.
View Mapping in Read-Only Mode	Learn how to view and manage mapping activity in read-only mode.
Splitting Source Data	Introduces Splitting concept and step-by-step instructions to split source data are also provided.
Set Splitter XPath	Introduces Splitter XPath concept and instructions to set Splitter XPath are also provided.
Enabling Quick Splitting	Step-by-step instructions to split source data using Quick Splitting, viewing and removing Splitter XPath.
Set Merger XPath	Introduces Merger XPath concept and instructions to set, view, and remove Merger XPath are also provided.
Assign Data Streams	Learn how to assign streams to the root element of the target schema structures.
Remove Mapping of an Element	Learn how to remove mapping associated with a particular element.
Using Context Schema	Introduction to Context Schema and its usage to map context variable.
Using Mapping Functions	Know about various inbuilt mapping functions available in the Data Mapper. Learn how to map source and target schema elements using mapping functions.
Using DB Function	Learn how to fetch data from database using various DB Mapping functions.
Using Textual Rules	Step-by-step instructions to map elements using Textual Rules.
Using Namespace	Step-by-step instructions to add and edit Namespace in XSL.
Using XSL Template	Introduction to XSL template and step-by-step instructions to create XSL template using Mapping Rules and XSL rules are also provided.
Using Global Variable	Introduces Global Variable concept, declaration, managing global variable from Parameters panel, and mapping global variable to target element.
Using Local Variable	Introduces Local Variable concept, declaration, managing local variable from Parameters panel, and mapping local variable to specific target element.
Using Custom Methods	Introduces Custom Method concept, declaration, and mapping custom method to target element.
Dynamically Loading Custom Methods	Learn how to load custom methods dynamically.
Using Key Function	Introduction to Key Function.
Declaring Connection Info Variable	Learn how to declare connection info variable.
Setting Target Element Properties	Learn how to set the properties and add comments to the target element.
Filtering of Elements/Attributes in Target Data	Learn how to filter elements or attributes appearing in the target XML using Apply Filter check box.
Creating Clone of Target Element	Learn how to create and remove the clone of a target element.
Adding a Character Data (CData) Section	Introduction to CData and step-by-step instructions to add CData are also provided.
Removing Schema	Learn how to remove schema from source or target panels.
Adding Custom XSL	Learn how to add custom XSL code to a target element.
Select Root	Learn how to select the root of a schema.
Adding Namespace Prefix	Learn how to add a namespace prefix to a target element.
Excluding Result Prefixes	Learn how to exclude namespace prefix from the Output screen.
Populating extension type element	Learn how to select extension type element.