Data Exchange Wizard imports and exports data into/from ANY database.
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 Data Exchange Wizard can also add new and update old records based on primary key.
Some examples of what our customers use this ETL tool for include:
| Load Data From: |
Export 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
- Oracle
- MS SQL Server
- MySQL
- PostgreSQL
- Interbase/Firebird
- Any ODBC Datasource
- Ole DB
- XML
Into:
- Oracle
- MS SQL Server
- MySQL
- PostgreSQL
- Interbase/Firebird
- Any ODBC Compliant Database
- OLE DB
|
- Multiple tables using mask
- SQL Statement
- Oracle
- MS SQL Server
- MySQL
- PostgreSQL
- Interbase/Firebird
- Any ODBC Database
- Ole DB
While Importing Data:
- Add Records
- Update Records
- Delete Records
- Add New and Update existing Records
- Apply Functions to Database Fields
- Apply user defined Date format
- Run Sql script before and after loading data
- Filter Source Data
- Run calculations
- Use Select Statement as a Data Source
Command line interface
|
Questions?
