Imports data into Oracle ,SQL Server, ODBC Databases (Datawarehouses) from flat files, cross tables or ODBC datasources.

Very fast, reliable and easy to use. Uses native API (OCI API,BCP API,ODBC API) Capable of performing calculation during import, may also execute SQL statements before and after import.

Integrated expression builder, comprehensive error log, rejected records file. Source Data Filtering

Powerful ETL tool designed especially for none technical users. Very fast and reliable. Uses native API (OCI API, BCP API, ODBC API).

Here are some key features of "Visual Importer":

Transformations:
· Adding Records
· Updating Records
· Deleting Records
· Adding/Updating Records
Data Sources:
· Multiple Text Files
· Multiple Excel Files
· Multiple Tables
· Any ODBC Database
Target Databases:
· Oracle 7-9i databases
· MS Sql server 7- 2000
· Any ODBC Database
· Comprehensive log
· Rejected records file
· Integrated express�ons builder
· Mapping editor
· Sql scr�pts
· Data Preview
· Data Filtering

Limitations:

· 30 days trial
· Timed nag screen

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.