Skip to Content
Author's profile photo Lars Breddemann

What HANA needs now is some …

… logging!

Yes, you just got click-baited into reading this advertisement for a product enhancement idea that I posted: Standard logging facility for SQLScript

The idea here is simple: when you write application logic in SQLScript then you very likely want to have the option to log what your program does.

This is not the logging I am talking about
Photo by ABC Photo Archives – © 2011 American Broadcasting Companies, Inc. – Image courtesy

What I am talking about is a language feature in SQLScript that would allow to write out arbitrary messages during the execution of a SQLScript read/write procedure to some logging target. A target could really be anything, in this case, that can receive the logging information, e.g. a database table, the OS syslog, a logging server, a CSV file, an OS pipe, a kafka topic…

HANA SQLScript should provide the API for such a logging facility so that developers can focus on their business logic instead.

Especially with more and more application logic spread out over different micro-services, js apps and SQLScript an open and flexible logging feature could help to make sense of what an application does from one end to the other.

Another big technical benefit for a built-in logging would be that it could avoid the use of dynamic SQL and all the issues around it (security, performance, …).
Instead of pasting together an INSERT statement, a simple function call could not only invoke a potentially buffered log writing but also automatically include common technical information like current code location, timestamp, session context, user name, etc.

If you agree that such a feature is just what is missing in SAP HANA SQLScript, then go and vote for the idea Standard logging facility for SQLScript.

Note, that you have to register for the idea place first ( and that you have to be logged on to vote.


Assigned Tags

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

      Could not agree more. Got my vote.


      Author's profile photo Benedict Venmani Felix
      Benedict Venmani Felix

      Unfortunately, not able to see the idea because of auth issue. Can you make the idea public or something?

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

      Unfortunately, it seems that there is an additional registration required to use the SAP IdeaPlace.

      Once registered to you should be able to see, vote and post any idea in there. To my knowledge all the ideas there are public.

      That's about what I know about how access to the platform is granted.

      The "How it works" page has two links to support documents (Registration Support FAQ and Log On Support FAQ) but both of them end in the "content not migrated"-black hole... (arrrrrgh)