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.
|
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 |
|
|
|
Preview source and destination data while building maps |
|
|
|
Preview field level data to debug individual mapping |
|
|
|
Record count |
|
|
|
Field average, minimum, and maximum |
|
|
|
Field level errors and warnings |
|
|
|
Null value count |
|
|
|
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 |
|
|
|
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 |
|
|
|
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 |
|
|
|
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 |
|
|
|
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 |
|
|
|
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 |
|
|
|
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 |
|
|
|
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.