1.4

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 below.
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 Readaccess 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
Click Next
l
Click Finish to close the dialog and open the actual Data Mapping configuration.
Oracle
l
Server: Enter the server address for the Oracle database.
l
Port: Enter the port to communicate with the Oracle 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 Oracle 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
Click Finish to close the dialog and open the actual Data Mapping configuration.
For a PDF File
To create a PDF/VT file data mapping configuration using the wizard, use the following steps:
Page 50