Data Exchange Wizard Loads or export data from / into ANY database. Full support for Excel, Access, DBF and Text files, XML, Oracle, MS SQL Server, Interbase / Firebird, MySQL, PostgreSQL, OleDB, SQLite, MS SQL Server Compact and ODBC compliant databases
Version: 220.127.116.11Data Exchange Wizard Loads or export data from / into ANY database.
License: Free To Try $130.00
Operating System: Windows
Full support for Excel, Access, DBF and Text files, XML, Oracle, MS SQL Server, Interbase / Firebird, MySQL, PostgreSQL, OleDB, SQLite, MS SQL Server Compact or ANY ODBC compliant database. Great performance - Thousands of records per second. Easy to use and learn
Data Exchange Wizard may run calculations during import and may also execute SQL statements before and after import.
The unique ability to add new and update old records based on the primary key distinguishes Data Exchange Wizard from many other competitors, such as Oracle SQL loader, BCP, DTS or SSIS. The other benefits of the product include a built-in expression builder, error log, and rejected records file.
The tool is typically used to truncate a table, load data into it and then run stored procedure or SQL script.
Many businesses need to centralize data to improve corporate decision-making. But their data may be stored in a variety of formats and in different locations.
Data Exchange Wizard addresses this critical business need by providing ETL tool that let you load and consolidate data from disparate sources into single destination.
Version 18.104.22.168: + Add refresh databases button to source and target connections + Added support for Unicode in server, database and table names + ODBC error messages support Unicode now + Added processor info to application title + Lots of small changes and fixes - Expanded red box size in the status bar
Version 22.214.171.124: + Up to 2 times faster loading data into SQL Server + Up to 2 times faster loading data into ODBC + Up to 4 times faster data extraction from Sql Server + Up to 4 times faster data extraction from ODBC sources
Version 126.96.36.199: + Query builder update + Added support for sub queries + Added incremental search to Query builder + Third party components update
Version 188.8.131.52: + Setup and executable are digitally signed now + Incremental search was added to field's list + Export to RTF was introduced + Excel export formats improvements + Various Interface improvements + Documentation update + Introduced support for Salesforce as datatarget
Version 184.108.40.206: + Support for latest version of Google spreadsheets was introduced + Up to 50 percent faster working with QVD files - Minor XML processing fixes
Version 220.127.116.11: Added post changes button Added Optimize Column Width button for grids Some corrections for German Locale were introduced Fixed number of problems related to working with uniqueidentifier fields in SQL server Command line improvements
Version 18.104.22.168: Support for SQLite and SQL Server Compact Edition was introduced
Version 22.214.171.124: Fixed some issues with SQLite Various bugs fixes
Version 126.96.36.199: Works correctly with mixed case objects in PostgreSQL Data grid grouping access violations fixes Loads Data from XML files Works correctly with multiple PosgreSQL schemes Support for PosgreSQL 9 was introduced Support for German Locale was introduced Documentation update
Version 188.8.131.52: Works directly with Excel 3.0-2007 No ODBC, OleDB or MS Jet Required Works correctly with mixed data types Works correctly with cells with more 255 characters No need for IMEX=1, HDR=Yes or Registry hacks (TypeGuessRows) Loads data correctly all the time + no need to edit Excel file