1.6

Table Of Contents
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
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.
Page 69