HANA Client and Server

[Former Member]

Hi,

In SAP HANA do we have  Severs  as Application Server,DataBase Server,Presentation Server  if it is yes  how it works.

i would like to know  the difference between HANA Server and HANA client. and usage of HANA Client .

If any organization wants to purchase Hana Appliance what will be the approach  do they need to buy HANA Server,HANA studio and Hana Client.

I am so confused with these terms.

Thanks in advance.

[SK-EA]

Phani,

SAP Hana comes as an appliance that provide both the RDBMS and database server functionality and Hana studio is the tool to administer and work with SAP Hana outside SAP screens.

SAP Hana is mainly used to derive reports as part of Analytic capabilities and Hana modeling comes into picture for designing the reports.

When you are working with Hana on cloud its the same picture and no additional tier comes into action.

Hope it helps in clarifying your query.

[lbreddemann]

Hi Phani!

HANA client is the software you need to communicate with the HANA database.

This is pretty much the same as with any other DBMS you might have used.

There's the server component that actually does the database "work".

And there are the client components like ODBC/JDBC driver that "do the talking" to the server part.

For HANA there's no special client license to be bought.

When you license the server you can simply download all client packages including the HANA studio and use them w/o paying anything on top.

So, client/server are used here in a very classic sense.

cheers, Lars

[Former Member]

Hi Lars,

1) where is Hana Studio/Hana Modeling come into the scenario.

2)when iam using  hana cloud version, we can upload .csv format files into ftp server this server is it an application server or database server or presentation server.

Please clarify.

Thanks

Phani

[lbreddemann]

HANA Studio is the admnistration/modelling/development environment for HANA.

It's included in your HANA license and it makes use of the HANA client (of course it does).

Technically HANA studio connects via JDBC.

For the second part of your question: I actually don't have an idea what you mean by that.

HANA as a DBMS is a client server system.

Your program (the client) consumes the database services offered by the server (HANA database server).

Pretty much the same approach you have with any other DBMS nowadays.

[henrique_pinto]

In summary:

1) "HANA Studio" is the client.

2) "HANA Client" are the drivers;

😉

[lbreddemann]

You could see it that way, but technically (and also from what you would get on service marketplace if you search for it), the client is just that - the client software (what you call driver).

Actually there's more to the HANA client than just the ODBC/JDBC drivers, but these are for sure the most often used parts of the client package.

HANA studio is a program that uses the client software (the drivers) to act in the role of a database client. It's pretty common to mix up the terms as they are used in two different contexts (technical component and role in a client/server system paradigm).

[henrique_pinto]

Yeah I'm just messing with the fact that SAP chose to not go with industry-wide terms and just create their own. Again. oh well...

[lbreddemann]

SAP did and does a lot of name invention - but this is not the case here.

Oracle client - that's the client software components, not e.g. the SQL developer.

MS SQL client - contains the client software components, not the management studio.

DB2  client - again: client software components.

...

Actually the way SAP uses the term is not only technically correct but also the way how it is actually used throughout the industry.

[henrique_pinto]

cool.