VImpX
| | ActiveX which bulk loads data into Oracle, SQL Server, PostgreSQL, MySQL, Interbase or Firebird and ODBC Databases from the flat files, Excel, DBF, MS Access Databases, pivot tables, Oracle, SQL Server, PostgreSQL, MySQL, Interbase/Firebird or any ODBC data source.
Very fast and highly customisable. Capable of performing calculations during import, may also execute SQL statements before and after import.
Integrated expression builder, comprehensive error log, data preview, rejected records file. Read Product Documentation (PDF), download a Free Trial or get the latest version today from only $400.
Backed up by Free, Fast, Unparalleled Support
| What one should use VImpX for? |
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 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.
| 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 Visual Importer 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: Into: | It can: | If something went wrong VImpX writes detailed message into error log and writes a record into rejected records file. | VimpX screenshots
| Click on thumbnail to see the screenshot
| Related Products | Visual Importer Professional is an automation tool. User can design Import, Export and SQL scripts, add them to the Package and schedule it for execution on regular basis. Visual Importer Enterprise is an ETL tool designed to automate database loading process. Typical usage of it would be download files from FTP Server, load them into the database, run stored procedure or Sql script and send email to administrator once package is completed. Visual Importer Enterprise includes execution agent which can be run as a Windows service. Advanced ETL Processor is designed to automate extracting data from ANY database, transform, validate it and load into ANY database . Typical usage of it would be extract data from Excel File,Validate Date Formats, Sort data, deduplicate it and load it into Oracle database, run stored procedure or Sql script, once loading is completed. Unlike Oracle SQL loader, BCP, DTS or SSIS Advanced ETL Processor can also add new and update old records based on primary key |
|
