A simple application on HANA...just out of my interest

[hai_murali_here]

Hello Fellow SCNers,

This was the thought which came into my mind a week back….."why can’t we develop something which reads HANA data and showcase in VB.Net application”…that’s where I ended up creating a simple application,just out of my interest. I named it as “SAP HANA Viewer”…yes I didn’t find a better name for this piece of code.

We say that HANA uses different drivers to expose its data to any client application, say jdbc, odbc, odbo, etc. I thought why can’t we use any of these drivers to consume HANA data. Thought about jdbc…Oops... I am not a good Java developer…Ok…let’s use something which I know. Found that odbc can also be used to read the data with some tweaks.

Now which language I can use to develop this application... The first thing which came to my mind is Visual Studio .Net in which I had little hands-on experience

So driver is identified and also the framework. Let’s start coding….This is how I started…and ended up with the following App.Though it may sound silly for core delveopers,just a contribution to our SCN...;-)

SAP HANA Viewer

A standalone application which helps the HANA user to

• Connect to HANA DB (via preconfigured DSN) and know the DB Name, Version and the Host Name
• Views Info: Total no.of views created in the HANA System and count on each type of Views(Attribute, Analytic and Calculation Views)
• Users Info : Total no.of users created and their names
• Roles Info : Total no.of roles created and their names
• Server Status: Active Status of Index, Name, Statistics, Preprocessor, XSEngine and Daemon Servers
• List of Active and Inactive views within a selected package
• View the View’s Data: Open any view under the package and can come to know the type of selected View and also the data belongs to the view
  can be viewed in Excel file by a single click

Architecture

Initial Look:

Login Screen:

Login Screen with credentials entered:

Info about the Views and Server Status:

Info about the Users and Roles:

Selection of Packages from the list:

List of Active/Inactive Objects under different category:

Selection of Views (AT, AN or CV) from the list:

Type of View can be seen and Browse for the Excel location to open the View:

Opened View in Excel:

Few Code Snippets:

Connecting to HANA Server:

Reading the data from Recordset:

Opening Data in Excel:

Thanks for reading.

Comments are always welcome

Rgds,Murali