SAP HANA Connection Issue

[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.