dewizard:working_with_data_exchange_wizard

To start Data Exchange Wizard Click Start → All Programs → DB Software Laboratory → Data Exchange Wizard → Data Exchange Wizard

This is how Data Exchange Wizard looks like once it is started
Press the Next button to proceed to the next page

You may choose to open previously created configuration or open existing one
Press the Next button to proceed to the next page

Select appropriate operation type
Press the Next button to proceed to the next page

Select data source type and Press the Next button to proceed to the next page

Depending on your choice you will see one of the following pages

Select File name and if you want to load data from several files specify mask
Data Exchange Wizard will search for files where selected file is located
Press the Next button to proceed to the next page

Select File format and fill in Text Qualifier and Delimiter all relevant options
Press the Next button to proceed to the next page

Select appropriate options
Press the Next button to proceed to the next page

Select File name and if you want to load data from several files specify mask
Data Exchange Wizard will search for files where selected file is located
Press the Next button to proceed to the next page

Select Excel Sheet or several Excel Sheets and
Press the Next button to proceed to the next page

Fill in Data Source Name, User Name, Password
Test Connection and
Press the Next button to proceed to the next page

Specify whether your Source is table or Select Statement
Depending on your choice you will see one of the following pages

Select table(s) you want to load data from or alternatively specify a mask to find tables
Press the Next button to proceed to the next page

Fill in a Select Statement you want to load data from
Or alternatively use Query builder to generate Sql
Press the Next button to proceed to the next page

Allows designing complex SQL queries

On this step you should enter all necessary settings to connect to the target database
First select Database Type, than fill in

  • Server name for MS Sql Server Connection
  • TNS Name for Oracle Connection
  • DSN Name for ODBC Connection
  • Other settings for MySql, PostgreSQL, Interbase/Firebird, and OLE DB

Fill in User Name and Password
Fill in Database name for MS Sql Server Connection
Fill in Table name to load data into
Test connection to make sure it is working

Fill in Sql Statements Separator and
Press the Next button to proceed to the next page

Note:

For more information see “Target Database specific parameters” 

Select Appropriate Transformation type
Press the Next button to proceed to the next page

  1. Refreshes fields’ list from the database
  2. Checks script for the errors
  3. Allows user to clear field mapping
  4. Hides mapping panel

  1. Refreshes Source data
  2. Adds new column
  3. Deletes last column
  4. Auto map the source fields to the target fields
  5. Filter
  6. Number of records to show in grid
  7. Sources file name/ table name

Mapping panel is designed to provide user with all information related to the mapping of one particular field. There are two ways of mapping: direct and through calculations.

Alternately you may hide Mapping panel and use grid to perform mapping.

See the picture below

Once mapping is completed Press the Next button to proceed to the next page

Note

See next chapter for more information about mapping

Data Exchange Wizard provides functionality to perform SQL statements before and after data import or export.

Note:

In order to Execute several SQL statements user must specify SQL delimiter
No select statements allowed

Check default options and
Press the Next button to proceed to the next page

This is how data will look like once it is imported into the database
Press the Next button to proceed to the next page

We are now ready to load data into the database
Check the information presented and
Press the Next button to start loading data

At this step data is being loaded into the database
You may stop import any time by clicking Stop
Press the Next button to proceed to the next page

Once data is loaded it vital to check the log file for any errors
Press the Next button to proceed to the next page.

Examine Rejected records
Press the Next button to proceed to the next page

Now when import is completed end user can choose to save the configuration
Click finish to close Data exchange wizard.

HowTo guides

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL forum

  • dewizard/working_with_data_exchange_wizard.txt
  • Last modified: 17/09/2018 09:43
  • by admin