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 NameDescription
Accessing Data MapperIntroduces Data Mapper user interface.
Mapping ElementsLearn how to map elements in the Data Mapper.

Using Data Viewer

Introduction to Data Viewer and its usage.
Viewing Mapping in PDF formatKnow how to view mapping activity in PDF format.
View Mapping in Read-Only ModeLearn how to view and manage mapping activity in read-only mode.
Splitting Source DataIntroduces Splitting concept and step-by-step instructions to split source data are also provided.
Set Splitter XPathIntroduces Splitter XPath concept and instructions to set Splitter XPath are also provided.
Enabling Quick SplittingStep-by-step instructions to split source data using Quick Splitting, viewing and removing Splitter XPath.
Set Merger XPathIntroduces Merger XPath concept and instructions to set, view, and remove Merger XPath are also provided.
Assign Data StreamsLearn how to assign streams to the root element of the target schema structures.
Remove Mapping of an ElementLearn how to remove mapping associated with a particular element.
Using Context SchemaIntroduction to Context Schema and its usage to map context variable.
Using Mapping FunctionsKnow about various inbuilt mapping functions available in the Data Mapper. Learn how to map source and target schema elements using mapping functions.
Using DB FunctionLearn how to fetch data from database using various DB Mapping functions.
Using Textual RulesStep-by-step instructions to map elements using Textual Rules.
Using NamespaceStep-by-step instructions to add and edit Namespace in XSL.
Using XSL TemplateIntroduction to XSL template and step-by-step instructions to create XSL template using Mapping Rules and XSL rules are also provided.
Using Global VariableIntroduces Global Variable concept, declaration, managing global variable from Parameters panel, and mapping global variable to target element.
Using Local VariableIntroduces Local Variable concept, declaration, managing local variable from Parameters panel, and mapping local variable to specific target element.
Using Custom MethodsIntroduces Custom Method concept, declaration, and mapping custom method to target element.

Dynamically Loading Custom Methods

Learn how to load custom methods dynamically.
Using Key FunctionIntroduction to Key Function.
Declaring Connection Info VariableLearn how to declare connection info variable.
Setting Target Element PropertiesLearn 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 ElementLearn 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 SchemaLearn how to remove schema from source or target panels.
Adding Custom XSLLearn how to add custom XSL code to a target element.
Select RootLearn how to select the root of a schema.
Adding Namespace PrefixLearn how to add a namespace prefix to a target element.
Excluding Result PrefixesLearn how to exclude namespace prefix from the Output screen.
Populating extension type elementLearn how to select extension type element.
  • No labels