Central Program for HANA Systems

[former_member600934]

I have developed an Central program for SAP JAVA system. The program locks or delete dormant users according to the business logic. Here I have used UME API for connecting to UME Database and perform the user modifications.

Now I'm trying to do same for HANA Systems. I'm new to HANA system. So I've few questions for achieve this;

1. Similar to UME API, is there any library or tool available for connecting to the HANA database using JAVA?
2. How to connect to a remote HANA system and perform its user management?
3. Is it possible to create Web Service or APIs to access the system?

[Vitaliy-R]

Do you have only SAP HANA db, or is it HANA + Application Services (XSA) installation? For the later please check https://blogs.sap.com/2018/04/23/sap-hana-xsa-controller-api-interaction/

[BJarkowski · Accepted solution]

If you mean the SAP HANA database you could just use the JDBC drivers:

https://help.sap.com/viewer/0eec0d68141541d1b07893a39944924e/2.0.03/en-US/ff15928cf5594d78b841fbbe64...

You don't require any API. If you have XSA as well, then look at vitaliy.rudnytskiy comment above.

[former_member600934 · Accepted solution]

Thanks db8ac33b71d34a778adf273b064c4883. So I've to create an EJB project and use JDBC like mentioned in the link and deploy it in the system, then use the web service for preforming the task, is that right?

[BJarkowski · Accepted solution]

Hi amir.suhail.v ,

I don't know why we're adding now the WebServices to the scope. If you want to access the database to lock/unlock users, you can use the JDBC I mentioned. I don't know how you architect your Java app.

[former_member600934 · Accepted solution]

Hi db8ac33b71d34a778adf273b064c4883,

Thanks for the comment. Now I'm able make an JDBC connection as you mentioned. Now the problem is I'm not able to find the table where password details are stored, even if I find I think it wont help me since it will be encrypted. So to change password of user from code is there anyway we can execute HANA Statement for password change with JDBC sql in code?

[BJarkowski · Accepted solution]

Hi amir.suhail.v,

please have a look at this documentation. You can use the HANA Statement to change the password:

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/20d3459f75191014a7bbeb670b...

For example:

ALTER USER username PASSWORD Password1 

[mynynachau · Accepted solution]

Hi Amir,

since your original question here has already a helpful answer, I'm closing this thread. Please don't post new questions in comments, instead, please create a new question. https://answers.sap.com/questions/ask.html

Best regards

Mynyna (SAP Community moderator)