Including extraction, transformation, and load (ETL) packages for data warehousing and business automation. Visual Importer ETL Enterprise includes graphical tools and wizards for building and debugging automation packages; Actions for performing work-flow functions such as FTP operations, executing SQL statements, and file manipulations; data sources and destinations for extracting and loading data; Unlike DTS, SSIS and Oracle Warehouse builder, Visual Importer ETL Enterprise can send and receive emails and process attachments as well. By combining simple ETL Package Actions together Visual Importer ETL Enterprise helps businesses and Fortune 100 companies to automate complicated business processes and everyday tasks.

User can design Import, Export and SQL scripts, add them to the Package and schedule it for execution on regular basis. Unlike DTS, SSIS and Oracle Warehouse builder Visual Importer ETL Professional can receive emails and process attachments as well. All FTP operations also supported. By combining simple Package Items together Visual Importer ETL Professional helps small businesses and Fortune 100 companies to automate complicated business processes and everyday tasks.

Import data into any database
Export all data from the database
Run SQL scripts
Compress and decompress files
Compare files using MD5 and size
Copy, move, rename and delete files
Upload and download files
Receive and process Emails
Send Emails
and much more...

Load Data From:

Multiple Delimited or Fixed width Text files
Multiple Excel files + Multiple Excel Spreadsheets
Multiple MS Access Databases + Multiple Tables
Multiple DBF Files
Multiple Tables
MS Sql Server
MS Sql Server CE
Oracle Database
MySQL
PostgreSQL
Interbase/Firebird
SQLite
OleDB
RSS Feed
Any ODBC Database
Any JDBC Database
QlikView QVX and QVD Files
SalesForce
BighPearl
Windows Event Log

And:

Add Records
Update Records
Delete Records
Add New and Update existing Records
Apply Functions to Database Fields
Apply user defined Date format
Run Sql script before and after loading data
Run calculations during import
Filter Source Data
Use Select Statement as a Data Source
Data Preview
Run import script from command line

Into:

Oracle 7-11g database
SQL server 7-2008
MySQL
PostgreSQL
Interbase/Firebird
SQLite
OleDB
Any ODBC Compliant Database

Only for V.I.P