2021.2

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.
l This ODBC source is MSSQL: Check this option if the ODBC source is MSSQL (SQL
Server). The options below appear under MSSQL-ODBCadvanced configuration:
l Windows authentication: Select to use the Windows user name and password that
are used by the Connect Service.
l SQL Server authentication: Select to use the User name and Password set below
to connect to the SQL Server:
l User name: Enter the SQL Server user name.
l Password: Enter the password for the above user name.
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.
JDBC
Note
Since JDBC can connect to multiple types of databases, a specific database driver and
path to this driver's JAR file must be specified.
l JDBC Driver: Use the drop-down to select which JDBC Driver to use for the database
connection.
l JAR file path: Enter a path to the JAR file that contains the appropriate driver for the
database.
l Server: Enter the server address for the database server.
Page 208