 |
VisualETL |
|
| |
Fact Sheet
Features
- Supports
the most popular formats – dBase, FoxPro, MS Access, Text (Comma Delimited,
Tab Delimited, Fixed Length, Custom Delimited), Excel,
MS SQL, MySQL, HTML, XML and ODBC.
- Any
file format can be converted to any other file format.
- Easy
to use Drag-and-Drop interface – no programming required.
- Advanced
features for complex conversion jobs.
- Filter
or Query you data from a simple query builder window.
- Browse
window to view Source and Target Data.
- Pre-configure
and run transfer profiles.
- Batch
mode to run multiple transfer profiles.
- Save
transfer profiles to desktop shortcuts. Run transfer profiles
from these shortcuts or by command line.
- Color-coded
status log file automatically written.
- Automatically
execute a program or task before or after transfer.
- Overwrite
or Append data.
- Auto
Mapping feature.
- Delete
Source record after transfer in order to archive old records
to a history file.
- Ignore
Duplicate Records during transfer.
- Search
and Replace data during transfer.
- Start
with Position / End at Position - If you wish to work
with only a certain section of a field or extract specific
characters.
Many
Data Formatting options for use during transfer on a field-by-field
basis
- Sentence
Case, Title Case, Lower Case, Upper Case
- Concatenate
or merge fields
- Trim
Leading or Trailing Spaces
- Trim
or add leading zeros
- Format
Date fields
- Increment
to next available ID.
- Increment
ID starting with - You may specify any alphanumeric expression
to begin incrementing from.
- Explicitly
round a numeric field to a certain number of decimal places
Learn
More
>>
|
|
|