Hello @jayanthv,
you can not use ODBC driver in KNIME (see here). Alternative is to use JDBC driver provided by CData but that costs:
Br, Ivan