The HANA documentation has been improved, extended and overhauled a couple of times since the last update to this blog nearly four years ago.
At the time of this update, the corresponding URL for 1.0.12 (for HANA 1 SPS12) does not seem to be indexed by the google crawler. I will address this with the team but do not expect that much will be changed for the HANA 1 stuff anymore.
And Hi there once again!
After a while of using the ever improving SAP HANA reference documentation I found one thing specifically annoying:
there is no easy searchable SQL reference available.
Sure, there is the reference documentation available on http://help.sap.com/hana_appliance but the HTML version lacks a search feature and always having the PDF version open just to be able to quickly look up a command is too much effort for me.
Therefore I made my own HANA SQL reference search…
OK, not really, but I setup the search functions of the Internet browsers so that they would use Google to search just in the HTML version.
<?xml version="1.0" encoding="UTF-8"?>
<ShortName>SAP HANA SQL</ShortName>
<Description>Search SAP HANA SQL reference documentation</Description>
<Url method="get" type="text/html"
saved it as “hana_search.xml” in the folder “C:\Program Files (x86)\Mozilla Firefox\searchplugins” and restarted Firefox.
Since then I have this little entry up in my search box:
For GOOGLE CHROME
For Google Chrome I simply right clicked on the address bar and opened the “manage search providers” menu.
In there I just had to enter a name, a shortcut and the URL for the search like this:
Name: HANA SQL
Now I can just type right into the address bar stuff like “hsql alter table”, hit ENTER and get the search result right back.
For MS InternetExplorer
Finally for MS IE I used the site http://www.enhanceie.com/ie/searchbuilder.asp, entered the following string into the text box in step 3 (URL):
For the name I chose “SAP HANA SQL” this time and clicked on the “Install” button.
After accepting the installation dialog window, I now have a search engine entry for SAP HANA in my address bar.
I’m pretty sure that there are much better and more professional ways to set this up, but that’s what I figured out with a short amount of time and Google…
Hope you find it as useful as I do.
Cheers and have fun with HANA SQL coding!