Skip to Content
Author's profile photo Lars Breddemann

How to setup SAP HANA SQL reference web search with your browser


UPDATE, 04.09.2017


The HANA documentation has been improved, extended and overhauled a couple of times since the last update to this blog nearly four years ago.
For a while, the more current changes to the platform hosting the online documentation made it impossible a lot harder to set up and use the “search in the browser” method described in this blog.

Heated and long winded discussions (SAP Help Portal tries to go “darknet”) and SAP idea place entries (another soon-to-be-retired platform) eventually led to a solution.

So, as my colleague Laura Nevin points out in her blog post, the URL to be used for the HANA 2 SP02 documentation from now on is:

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.

UPDATE, 28.10.2013


As the SQL reference had been integrated into the standard SAP HANA help site, the base URL for the web-search changed.

Please use to access the new documentation.

While the old pre SP06 documentation is still available at no updates will be released there.

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 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.

Here’s how:


For the Firefox setup I simply created a OpenSearch XML descriptor file with this content:

<?xml version="1.0" encoding="UTF-8"?>
<OpenSearchDescription xmlns:moz=""
  <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 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:

Shortcut: hsql


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, 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!


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Thanks a lot for posting. This is very useful specially when you are getting syntax errors. This quick help would surely be great help.

      Author's profile photo Lars Breddemann
      Lars Breddemann
      Blog Post Author

      glad you liked it!

      Author's profile photo Ravindra Channe
      Ravindra Channe

      Really cool.. 🙂 . Just stumbled upon this blog while searching for something else.

      Lars, one sincere request, Can you please collect all your similar Gems at one place. I am sure it must be some where already compiled, but I am bit lazy to search for that. 🙂

      Once again, thanks for this nice tip.



      Author's profile photo Lars Breddemann
      Lars Breddemann
      Blog Post Author

      Hi Ravi,

      glad you like this little setup thingy.

      Personally, I find all my blogs somewhat useful 😆 so If I want to look them up, I simply display the content list ( and sort it by date or search by term.

      - Lars

      Author's profile photo Keven Lachance
      Keven Lachance

      FOR OPERA :

      Go to google.

      Right-click on the search box.

      Click on Create search (or something similar, I do not use the english version).

      Locate the %s. This is where what you write will be replaced in the url.

      Write a

      Write a keyword. You can use any keywork. Instead of writing or any other website in the address bar, write your keyword then your search terms. Example, I setted it to hana data type, and this is the same as searching the above query.

      the hana search will also appear on the search box if you have it. I prefer using the main address bar and the keyword.  (I have ~20 custom search and it's very efficient).

      It's also very easy with opera, they are the one who invented custom search within the address bar 🙂

      Author's profile photo Former Member
      Former Member

      Nice Job,

      Please keep it up.


      Rajat Jain