2020.1

4. Use the drop-down to select the database type.
5.
Click Next.
Wizard settings for a database file
After opening a database file with a wizard there are a number of settings to make, depending
on the database type (see below).
On the last page of the dialog, click Finish to close the dialog and open the actual data
mapping configuration.
Note
After creating the initial data mapping configuration you may use a custom SQL query via
the Input Data Settings; see "Settings for a database" on page221.
Tip
The Sort on option, combined with the Stop data mapping option of the "Action step" on
page255, allows to process only a group of items without having to examine all records. (See also:
"Action step properties" on page340.)
MySQL, SQL Server or Oracle
l
Server: Enter the server address for the database.
l
Port: Enter the port to communicate with the server. The default port is 3306.
l
Database name: Enter the exact name of the database from where the data should be
extracted.
l
User name: Enter a user name that has access to the server and specified database. The
user only requires Readaccess to the database.
l
Password: Enter the password that matches the user name above.
l
Table name: The selected database is a set of related tables composed of rows and
columns corresponding respectively to source records and fields. Select a table from
which you want to extract data.
l
Encoding: Choose the correct encoding to read the file.
Page 204