VImpX - ETL ActiveX

This is a software component that makes data import and export of data from different sources quite easy.

You need ability to export and import data quite often to support other functionality in your applications. Developers need to fiddle with low level APIs specific to the data source to get this data import/export implemented. The component gives you the ability to handle not only the different data sources but different formats of data files. Most mainstream data sources, such as Oracle, MS SQL Server, MySQL, Interbase, Firebird, PostgreSQL, ODBC, Ole DB, plus full support for flat files, MS Excel, MS Access and DB files. You are able to implement conversion facilities between these formats too. Integrated expression builders help you find the right sections of data from each type of source. SQL script support also adds to the flexibility of locating proper data.

Calculations during loading process, cross tables loading and the required mapping function to implement that, are all available with the component. To ensure that the data transfer process is flawless, error logs help support debug when problems do occur. The rejected records file also is able to give you clues as to why there are problems with the data loading or conversion process. The application provides an interface to the end user that is quite intuitive to use. However, you must be aware of what`s involved when data needs importing/exporting. Without this familiarity you may not be able to choose the optimum settings for a given situation. Wherever you need to add data import and/or export capability, here is a component that is worth investigating.

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.