Easy to use, fast and powerful ETL tools, Our prices start from only 100 USD per licence.

Work with: Text, XML, Excel, Access, DBF, Foxpro, ODBC, OLE DB, MS Sql Server, Oracle, MySql, PostgreSQL, Firebird, Interbase, SQLite, POP3, SMTP, File System, FTP, SSL, Unicode, RSS, Windows Event Log, Google Spreadsheets and QlikView.

Built-in scheduler, business rules designer, package designer, report designer, data browser. Powerful data transformation language, regular expressions and more...

HomeProductsVImp XWhat is it for

VImpX - What is it for

What are ActiveX and ActiveX controls?

ActiveX controls are small program building blocks that can be used to extend the functionality of existing applications.

The ActiveX programming specification is an extension of Microsoft Windows and the Object Linking and Embedding (OLE) API.

If you have a Windows operating system on your personal computer, you may notice a number of Windows files with the "OCX" file name suffix. OCX stands for "Object Linking and Embedding control." Object Linking and Embedding (OLE) was Microsoft's program technology for supporting compound documents such as the Windows desktop. The Component Object Model now takes in OLE as part of a larger concept. Microsoft now uses the term "ActiveX control" instead of "OCX" for the component object.

One of the main advantages of a component is that it can be re-used by many applications (referred to as component containers). A COM component object (ActiveX control) can be created using one of several languages or development tools, including C++ and Visual Basic, or PowerBuilder, or with scripting tools such as VBScript.

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.

"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.

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: Data transformation and validation
  • 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
  • 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

DownloadBuy Now

 

Testimonials

We were able to validate more data in less time when we started using Advanced ETL Processor

N.Chad
IT Manager

Our customers

BP

BBC

HSBC


Databases we work with

Go to top