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