Product Home
Export Table to Excel for DB2 Prev Page Prev Page
Product profile
Connect
User interface
Select Source Table
Data Preview
Settings Window
Command line
Database query
Select Target Table
Select Columns
Mapping
Select Target File
Text Output
SQL Output
XML Output
Excel Output
Select Objects
Select Schema Objects
Scheduling
Technical support
License
Install and Uninstall

Connection Settings

Connect Window helps you to setup your connection to database. There are two methods to connect: with predefined data source or using direct connection to server or database file. In the first case you need to setup connections properties with Windows ODBC Administrator outside the Export Table to Excel for DB2 tool.

Most important connection settings are:

  • Database Server or Data File name
  • User name or Login
  • Password

Also, you may specify additional properties of the connection:

  • Database name (not for all types of DBMS)
  • Owner or Schema name
  • Transaction size (how many rows will be processed per transaction)
Export Table to Excel for DB2: Connect Window