SAP HANA Connection

Hi,
I am new to KNIME.My usecase is very simple…I have to read WSDL file and write it to SAP HANA database. I registered ngdbc.jar file in preferences page and when using DBConnector node to connect with HANA.I am getting below error.


Please help me ASAP.

Hi there @niat1970,

welcome to KNIME Commuinty!

Have you seen these topics regarding connection to SAP HANA?

For completeness here is link to Database Guide where you should all all the necessary info:
https://docs.knime.com/latest/db_extension_guide/index.html#register_jdbc

Moved your question to new topic as it seems not related and will get more visibility :wink:

Br,
Ivan

1 Like

Hello niat1970,

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.

Bye
Tobias

2 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.