2020.2

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.
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.
ODBC Data Source
l
ODBC Source: Use the drop-down to select an ODBC System Data Source. This must
be a data source that has been configured in the 64-bit ODBC Data Source Administrator,
as PlanetPress Connect is a 64-bit application and thus cannot access 32-bit data
sources.
Page 207