Exporting Data

Once Data Exchange Wizard is started on Operation Type Page select operation type > Export data.

Press the Next button to proceed to the next page

Press the Next button to proceed to the next page

On this step you should enter all necessary settings to connect to the source database

First select Database Type, click next than fill in

  • Server name for MS Sql Server Connection
  • TNS Name for Oracle Connection
  • DNS Name for ODBC Connection

Fill in User Name and Password

Fill in Database name for MS Sql Server Connection

Test connection to make sure it is working

Press the Next button to proceed to the next page

Specify whether your Source is table or Select Statement

Press the Next button to proceed to the next page

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

Select table(s) you want lo load data from or alternatively specify a mask to find tables

Press the Next button to proceed to the next page

SQL Statements

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

Note:

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

Press the Next button to proceed to the next page

Fill in Directory Name you want to export data into

Every table will be saved into separate file

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

Fill in File Name you want to export data into

Press the Next button to proceed to the next page

Check default options and

Press the Next button to proceed to the next page

We are now ready to export data from the database

Check the information presented and

Press the Next button to start exporting data

At this step data is being exported from the database

You may stop export any time by clicking Stop

Press the Next button to proceed to the next page

Once data is exported it vital to check the log file for any errors

Press the Next button to proceed to the next page.

Now when export is completed end user can choose to save the configuration

Click finish to close Data exchange wizard.

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/exporting_data.txt
  • Last modified: 17/09/2018 09:43
  • by admin