the Database URL looks good. Can you provide more information on the error that you get. You should find more information on the problem in the KNIME log (View->Open KNIME log). Ideally you attache the stack trace of the error here but please check that it does not contain any sensitive information.
Attached you can find a workflow that I used to connect to the SAP Hana Express Edition. Please have a look at the settings that I changed (highlighted in the dialog in bold) in the Advanced tab of the DB Connector node or have a look at this screenshot:
Also please make sure that you have the correct SAP HANA license
since the SAP HANA Runtime license only allows to access the data via the Application Layer but not via JDBC.