Visual Importer Professional 7.2.1

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-9i database (using OCI API)

SQL server 7- 2000 (using BCP API)

ODBC source (using ODBC API)

Data sources:

Text files

Any ODBC source

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

See also: ETL, Powerful ETL tool, Oracle, MS Sql server, BCP, sql loader, ODBC, ETL, Datawarehouse, Repository: MS Access, Oracle, MS Sql Server, Interbase, MySql, PostgreSQL