Issue Connecting KNIME to SAP Datasphere via JDBC (ngdbc.jar)

KNIME Analytics Platform
1

I’m trying to connect KNIME (version: [insert your KNIME version]) to SAP Datasphere using the official SAP HANA JDBC driver (ngdbc.jar version 2.21.10).
The JDBC URL I’m using is:

jdbc:sap://HOSTNAME:443?encrypt=true&validateCertificate=true

The driver is correctly registered in Preferences > KNIME > Databases, and I’m using the DB Connector

However, the connection fails with the following error:

I have confirmed:

  • The JDBC driver is version 2.21.10
  • Java version used is [insert Java version here]
  • Port 443 is open and reachable from my network
  • User credentials are correct
  • KNIME is allowed through my firewall

Mensagem de erro:

Execute failed: SAP DBTech JDBC: Cannot connect to jdbc:sap://HOSTNAME:443/ [Object is closed: com.sap.db.jdbc.SecureChannelSession@HOSTNAME:443 ConnectionID:0 SessionID:0 on sun.nio.ch.WindowsAsynchronousSocketChannelImpl[connected local=/[0:0:0:0:0:0:0:0]:54064 remote=HOSTNAME:443]: IP → HOSTNAME:443 ConnectionID:0 SessionID:0].

Info

Nodes

Explorer

K-AI

Monitor

2

Hello @Aldemir,
is it possible that you use the wrong/misspelled password or the database is down.

Please do not post any sensitive information in the public forum such as logins but also no host names and IP addresses. I did edit your post and removed all sensitive information including the image to be on the save site.

Bye
Tobias

1 Like
3

Thank you for your help. Sorry

4

I still don’t have access. I’ve already checked the connection and it’s working normally. It only doesn’t work in KNIME. This started happening after the SAP HANA update."