2020.1

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.
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 Read access to the database.
l
Password: Enter the password that matches the user name above.
l
Advanced mode: Check to enable the Connection String field to manually enter the
database connection string.
l
Connection string: Type or copy in your connection string.
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.
Using the wizard for PDF/VT or AFP files
The pages in PDF/VT and AFP files can be grouped on several levels. Additional information
can be attached to each level in the structure. The structure and additional information are
stored in the file's metadata.
The DataMapper wizard for PDF files lets you select a level to trigger the start of a new record
and it also enables you to extract the additional information from the metadata. You can extract
data from the content afterwards.
Page 206