SAP HANA Connection

[niat1970]

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.

[ipazin]

Hi there @niat1970,

welcome to KNIME Commuinty!

Have you seen these topics regarding connection to SAP HANA?

SAP HANA Connection KNIME

Good morning everyone, I have created and finalized my ML models and I even created a script to automatically run the jobs on a schedule. One thing that I have left and I can’t seem to figure out is my data. I am currently running a Python script that connects to HANA and pulls data from there for my model to train and test on ( eventually to generate a prediction ). I have tried using the generic database connector and I have added HANA drivers (.JAR) files but nothing is working and I am no…

How to Connect to SAP Hana?

Hi there, Does anyone know how to connect to SAP HANA? I tried going to the extensions page and was not able to find it. I looked at the Database Connector, but I am not seeing the JDBC connection or Driver. Does anyone have the drive and can share it with me? If no, any step by step guide to get this to work? I looked at my SAP installation and I do not see the driver under the installation folder. I also installed dBeaver to try to get the drivers from there, but was unable to unpack the .JA…

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

Br,
Ivan

[niat1970]

@ipazin

have tried using the generic database connector and I have added HANA drivers (.JAR) files but nothing is working and I

@ipazin , I went through the topics and performed all mentioned action.I had registered ngdbc.jar file also in preferences page.Please see the screenshot and the node used was Dbconnector.

Here is the screenshot of DB Connector config

Let me know if you find any issue in configuration.
Please guide me ,if i am doing something wrong.

[tobias.koetter]

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