DEWizardX 3.6.1.1

DEWizardX 3.6.1.1 offers a powerful tool to load and export data from/into various datasources such as delimited and fixed width files or ODBC data source into/from Oracle, MS SQL Server or any ODBC compliant database

Uses naitive API, Capable of performing calculation during import, may also execute SQL statements before and after Import or Export .

Integrated expression builder, comprehensive error log, rejected records file. Source Data Filtering

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 and Any ODBC Database into Oracle 7-11g database, SQL server 7-2008, Any ODBC Compliant Database 

Enhancements:

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