Visual Importer ETL comes in three editions - standard, professional and enterprise.
Standard edition is recommend for loading data without automation.
Professional is for development environment
Enterprise is designed for execution on servers
|
| ETL Features | |||
|---|---|---|---|---|
Data Sources |
 |
|
|
|
| Multiple Delimited Files |  |
|
|
|
| Multiple Fixed Width Files | |
|
|
|
| Multiple Pivot tables | |
|
|
|
| Multiple Excel Spreadsheets | |
|
|
|
| Multiple DBF Files | |
|
|
|
| Multiple MS Access Databases | |
|
|
|
| Multiple Source Files | |
|
|
|
| Multiple Source Tables | |
|
|
|
| Any ODBC Compliant Database | |
|
|
|
| MS SQL Server |
|
|
|
|
| Oracle Databases |
|
|
|
|
| MySql |
|
|
|
|
| PostgreSQL |
|
|
|
|
| Interbase/Firebird |
|
|
|
|
| SQLite | |
|
|
|
| OLE DB |
|
|
|
|
| XML | |
|
|
|
Data Targets |
||||
| Oracle Direct Path Loading | |
|
|
|
| ||||
| MS Sql Server | |
|
|
|
| MySql |
|
|
|
|
| PostgreSQL |
|
|
|
|
| Interbase/Firebird | |
|
|
|
| SQLite | |
|
|
|
| Any ODBC Compliant Database |
|
|
|
|
| OLE DB |
|
|
|
|
Transformations |
||||
| Adding Records | |
|
|
|
| Updating Records | |
|
|
|
| Deleting Records | |
|
|
|
| Adding new and Updating old Records | |
|
|
|
| Add new Records only |
|
|
|
|
| Conditional Loading | |
|
|
|
| User definable date formats |
|
|
|
|
| Transformation Functions | |
|
|
|
| Execution of Sql script Before the loading | |
|
|
|
| Execution of Sql script After the loading | |
|
|
|
| Poverful Data transformation language | |
|
|
|
Other usefull features |
||||
| Full support for unicode |
|
|
|
|
| Rejected Records File | |
|
|
|
| Transformation Log | |
|
|
|
| Command Line interface | |
|
|
|
| Data Preview | |
|
|
|
Repository |
||||
| MS Access | |
|
||
| MS Sql Server |
|
|
||
| Oracle | |
|
||
| MySql | |
|
||
| Interbase | |
|
||
| PostgreSQL | |
|
||
| Repository synchronization Wizard |
|
|
||
| Repository Backup |
|
|
||
| Repository Restore |
|
|
||
Advanced Objects |
||||
| Directories | |
|
||
| Connections | |
|
||
| Imports | |
|
||
| Import script creation wizard |
|
|
||
| Exports | |
|
||
| Sql Scripts | |
|
||
| Lookups | |
|
||
| Task Scheduler | |
|
||
| Execution Logging | |
|
||
| Packages | |
|
||
| Data Migration Wizard |
|
|
||
Packages |
||||
| Imports | |
|
||
| Exports | |
|
||
| Sql Scripts | |
|
||
| Check Files | |
|
||
| Compare Files (creation date, file size or MD5) | |
|
||
| File Operations (copy,delete,rename,etc) | |
|
||
| External applications | |
|
||
| Email Notifications | |
|
||
| Ftp operations Uploads, Downloads, Create Remote directory, Delete File | |
|
||
| Zip (zip and unzip) | |
|
||
| Pop 3 Email receiver | |
|
||
| SQL Data Check | |
|
||
| Show Message |
|
|
||
| Ask Question |
|
|
||
| HTTP Download | |
|
||
Execution Agent |
Runs as Windows service | |
||
 |
|
|
||
