Visual Importer Professional imports data into Oracle, SQL Server, ODBC Databases (Datawarehouses) from flat files or ODBC datasources.
Very fast and reliable. Uses native API.
In case of errors, VI writes a detailed message into the log and writes a record into the rejected records file.
Here are some key features of "Visual Importer Professional":
· 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
· Great performance - hundreds of records per second
· Comprehensive logging
· Rejected records file
· Integrated Expressions builder
Limitations:
· 30-day trial period
· Nag screen
What's New in This Release: [ read full changelog ]
· Added GetSystemVariable("OUTPUT_RECORDNUMBER")
· Added new calculation function DateDiffS DecDateS(Date1,Format1, Date2,Format2,Type):String. Use DateDiffS to calculate Type difference between two dates.