/
Using Data Mapper

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

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.

Related content