No insecure coding due to hard coded username/password information any longer. No need to type in the server hostname and port any more. Well, guess what, this way of providing a link to the HDBUSERSTORE also works with any ODBC connection string!Īs an example I use the same HDBUSERSTORE entry in R Studio, the IDE for R development, to re-run one of Blags test cases: Something you would do with ODBC… like connecting Excel or R or PYTHON or… In that case, the client didn’t even get through to the SAP HANA server.īy now you may wonder, why the heck I’m so happy about this HDBUSERSTORE feature in ODBC.Īfter all, most often people don’t make connection tests, but need to logon to the database to actually do something with it. If you don’t get a result, well, don’t go looking for some “missing” authorizations on SAP HANA level. If you get a result, that’s good.You’re in 🙂 ! (for which you see the output as well in the command line window).Īs no special authorizations are required for this command, running it means: Once odbcreg.exe got the logon data it tries to connect to the SAP HANA instance and runs a command like In my example I used the entry HANLARS to connect to my test instance HAN. So, instead of filling out the logon form you can just enter to have ODBC use the HDBUSERSTORE-entry named. I’ve mentioned the HDBUSERSTORE earlier and really like how it makes getting access to the SAP HANA server seamless. You can now either type in the usual SAP HANA logon credentials (hostname, port number, username and password) or, and this is really nice, you can use an entry from the secure HDBUSERSTORE. This is easy to do with the SAP HANA client program odbcreg.exe (to be found in the installation folder of the SAP HANA client software).īy using the command odbcreg.exe -t hdbodbc the driver is loaded and a logon dialog window is opened.Ī nice giveaway is that the exact driver software version information can be found in the title bar of this dialog window. Let’s see the nuggets in there!Ī common task is to check the database connectivity via ODBC after a user workstation has been set up. While I’ve no idea on when the SQL reference will follow, I still use the web browser integration until then. This means: no more back and forth between the PDF and the HANA studio as well as ‘F1’ help in the studio.Īs you can see, the SAP HANA Administration Guide, the SAP HANA Developer Guide and the SAP HANA SQLScript Reference are now ‘on board‘. 1.1, (really that date? not even 12.12.12? 🙂 ) and found something pretty nice in there for ODBC and JDBC users.īy the way: meanwhile (as of SPS 5) three of the files from the HANA documentation website have been included into the local eclipse help. I just browsed throught the updated SAP HANA Developer Guide, SPS 05, Ver. Based on revision 48 (SPS 5) of SAP HANA Studio and Database

Hana odbc connection string