2021.1

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225.
Tip
The Sort on option, combined with the Stop data mapping option of the "Action step" on
page264, allows to process only a group of items without having to examine all records.
(See also: "Action step properties" on page352.)
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.
l Sort on: Select a field on which to sort the data, in ascending (A-Z) or descending
(Z-A) order. Note that sorting is always textual. Even if the selected column has
numbers, it will be sorted as a text.
Microsoft Access
l Password: Enter a password if one is required.
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.
Page 207