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

Welcome Page

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

Load Configuration

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

Operation Type

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

Data Source Type

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

Text Files

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

File Format

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

Restrictions

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

Excel Files

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

ODBC Data Source

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

Source is Table(s)

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

Source is a Select Statement

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

SQL Query Builder

Allows designing complex SQL queries

Target Connection

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” 

Transformation Type

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

Mapping Screen Overview

Main tool bar

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

Source tool bar

  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

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

SQL Statements

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

Logging Options

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

Data Preview

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

Ready

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

Processing 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

Log

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

Rejected Records

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

Saving Configuration

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