Introduction

Data Exchange Wizard ActiveX loads and exports data into/from 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 gives the user great performance – thousands of records per second.

  • Oracle 7-12g database (using OCI API)
  • SQL server 7- 2014 (using BCP API)
  • SQL server CE
  • ODBC source (using ODBC API)
  • Interbase/Firebird
  • MySQL
  • PostgreSQL
  • SQLite
  • OleDB
  • 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. Data Exchange Wizard 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 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

  • dewizardx/introduction.txt
  • Last modified: 17/09/2018 09:44
  • by admin