Data Mapper Data Mapper

Home > Products > Liquid Studio > Data Mapper

Liquid Studio Data Mapper is a powerful data mapping tool that allows you to integrate, map and transform your data between multiple data sources and targets.

Integrate - Map - Transform

Data Mapper Features

  • Provides a graphical visualization of data mapping between multiple data sources and targets.
  • Map data fields using an intuitive drag and drop UI.
  • Support for Databases, EDI data, JSON data, Text Files, Web Services and XML data.
  • Execute transform within Liquid Studio or generate mapping code for use in your own application.
  • Step through debugger with breakpoints, stack trace, state and variable watch windows.
  • Generate mapping code in XSLT or C#.
  • Ideal for integrating with legacy systems.

CLICK TO VIEW VIDEO XML Data Mapper

Data Mapper Demonstration

How to create a mapping transform to convert XML data using the graphical drag and drop interface.

Example Data Transformation

Example Data Transformation

Liquid Studio Data Mapper provides an intuitive graphical interface for designing data transforms. The transforms can map multiple data input sources to multiple data output targets while performing conditional logic, filtering, string manipulation, statistical functions and much more

The transformations are ideal for converting legacy data to new data formats, or for inclusion as part of your data pipeline, transforming data between diverse, heterogeneous systems.

Each transform can be executed within the Liquid Studio environment and debugged by single stepping through them to display the internal state of the engine to be viewed, and path of execution.

The transform can also be executed within your own application by generating XSLT or C# source code.

Mapping data between different data formats

Support is provided for a wide range of data stores:

Data can be read and written between multiple different data sources and data targets.

Still not sure? Then try Liquid Studio Free Free Trial

Database Data Mapping

Database Table Selection Wizard
Database Table Selection Wizard

Database Filter Wizard
Database Filter Wizard

EDI Data Mapping

EDI Wizard
EDI Wizard - EDIFACT and X12 Standards

EDI Component
EDI Component

JSON Data Mapping

JSON Wizard
JSON Wizard

JSON Component
JSON Component

Text File Data Mapping

Text File Fixed Length Fields Wizard
Text File Fixed Length Fields Wizard

Text File CSV Wizard
Text File CSV Wizard

Web Service Data Mapping

Web Service Wizard
Web Service Wizard

SOAP Web Service Wizard
SOAP Web Service Wizard

RESTful Web Service Wizard
RESTful Web Service Wizard

XML Data Mapping

XML Wizard
XML Wizard

XML Writer Component Options
XML Writer Component Options

Data Mapper Component Palette

Data Sources and Targets:
  • Database, EDI, JSON, Text File, XML, Web Service
Transformation Components:
  •  Values
    • Constant Value
    • Input Parameter
  • Aggregate
    • Average
    • Count
    • Max
    • Min
    • Sum
  • Comparator
    • Equal
    • Greater Than
    • Greater Than or Equal
    • Less Than
    • Less Than or Equal
    • Not Equal
  • Date Time
    • Create Date
    • Create Date Time
    • Create Time
    • Day
    • Hour
    • Millisecond
    • Minute
    • Month
    • Now
    • Second
    • Today
    • Year
  • File
    • Combine Path
    • Get Directory Name
    • Get Extension
    • Get Filename
    • List Files
    • Resolve Path
  • Logic
    • And
    • False
    • Not
    • Or
    • True
  • Maths
    • Abs
    • Add
    • Divide
    • Is Even
    • Is Odd
    • Modulus
    • Multiply
    • Subtract
  • Misc
    • Annotation
    • Lookup
  • Set
    • Combine
    • Distinct
    • Filter
    • First
    • Get At
    • Last
    • Position
    • Sort
    • Top
  • String
    • Char To Code
    • Code To Char
    • Concat
    • Empty To Null
    • Index Of
    • Join String
    • Left
    • Length
    • Lower
    • Replace
    • Right
    • Split String
    • Sub String
    • Trim
    • Trim End
    • Trim Start
    • Upper
  • Type
    • Cast
    • Default If Null
    • Is Null
    • Node Name
    • Node Type

Like what you see? Try Liquid XML Free Free Trial

More XML Tools

FEATURE DETAILS

Graphical XML Schema Editor

Visualize and edit an abstracted view of your XML schema (XSD) using an intuitive user interface, and validate your XSD against the W3C standards.

FEATURE DETAILS Graphical WSDL Editor

Graphical WSDL Editor

Visualize and edit an abstracted view of your Web Service using an intuitive user interface, and validate your WSDL against the W3C standards.

FEATURE DETAILS XSLT Editor and Debugger

XSLT Editor and Debugger

Author, validate and debug your XSLT style sheet, set breakpoints within the XSLT source, watch variables and analyse the call stack.

FEATURE DETAILS XQuery Editor and Debugger

XQuery Editor and Debugger

Author, validate and debug your XQuery module or library, set breakpoints within the XSLT source, watch variables and analyse the call stack.