|
Astera DataMapper 2008 – Powerfully Simple!
Astera DataMapper is a professional data transformation tool designed to facilitate movement of
data between databases and files at blazing speeds.
You can quickly create simple and complex transformations, from an intuitive interface,
in just a few clicks.
With a high degree of automation coupled with intelligent defaults,
DataMapper quickly
becomes a smart and perceptive partner
for your data transformation tasks.
DataMapper now comes in two editions, Standard and Professional. Both offer
superior performance at an incomparable value. Compare the two and
see which edition is right for you.
Key features
- Source types include files, databases and SQL Query. Destination types include files and databases.
- Build maps using the interactive drag-and-drop mapping and AutoMap features. Use lookups and expressions for more involved mappings.
- Data Preview feature helps you validate and fix mappings before running transfer while Data Profiling feature provides an aggregate overview of your data.
- Data Migration Batch helps you define multi-table data transfers between databases.
- Multi-threaded data transfer engine supports high-speed data movement between all supported databases and file formats.
- Schedule transfer for one-time, hourly, daily, weekly, or monthly runs.
- File types include delimited, fixed length, and Excel. Capability to process files in over a hundred languages and encodings.
- Transfer Batch helps you create a collection of transfers and run them sequentially.
- A full-featured query tool provides a consistent interface across all the supported databases.
- A full-featured query tool provides a consistent interface across all the supported databases
- Query editor with syntax highlighting, unlimited undo/redo, and printing capability.
- Supports SQL Server, Oracle, DB2, Sybase, MySQL, and Access databases.
How DataMapper Works
Interactive Data Mapping
Click to view a larger screenshot.
- Graphical drag-and-drop mapping
- Direct mapping, list and database lookups, and expressions
- Excel-Style expression language for defining more complex data mapping featuring over a hundred built-in functions
- Ability to quickly add custom functions
- Expression editor with syntax highlighting and autocompletion
- SmartMap feature enables automatic mapping based on weak field name match
- Automatically build lookup list from source data
Click to view a larger screenshot.
Data Preview
- Instantly preview source and destination data while mapping
- Preview detailed field level information including side-by-side
view of destination value and corresponding source field values
Click to view a larger screenshot.
Data Profile
- Data Profile feature shows information about source and destination data.
Profile information includes:
- Detailed record and field level error information
- Aggregate information for each field in source and destination. This includes minimum, maximums, null values, invalid values, and other information
Database Migration Batch
- Migrate data at high-speed among all supported databases
- Filter source data using SQL where clause
- Where needed, transform data using standard mapping features
- High-fidelity data type conversion
- Schedule database migration batches to run once or on a recurring basis
- Control over database writes including ability to update existing rows
Transfer Batch
Click to view a larger screenshot.
- Use Transfer Batch to build and run a group of interdependent transfers
- Any combination of supported sources and destinations can be used
- Run batch immediately or schedule it for single or recurring execution
Scheduled/Automatic Transfer Execution
Click to view a larger screenshot.
- You can schedule transfer to run once, hourly, daily, weekly, or monthly
- You can also set transfer tasks to trigger based on file-drops
Databases
- Control over inserting data or updating existing rows. Ability to conditionally update existing rows in database.
- Database transaction management capability
- High speed transformation engine designed to efficiently process very large data volumes
- Bulk inserts and batch updates ensure efficient database operations
- Copy to existing tables or create new tables
Delimited, Fixed Width, and Excel Files
Click to view a larger screenshot.
- Smart file parser scans files to automatically detect data types and sizes.
- Read data from and write data to Excel worksheets, delimited files, and fixed length files.
- Support for Unicode and an extensive array of international character sets.
- Ability to process multi-row headers and skipping records based on regular expression matches.
Feature Rich Query Tool
Click to view a larger screenshot.
- Professional grade query editor with syntax highlighting, unlimited undo/redo, split pane, and other features
- Database browser provides an overview of tables in any database
- Execute and view query results
- View table schema, generate DDL and DML scripts, perform common database management functions
- Visual studio style snippets for common SQL commands
- Export query results to:
- Excel worksheets
- Delimited Files
Fast Deployment
- Install in a few minutes and connect to any supported database
- Product includes built-in drivers for SQL Server, Oracle, DB2, Sybase, MySQL, and Access.
No need to install database vendors’ client libraries.
Click to view a larger screenshot.
|
|