cancel
Showing results for 
Search instead for 
Did you mean: 

SAP HANA client: Connection to SAP HANA via JDBC

draschke
Active Contributor
0 Kudos

Hi,

we try to create a connection to our HANA system via JDBC.

Do we need a db user for this connection or should a restricted user be good enough at this point?

Couldn't find some hints within the docu.

https://help.sap.com/viewer/52715f71adba4aaeb480d946c742d1f6/2.0.02/en-US/ff15928cf5594d78b841fbbe64...

BR

lbreddemann
Active Contributor
0 Kudos

The documentation explains what restricted users are for. It's just not in the bit of documentation you looked at. I suggest checking the part where user concepts are discussed.

Accepted Solutions (1)

Accepted Solutions (1)

architectSAP
Active Contributor
0 Kudos

Hello Dirk,

You need a database user for a SAP HANA JDBC connection. Please check:

Connect to SAP HANA via JDBC

Best regards

Frank

draschke
Active Contributor
0 Kudos

Hi Frank,

thanks for helping us!

This is the same link, which I posted already.

In our case we want only write from a different system to target tables within hana. The user should only keep the connection. In my opinion, I would think that there is no necessary to use a db user.

I think I will at first check for a requested user and switch to a db user if its required.

And of course I was checking the differences between the db user and the restricted user at first, but hoped to get more response from someone who is used to do it already.

https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.02/en-US/bd856a90bb5710148a47e5765d...

Thanks a lot!

architectSAP
Active Contributor

Sorry, Dirk,

I misuderstood your question at first. Of course, a restricted user would do for an ODBC or JDBC connection.

In fact, I regularly utilze restricted users for connection tests to my SAP HANA, express editions:

Connect to SAP HANA, express edition using JDBC

Especially in containerized environments where port assignments can be tricky:

Installing SAP HANA, express edition with Docker

Best regards

Frank

draschke
Active Contributor
0 Kudos

Hi Frank,

really thank you very much for this helpful information and interesting links!

BR,

Dirk

Answers (0)