DataMapper 2008 Feature Comparison

DataMapper 2008 is offered in two editions: Standard and Professional.  Both versions offer superior performance and value compared with competitive solutions.  Both offer a wealth of features, from visual data mapping and data previews to multiple file and database support including the built in query editor.  The Standard edition was designed to get your data from "point A" to "point B" quickly and efficiently.  The Professional version adds to that philosophy the ability to schedule data transfers and run them in batches.   Please use the matrix below to identify which version suits your needs best.  An upgrade is available for purchase if you have the Standard edition. 

Back to DataMapper 2008 overview.

Data Mapping
Feature	Standard	Professional
Drag-and-Drop Field to Field Mapping
Automatic Mapping of similarly named fields
Automatic Creation of Lookup List from Source
Database Lookup Mapping
Mapping Expressions
Powerful Rules language to define complex mapping
Large built-in function library
Ability to add custom functions
Mapping expression editor with syntax highlighting and autocompletion
Add comments to source fields, destination fields, and mapping
Export mapping details to Excel
Regular expression transformations

Data Preview
Feature	Standard	Professional
Preview source and destination data while building maps
Preview field level data to debug individual mapping

Data Profile for aggregate level statistics
Feature	Standard	Professional
Record count
Field average, minimum, and maximum
Field level errors and warnings
Null value count

Data Transfer
Feature	Standard	Professional
High-speed multi-threaded transfer engine
Run multiple transfers simultaneously
Detailed Data Profile and error information
Continue your work while transfers are running
Detailed transfer progress information
Run transfer from command line
Schedule transfers

Scheduler
Feature	Standard	Professional
Schedule transfer jobs for single transfer or transfer group
Schedule frequencies
Run Once
Hourly
Daily (every day, every n days)
Weekly (weekdays, specific weekdays)
Monthly (specific days of month, specific weekdays of month)
Scheduler log viewer
Initiate transfer jobs on file-drops

Transfer Batch (a group of transfers)
Feature	Standard	Professional
Build and group  transfers
Sequence transfers within groups
Run entire group or individual transfers
Save batch for later use
Quickly modify if the underlying data tables or files change

Database Migration Batch
Feature	Standard	Professional
Copy data between all supported databases
Create a new table or insert to an existing table
High fidelity data type conversion
Complex data mapping
Support for all data types including binary and blob data
Run immediately or schedule
Save for later use

Databases
Feature	Standard	Professional
Automatically determine database layout
High-fidelity data conversion when moving between databases
Create a new tables or update existing tables
Transfer data and schema between supported databases at high speeds
Create transfer batches for moving data between databases
Schedule individual or batch transfers
Support for SQL Server, Oracle, DB2, Sybase, MySQL, and Access
Export data tables, views, or query results
Build, save, run, or schedule data migration batches
Update existing records in database
Conditionally update or skip records in database
Database transaction management
Preserve or regenerate system generated keys (identity columns)
Transfer binary and blob data between different databases

Files
Feature	Standard	Professional
Automatically determine data types and sizes for fields
Delimited, fixed length, and Excel files
Over 100 encodings including ASCII, EBCDIC, and Unicode
Read from and write to specific Excel worksheets within an Excel File
Filter raw data records using  regular expressions
Multi-row header support
Filter source record using rules expression
Format output data to your exact specification

Database Browser
Feature	Standard	Professional
Tree based view of database tables and views
Delete or modify tables
Import data from files or other databases
Export data to files or other databases
Generate DDL and DML scripts

Query Editor
Feature	Standard	Professional
Build and execute queries on all supported databases
Full featured query editor with syntax highlighting and autocompletion
SQL snippets to facilitate common tasks

Back to DataMapper 2008 overview.