DEV_xxx user credentials
I hope someone can help me.
I added my hanatrial db to the list of systems and created a couple of tables there.
I am now trying to log on to the hana db using this document : Connect to SAP HANA via JDBC - SAP HANA Developer Guide for SAP HANA Studio - SAP Library
So the format would be sth like :
connection = DriverManager.getConnection("jdbc:sap://[dbURL]:30015?reconnect=true&timeout=0",[USER], [PWD]");
The property window tells me that the URL is "jdbc:sap://localhost:30015?reconnect=true&timeout=0 " (is this correct ?? )
and the USER is of type "DEV_[xxxxxxx]"
but I'm not sure how to get the password.
I assumed there was some sort of mapping to my GLOBAL ID and PW so I tried these but it seems to hang at the connection point and never succeed.
If I use the DEV_ user with my GLOBAL password (or empty) it returns a ": invalid username or password" error
Where can I find or reset the DEV_xx user credentials ? or am I missing sth altogether ?
technically, the description you cited above is correct. However, you cannot access the database direcectly; it is protected.
So what you need to do it to open a tunnel first, using the neo command line tool. This is described in . When opening the tunnel, you will be shown the user credentials which you have to use for the JDBC connection.
Your URL looks okay (the host name "localhost" is correct too).