Visual Importer loads data into ANY database from Text, Excel, MS Access, DBF files or any ODBC compliant database. It is easy to use and was designed especially for non technical users. 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).
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 scripts
· Data Preview
· Data Filtering
What's New
- Various bug fixes