Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

You can access Data Mapper to map source schema elements to target schema elements.

Prerequisites:

To open Data Mapper applet:

...

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 XSL Version 1.1.

Expand
titleChanging Saxonica SAXONICA Transformer Properties

If you are using Adeptia Suite v6.9.2 or later, you can change the SAXONICA Transformer Properties. The link contains a complete list of the configuration features available. Steps to include/update a feature:

  1. Visit SAXONICA Configuration features page
  2. Copy the property URL written in the Description column. (For Example: http://saxon.sf.net/feature/allow-external-functions)



  3. Open the file saxonicaConfig.properties from the path ...\<AdeptiaInstallFolder>\AdeptiaServer\ServerKernel\etc
  4. Paste the copied property URL
  5. Type equality sign (=) and enter a value. All possible values are provided in Description column in the above link.
    For example:
    http://saxon.sf.net/feature/allow-external-functions=false
  6. You can set multiple properties in the file by defining each property in a new line.


Anchor
Streaming
Streaming
Streaming Mode: Streaming is useful while working with large files or documents. Streaming processes files by streaming the part of a file rather than loading the whole file into memory. You need to enable streaming to process large size file while mapping Source and Destination elements but before enabling you must follow some streaming guidelines. This option is supported only with XSL Version 3.0.

Set Font for MappingSets the font for mapping elements.

 

Output Settings

Exclude Result Prefixes: Excludes a namespace prefix from the target element.

CData Section Elements: Defines the CDATA elements for the target schema which will be displayed on the Output section of the Debugger screen.

Filter Unmapped Elements: Filters the elements or attributes from appearing in the target XML.

Indent Output XML: Generates an indented mapping output (XML).

Anchor
FilterEmptyElements
FilterEmptyElements
Filter Empty Elements: Filters the empty elements from appearing in the output mapping XML.

Expand
titleEnabling Filter Empty Elements

To enable Filter Empty Elements, you will have to change the jar name manually. Following are the steps to change the jar name.

  1. Go to ….Adeptia-installation-path\AdeptiaServer\ServerKernel\etc\launcher.properties
  2. In the launcher properties file search for JAR:SAXON.
  3. Rename old saxon9pe.jar (old jar name) to saxon9ee.jar (new jar name)
  4. Restart kernel and web runner.

Handling Saxonica in v6.9.1

 

With upgrade to Adeptia Suite v6.9.2, existing customers using Adeptia Suite v6.9.2 will be automatically rolled back to the older version (i.e. saxon9pe.jar) of Saxonica. If you want to use Filter Empty Elements feature, follow the steps mentioned above for changing the jar name.

After you have upgraded Saxonica to ee version in latest version, you must run regression testing to ensure that all you’re existing mappings are working fine.

 

 

 

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.

...