Visual Importer Professional

Powerful ETL tool. Imports data into Oracle ,SQL Server, ODBC Databases (Datawarehouses) from flat files or ODBC datasources.
Very fast and reliable. Uses naitive API.

Data targets:
Oracle 7-10g database (using OCI API)
SQL server 7- 2005 (using BCP API)
ODBC source (using ODBC API)

Data sources:
Multiple Delimited or Fixed width Text files
Multiple Excel files + Multiple Excel Spreadsheets
Multiple MS Access Databases
Multiple DBF Files
Any ODBC source
Multiple Tables

Repository:
MS Access
Oracle
MS Sql Server
Interbase
MySQL
PostgreSQL

This product features:
Great performance - hundreds of records per second
Comprehensive logging
Rejected records file
Integrated Expressions builder

Allows the user to perform calculation during the loading process such as splitting fields, concatenations, data formatting, and loading cross/pivot tables.

Oracle

There are two ways of loading available:

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

Download NOW! (Size: 8.39 MB)