Visual Importer Enterprise 7.7.2.1

Simply create a dedicated email account, design a package and that?s it - start processing data! Visual Importer Enterprise loads data from multiple delimited or fixed width text files, multiple Excel files and Excel spreadsheets, multiple MS Access databases and tables, multiple DBF files, multiple tables, MS SQL Server and any ODBC compliant database. The program can load data into Oracle 7-10g database, SQL server 7- 2005, any ODBC compliant database.

Every package execution is logged. In case of errors, Visual Importer writes a detailed message into the log and writes a record into the rejected records file. The Enterprise version includes execution agent which can be run as a Windows service.

1. Add Records
   
2. Update Records
   
3. Delete Records
   
4. Add New and Update existing Records
   
5. Apply Functions to Database Fileds
   
6. Apply user defined Date format
   
7. Run calculations during import
   
8. Run Sql script before and after loading data
   
9. Filter Source Data
   
10. Use Select Statement as a Data Source
    
11. Export Data from any database
    
12. FTP Downloads and Uploads
    
13. Create or Delete directories on FTP server
    
14. Rename or delete files on FTP server
    
15. Send Emails with attachments
    
16. Receive Emails with attachments
    
17. Save attachmets
    
18. Compress files
    
19. Decomress zip files
    
20. Copy, move, rename, merge, delete files
    
21. Compare files using MD5, size or creation  date
    
22. Check if file exist
    
23. Shedule packages for execution
    
24. Run bat files or execute any windows application
    
25. Edit and run SQL Scripts
    
26. Execute Packages from the command line
    

Enhancements:

• Up to 7 times faster ETL Transformation Thousands of records per second ETL Calculationsnow provide Full Support for Unicode.
• Log file format is utf8 Rejected file is in utf8 Table browser help you to chose the table
• Various bug fixes