SAP HANA Connection Issue

[LearningStar (Gagan Juneja)]

Hi Team,

We are trying to establish connection with SAP HANA system using VA, we are not using any Saas connectivity but getting some error while creating connection it seems to be external jar issue which it is support.

In order to connect to the SAP HANA Cloud database, JDBC driver version 2.4.67 or greater is required. For more information, refer to the SAP Help Portal. I have tried to update the same jar file with name

ngdbc-2.24.8-sources.jar

Has anybody face such issues? please help out if you are aware how we can eliminate such errors

[pattabhi (Pattabhi Nandarapu)]

Hi @LearningStar

I found the following related tickets: could be helpful to troubleshoot your connection issue.

SAP HANA Direct Connection - Error [10] authentication failed

Hi Team, We are performing a test connection with the SAP HANA OOTB connector in ISC. When we try to connect, we get a “[10] authentication failed” response. The same response can be obtained with the JDBC connector. [image] We have already checked the service account permissions and tried to create a new account and password. We have also tested the URL and port in the VA via telnet and the connection is correct. The logs in the VA show the same authentication error even at the debug level. …

SAP HANA Connector - Tenant DB Connection

Hi team, We are currently using the OOTB connector for SAP HANA in IDN. We managed to connect using the default database URL: jdbc:sap://HOST:PORT/?databaseName=dbName When we did the aggregation, it reads the accounts from the SAP HANA System DB, but we need to read the accounts from the Tenant DB. Has anyone had a similar experience when using the SAP HANA connector? Does it need an extra parameter for the URL or do we need to change the port of the connection? Thanks.

Incorrect JAR File (Sources vs. Binary):

• You uploaded ngdbc-2.24.8-sources.jar. The -sources JAR typically contains the source code for the library, not the compiled binary code that the JVM needs to run. You need the binary JAR file.
• The correct name would usually be something like ngdbc.jar or ngdbc-2.24.8.jar (without -sources).
• Action: Ensure you’ve downloaded the actual JDBC driver JAR (the compiled binary) from SAP’s support portal or Maven repository, not the sources or javadoc.

[prashanthrns (Prashanth Nagarajan)]

Hi @LearningStar , could you share the actual error message? If it is related to the JAR file on class version, we might need to recompile the JAR file using the Java version that matches the connector.

[LearningStar (Gagan Juneja)]

Hi Prashant, This is the error we are getting on testing the connection

Application team has already verified details are correct, We suspect the issue related to Port, VA unable to create connection.

[prashanthrns (Prashanth Nagarajan)]

It seems to be an unknown host error, due to the incorrect hostname in the url.