Transfers data between various databases
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
· 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
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
· 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
| Developer: License / Price: Size / OS: Last Updated: | DB Software Laboratory Trial / USD 130.00 6.1 MB / Windows All August 31st, 2010 |
| Download: | Data Exchange Wizard 3.6.3.5 |