| |||||
This Wizard helps you to load and export data from/into various data sources such as delimited and fixed width files or ODBC data source into/from Oracle, MS SQL Server or any ODBC compliant database
Data Exchange Wizard uses native API and performs calculation during import, executes SQL statements before and after Import or Export .
Integrated expression builder, comprehensive error log, rejected records file.
Here are some key features of "Data Exchange Wizard":
Transformations:
· Adding Records
· Updating Records
· Deleting Records
· Adding/Updating Records
Data Sources:
· Multiple Text Files
· Multiple Excel Files
· Multiple Tables
· Any ODBC Database
Target Databases:
· Oracle 7-10g databases
· MS Sql server 7- 2005
· Any ODBC Database
Also:
· Comprehensive logging
· Rejected records file
· Integrated expressions builder
· Mapping editor
· Sql scripts
· Data Preview
· Data Filtering
· Integrated Sql Builder
Requirements:
· MDAC 2.6 or higher
· SQL ODBC Driver
· Oracle Client 7.3.4 or higher
· 20 meg disk space
Limitations:
· 30 days trial
· Nag screen
What's New in This Release: [ read full changelog ]
· Support for RSS, Windows Event Log, Go ogle Spreadsheets, SalesForce, BrightPearl and QlikView was introduced
· Various bugs fixes

Via: Data Exchange Wizard 4.1.0.0