Download Visual Importer Professional by DB Software Laboratory
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...