If however, the source database does not support windows authentication, then a username and password must be specified; as below:
ODBC Load
An ODBC load can have a number of source databases:
SQL Server
Oracle
DB2 for Linux, UNIX and Windows (the DB2 RED can build a warehouse in)
Teradata
Sybase
MySQL
DB2/400 (the DB2 that runs on AS/400 machines - quite different to above)
MS Access
Excel
The connection object properties window has the following fields:
