1.4

l
Server: Enter the server address for the SQL Server database.
l
Port: Enter the port to communicate with the SQL Server 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 SQL Server 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.
ODBC DataSource
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
Click Next.
l
Click Finish to close the dialog and open the actual Data Mapping configuration.
JDBC
Note
Page 49