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

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