ODBC Load - Direct Path OCI
ODBC load - using direct path OCI in the scheduler
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: