Engineering and Enterprise Solutions

Information

DataPorter

Extract, Transform and Load your data for achieving easy data integration.

DataPorter allows you to simplify data transformation tasks:
  • Define and save mapping between source data and target data
  • Run via the user interface and command line.
  • Familiar Excel style formla language to map between source and target data

Salient features

Source

  • Variety of data sources available
  • Both structured and unstructured data sources
  • File and Server based data sources
  • Data source dependent connection properties
  • Automatic population of servers, databases and tables/views, where supported
  • Full featured query builder
  • Save source connection as a file to be used in other projects
  • Define source schema for unstructured data
  • Save Source schema for multiple use

Mapping

  • Excel like formula language
  • Comprehensive function library. Special functions for accessing source and target data
  • Full featured formula builder
  • Source and target data validation
  • Test Map Expression on-the-fly within map designer
  • Save Map file containing total transformation project information

Target

  • Variety of data sources available
  • Data source dependent connection properties
  • Rich target data connector properties to allow full control
  • Save target connection as a file to be used in other projects
  • Define target schema for unstructured data
  • Multiple data types for each field
  • Data Type dependent properties
  • Save target schema for multiple use

General

  • Data Browser
  • Transformation Validator
  • Run from Graphical user Interface or command line
DataPorter is available as part of ETOBench Pro and Maximprise Pro