Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

HANA DB connection

AtrayeeDutta
Regular Contributor
Regular Contributor

Hi team,

we are trying to set up connection for HANA DB, but connection is failing with address not found but can ping the host from cmd, certificate is not there.

connection type: HANA, DB

url: jdbc:sap://**********:30015?databaseName=GSD;encrypt=true&validateCertificate=false

as per Saviynt FD: jdbc:<specify sub protocol>:<specify server name>?databaseName=<specify database name>&encrypt=true&validateCertificate=true&trustStore=<specify location of trust store>

driver: com.sap.db.jdbc.Driver

we deployed ngdbc.jar in external JAR

username and pwd is there.

in logs we see this:

Error While Test connection: SAP DBTech JDBC: Cannot connect to jdbc:sap://*********.bsci.bossci.com:30015;DatabaseName=GSD;encrypt=true&validateCertificate=false [Invalid address, missing port number: DatabaseName=GSD].

can anyone help how we can connect.

Regards

2 REPLIES 2

Manu269
All-Star
All-Star

Can you try pinging the target / telnet from the sc2 server?

Also once you uploaded the jar file did you restart the server?

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

AtrayeeDutta
Regular Contributor
Regular Contributor

Hi @Manu269 ,

We restarted after deploying JAR. Connection with database type as DB, is successful.

But with connection type HANA, it is failing, anything additional we need to do for that? can you please let us know.

Regards