Hi Arska,
Welcome to KNIME forum!
It will require a JDBC driver for connection and this documentation for solidDB may be useful.
A commercial JDBC/ODBC driver can also be used but we recommend using a dedicated JDBC driver. Please have a look at this link for more information.
Best regards
Hannan