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.

Try Liquid XML Free and see how we can help you today Download Trial

Database Data Mapping

The Liquid Data Mapper is a flexible data transformation and mapping tool. Data reader and writer components for SQL Server, Oracle, MySQL, JSON, CSV, Web Services and XML provide the power and flexibility to produce any combination of mapping, even combining data from multiple sources.


Database Reader

Once added, the Database reader can be expanded to access tables with constraints/relationships defined within the database.

The Database reader supports SQL Server, Oracle, MySQL, Access and ODBC data sources, simply use the wizard to connect to your data source. The database schema structure is then represented hierarchical in the data mapper using the relationships and constraints defined within the database. Standard components allow the database results to be sorted, filtered, grouped, aggregated etc.

Supported Operations

Once an data writer is connected (SQL Server, Oracle, MySQL, JSON, CSV, Web Services or XML), it is possible to start graphically building the transform, dragging data from the source to the target.

  • Database to JSON
  • Database to EDI
  • Database to CSV
  • Database to Web Services
  • Database to XML

Wizard

A simple wizard is used to add the Database reader to the transform. The wizard makes it possible to select a data source and then select the data table or view to be used within the transform.


Database Writer

Once added, the Database writer reads its structure from the database schema, representing related tables as child items along with there appropriate cardinality.

The Database writer supports SQL Server, Oracle, MySQL, Access and ODBC data sources, simply use the wizard to connect to your data source. The database schema structure is then represented hierarchical in the data mapper using the relationships and constraints defined within the database.

Supported Operations

  • Database to Database
  • JSON to Database
  • CSV to Database
  • EDI to Database
  • Web Services to Database
  • XML to Database

Wizard

A simple wizard is used to add the Database writer to the transform. The wizard makes it possible to select a data source and then select the data table or view to be used within the transform.

EDI Data Mapping

The Liquid Data Mapper is a flexible data transformation and mapping tool. Data reader and writer components for SQL Server, Oracle, MySQL, JSON, CSV, Web Services and XML provide the power and flexibility to produce any combination of mapping, even combining data from multiple sources.


EDI Reader

Once added, the EDI reader can be expanded to access the data within the EDI specification selected.

The EDI reader supports EDIFACT and X12 standards, simply select the appropriate EDI specification using the intuitive wizard, and the EDI document is represented in the data mapper as a hierarchical data source. Standard components allow the EDI data to be sorted, filtered, grouped and aggregated

Supported Operations

Once a data writer is connected (SQL Server, Oracle, MySQL, JSON, CSV, Web Services or XML), it is possible to start graphically building the transform, dragging data from the source to the target.

  • EDI to SQL Server
  • EDI to Oracle
  • EDI to MySQL
  • EDI to JSON
  • EDI to CSV
  • EDI to Web Services
  • EDI to XML

Wizard

A simple wizard is used to add the EDI reader to the transform. The EDI specification can then be selected from a list, and any non-standard separators, indicators and terminators can be configured.


EDI Writer

Once added, the EDI writer can be expanded to access the hierarchy of the EDI specification selected.

The EDI reader supports EDIFACT and X12 standards, simply select the appropriate EDI specification using the intuitive wizard, and the EDI target is represented in the data mapper as a hierarchical data target. Connections made to the inputs on the writer will cause data to be copied to the target EDI file.

Supported Operations

  • SQL Server to EDI
  • Oracle to EDI
  • MySQL to EDI
  • JSON to EDI
  • CSV to EDI
  • Web Services to EDI
  • XML to EDI

Wizard

A simple wizard is used to add the EDI writer to the transform. The EDI standard can be selected, as well as providing the ability to configure non-standard separators, indicators and terminators.

Simplifies Development & Reduces Bugs Free Trial

JSON Data Mapping

The Liquid Data Mapper is a flexible data transformation and mapping tool. Data reader and writer components for SQL Server, Oracle, MySQL, JSON, CSV, Web Services and XML provide the power and flexibility to produce any combination of mapping, even combining data from multiple sources.


JSON Reader

Once added, the JSON reader can be expanded to access the data specified in the associated JSON Schema.

The JSON data mapper component requires a JSON Schema to describe the data being read. If you do not have a schema then one can be inferred from sample JSON documents.

The JSON reader supports the Internet Engineering Task Force draft 4.0 JSON Schema Standard.

The JSON source document is represented in the data mapper as a hierarchical data source. Standard components allow the JSON data to be sorted, filtered, grouped and aggregated

Supported Operations

Once a data writer is connected (SQL Server, Oracle, MySQL, JSON, CSV, Web Services or XML), it is possible to start graphically building the transform, dragging data from the source to the target.

  • JSON to SQL Server
  • JSON to Oracle
  • JSON to MySQL
  • JSON to EDI
  • JSON to JSON
  • JSON to CSV
  • JSON to Web Services
  • JSON to XML

Wizard

A simple wizard is used to add the JSON reader to the transform, you need to specify the JSON schema that describes your data. If you don't have a schema file, then you can infer one from sample JSON data using the JSON Schema Inferring tool. You also need to specify the location where the JSON data will be read from when the transform is executed.


JSON Writer

Once added, the JSON writer can be expanded to access the data described in the associated JSON Schema.

The JSON data mapper component requires a JSON Schema to describe the data being written. If you do not have a schema then one can be inferred from sample JSON documents.

The JSON writer supports the Internet Engineering Task Force draft 4.0 JSON Schema Standard.

Supported Operations

  • SQL Server to JSON
  • Oracle to JSON
  • MySQL to JSON
  • EDI to JSON
  • JSON to JSON
  • CSV to JSON
  • Web Services to JSON
  • XML to JSON

Wizard

A simple wizard is used to add the JSON writer to the transform, you need to specify the JSON schema that describes your data. If you don't have a schema file, then you can infer one from sample JSON data using the JSON Schema Inferring tool. You can also specify a location where the JSON data will be written to when the transform is executed.

Try all the features of Liquid Studio Download Free Trial Now

Text File Data Mapping

All the Tools You Need for Designing and Developing XML Schemas Free Trial

Web Service Data Mapping

Still not sure? Then try Liquid Studio Free Download Free Trial

XML Data Mapping

Like what you see? Try Liquid Studio Free Free Trial

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
    • Group By
    • 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

Try Liquid Studio and see how we can help you today Free Trial

More Editors and Tools

FEATURE DETAILS Graphical XML Editor

Graphical XML Editor

FEATURE DETAILS Graphical WSDL Editor

Graphical WSDL Editor

FEATURE DETAILS XPath Tools

XPath Tools

FEATURE DETAILS XQuery Editor and Debugger

XQuery Editor and Debugger