2020.2

2.
Click Next and enter the information for the source table.
l
Connection string: Displays the full path to the database.
l
Table: Use the drop-down to select the appropriate table or stored query to retrieve
the appropriate data set.
l
Encoding: Use the drop-down to select the encoding with which to read the data in
the table.
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.
3.
Click Finish to open the database.
ODBC DataSource
1. Select the ODBC system data source. Note: Only 32-bit data sources are currently shown
in this dialog, even if your system is 64-bits.
2.
Click Next and enter the information for the source table.
l
Connection string: Displays the full path to the database.
l
Table: Use the drop-down to select the appropriate table or stored query to retrieve
the appropriate data set.
l
Encoding: Use the drop-down to select the encoding with which to read the data in
the table.
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.
3.
Click Finish to open the database
JDBC
1. Enter the appropriate information to connect to the database:
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 below.
Page 781