VImpX 4.9.1.6

VImpX 4.9.1.6 is a powerful tool to load data into Oracle,SQL Server,ODBC from flat files, pivot tables, ODBC data sources, MS SQL Server and Oracle. Thousands of records per second plus full support for unicode. Capable of performing calculation during import, may also execute SQL statemts before and after import.

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

Integrated expression builder, comprehensive error log, rejected records file.

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.

Major Features:

1. Add Records
2. Update Records
3. Delete Records
4. Add New and Update existing Records
5. Apply Functions to Database Fileds
6. Apply user defined Date format
7. Run Sql script before and after loading data
8. Run calculations during import
9. Filter Source Data
10. Use Select Statement as a Data Source
11. Run import script from command line
12. Load Data From: 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 and any ODBC Database into Oracle 7-11g database, SQL server 7-2008 and Any ODBC Compliant Database

• Up to 7 times faster ETL Transformation and data loading
• Thousands of records per second
• Full Support for Unicode
• Better integration for Oracle databases

Requirements:Win 98 - Win 2003

 WareSeeker Editor