Before connection to JDBC can be made you must ensure the JDBC to ODBC Bridge has been set up.
Open the Data tab and select Get Data
Then from Data > From Other Sources > From ODBC
Select the ODBC data source you created
A. Click OK and view all the available tables we expose to the navigator.
OR
B. Expand the Advanced table and provide a custom query
On the Windows tab select the Use my current credentials
Click Connect
Select the table or tables you which to import
Click Load