INTRODUCTION
Visual Importer ActiveX loads data into any database. It is the only product on the market with such a wide support for databases. It uses native API for all of them which give the user great performance – thousands of records per second.
Data targets:
- Oracle 7-11g database (using OCI API)
- SQL server 7- 2012 (using BCP API)
- SQL server CE
- ODBC source (using ODBC API)
- Interbase/Firebird
- MySQL
- PostgreSQL
- SQLite
- OleDB
Data sources:
- Multiple Delimited or Fixed width Text files
- Multiple Excel files + Multiple Excel Spreadsheets
- Multiple MS Access Databases + Multiple Tables
- Multiple DBF Files
- QlikView QVX/QVD files
- Multiple Tables
- Oracle 7-11g database
- MS SQL Server
- ODBC source
- Interbase/Firebird
- MySQL
- PostgreSQL
- SQLite
- Ole DB
- XML
- Windows Event log
- Google Spreadsheets
- SalesForce
- BrightPearl
Most of commercial applications work with the databases. One of the standard requirements is the ability to load data from external sources such as flat files or ODBC sources. In fact it is one of the most complicated parts of the application.
The issue becomes even more difficult if the software should work with different databases. Import routine one of the major component of any software package. Visual Importer ActiveX allows cutting the time of development by months.
Creating an Import routine requires a deep knowledge of databases API and it is next to impossible to find an expert with the experience of working with several databases.
By integrating one of DB Software Laboratory ActiveX components 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.