1.7

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.
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.
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.
Page 87