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:

  1. Oracle 7-11g database (using OCI API)
  2. SQL server 7- 2012 (using BCP API)
  3. SQL server CE
  4. ODBC source (using ODBC API)
  5. Interbase/Firebird
  6. MySQL
  7. PostgreSQL
  8. SQLite
  9. OleDB

Data sources:

  1. Multiple Delimited or Fixed width Text files
  2. Multiple Excel files + Multiple Excel Spreadsheets
  3. Multiple MS Access Databases + Multiple Tables
  4. Multiple DBF Files
  5. QlikView QVX/QVD files
  6. Multiple Tables
  7. Oracle 7-11g database
  8. MS SQL Server
  9. ODBC source
  10. Interbase/Firebird
  11. MySQL
  12. PostgreSQL
  13. SQLite
  14. Ole DB
  15. XML
  16. Windows Event log
  17. Google Spreadsheets
  18. SalesForce
  19. 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.

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL Forum

  • vimpx/introduction.txt
  • Last modified: 17/09/2018 09:52
  • by admin