Visual Importer 4.9.2.3

1. Processing Speed
   • Using Visual Importer ETL Standard version 4.9.1.4, you can load a delimited text file into
   • MS SQL Sever via BCP 500000 lines in... 34 seconds!
2. Compatibility and Versatility
   • Processing speed is important, but it's not much use if you have to fiddle around with your data to get it into the right format.
   • 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
     • Oracle Database
     • Any ODBC Database
   • Into:
   • • Oracle 7-11g database
     • SQL server 7- 2008
     • Any ODBC Compliant Database
       
     • Visual Importer simple ETL tool
   • And...
   • • The latest version now allows you to load data from Utf8, Utf16BE, Utf16LE files with or without BOM.
     • There is full support for international characters for ODBC connections, MS SQL Servers and Oracle databases.
     • Unlike Oracle SQL loader, BCP, DTS or SSIS Visual Importer ETL can also add new and update old records based on user defined key.
3. Ease Of Use: Because Visual Importer ETL was especially designed for non technical users, it can be picked up in as little as 10 minutes...

1. Easily extract and transform data from one database or file to another
2. Ultra-fast processing of input data
3. Comprehensive Error log
4. Integrated Expressions builder with wide range of functions
5. Calculations during loading process
6. User definable Date formats
7. Several ways to Filter Source Data
8. Rejected records file
9. Pivot tables loading
10. Mapping editor
11. Command line interface
12. Custom Sql script execution before and after loading the data
13. SQL Select statement as a datasource
14. Mask for tables and files to load

Enhancements:

• ODBC Connection String Builder was introduced I
• mproved support for NonStop ODBC/MX 2.0 ver 3.51.20.126
• ODBC Driver Various Cosmetic Changes and Bug Fixes

Requirements: Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003