To test the connection
Select Browse | Source Tables from the menu strip
In the right pane you should be able to drill down to the area required.
ODBC
This connection is via an ODBC link. All data movement is performed using the ODBC connection.
ODBC connection types have multiple load table types and locations that influence behavior:
Native ODBC load
ODBC load
Integration Services load (Beta)
Native ODBC Load
A Native 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:
