VImpX

Every application has to be able to import data.

You can write your own or use VImpX

The ability to export and import data is one of major function of any modern software package. To make it fast the developers should use low level API specific for the database. Plus, it is always necessary to be able to import data from various database types and file formats.

Visual Importer ActiveX works directly with Oracle, MS SQL Server, MySQL, Interbase, Firebird, PostgreSQL, ODBC, Ole DB, plus full support for flat files, MS Excel, MS Access and DB files

- Easily extract and transform data from one database or file to another;
- Ultra-fast processing of data;
- Comprehensive Error log;
- Rejected records file;
- Integrated Expressions builder;
- Calculations during loading process;
- Cross tables loading;
- Mapping editor;
- SQL scripts support.

'It practically impossible, to find an expert with deep knowledge of low level API for all databases available on the market today'
By integrating one of DB Software Laboratory ActiveX into your own application you can quickly introduce fully functional universal import routine and cut the time and the cost required for the development of your own.

Features
• Thousands of records per second
• Highly customisable user interface
• Load data from files or tables
• Execute SQL statements before and after import
• Integrated expression builder
• Comprehensive error log
• Data preview
• Rejected records file

What Can VImpX Do?

VImpX gives your application the ability to load data from ANY database or file.
Typical usage of it would be truncate table, load data into it, run stored procedure or Sql script, once loading is completed. Unlike Oracle SQL loader, BCP, DTS or SSIS VImpX can also add new and update old records based on primary key.

Some examples of what our customers use this ActiveX for include:

Load Data From:
• Multiple Delimited or Fixed width Text files
• Multiple Excel files + Multiple Excel Spreadsheets
• Multiple MS Access Databases + Multiple Tables
• Multiple DBF Files
• Multiple Tables
• MS Sql Server
• Oracle Database
• PostgreSQL
• MySQL
• Interbase or Firebird
• OleDB
• Any ODBC Database
• XML
• SQLite
• SQL Server CE
• QVX Files

Into:
• Oracle
• MS SQL Server
• PostgreSQL
• MySQL
• Interbase or Firebird
• OleDB
• SQLite
• SQL Server CE

Data transformation and validation
• Any ODBC Compliant Database
• Add Records
• Update Records
• Delete Records
• Add New and Update existing Records
• Apply Functions to Database Fields
• Apply user defined Date format
• Run Sql script before and after loading data
• Run calculations during import
• Filter Source Data
• Use Select Statement as a Data Source