Visual Importer Enterprise is a tool that combines Powerful features of Visual Importer and Visual Importer Professional plus Execution agent which can be run as a windows service.

Here are some key features of "Visual Importer Enterprise":

Transformations:
· Adding Records
· Updating Records
· Deleting Records
· Adding/Updating Records
Data targets:
· Oracle 7-10g database (using OCI API)
· SQL server 7- 2005 (using BCP API)
· ODBC source (using ODBC API)

Repository:
· MS Access
· Oracle
· MS Sql Server
· Interbase
· MySQL
· PostgreSQL

Also:
· Great performance - hundreds of records per second
· Comprehensive logging
· Rejected records file
· Integrated Expressions builder

Oracle:
· Oracle direct path loading
· Conventional path

MS SQL server:
· This software uses the same API as Microsoft DTS service.

ODBC:
· Any ODBC compliant database.

Other features are:
· Easy Repository switching
· Data Preview
· Mapping editor
· Exports
· SQL scripts editor
· Packages editor
· Integrated Scheduler
· Logging
· Lookups
· Email Notifications
· File Operations
· Check Files
· Compare Files
· FTP Downloads
· Applications
· Free hand SQL tool
· Integrated SQL builder

Requirements:

· MDAC 2.6 or higher
· SQL ODBC driver 2000.81.9041.40 Only for import data into MS Sql Server
· Microsoft Jet 4.0 Service pack 5 or higher For MS Access repository
· Oracle Client 7.3.4 or higher

Limitations:

· 30 days trial

What's New in This Release: [ read full changelog ]

· Added GetSystemVariable("OUTPUT_RECORDNUMBER")
· Aded new calculation function DateDiffS DecDateS(Date1,Format1, Date2,Format2,Type):String. Use DateDiffS to calculate Type difference between two dates.