HANA Studio Vs HANA Client Vs Eclipse ?

[babu_kilari4]

Hello HANA Experts,

I am pretty much new to SAP HANA and hence I would like to know the following.

Eclipse - I have heard that Eclipse is an open source IDE where we can add the necessary plugins and code the corresponding program language. It can compile, report the errors and does all the things in a very nice way..All this is fine.

What I am stumbed upon is what to install first and how to setup my PC with the right things to connect to HANA DB. I have the following things with me.

HANA Studio
HANA Client

Eclipse Kepler

I am also requesing your help to explain me the key differences between the above 3

Note :- I have already searched the SCN for this particular query, unfortunately, I have not been able to find the right thread that explains all these 3 and their correlation. Appreciate if you can explain it or also point me to the right wiki or step by step doc that connects all the above 3.

Thanks in advance

Best Regards,

Babu Kilari

[Former Member · Accepted solution]

Babu,

my understanding is that Eclipse (Kepler, Luna) is an open source IDE, ie not supported by SAP, that is used mainly for developing in Java. HANA Studio is a subset of Eclipse libraries that are SAP owned and supported and are used for development in Java, Javascript, ABAP, and some other languages and scripts. HANA Client is 100% owned and supported by SAP and is needed for connecting from your Windows or Unix machine to HANA server which usually is running outside of the environment in which the client is running.

i don't think you need the HANA client if all your development and actual running is in HANA web IDE, but you would have to have only the URL to your HANA server and not having anything installed on your local machine to really find out.

does this make sense?

[babu_kilari4 · Accepted solution]

Hello Gregory,

Following is the situation. I have been provided with HANA System access ( User credentials ) by the system administrator. Now, from my local PC, I would like to access this System (DB with XS Server as they say) and create some dictionary objects like Tables, Views.  In this scenario, how should I proceed ?  Do I only install HANA Studio here ? or install HANA Client first followed by HANA Studio ? 

Appreciate your response.

Babu Kilari

[former_member210482 · Accepted solution]

Hi Babu,

Yes, to create tables and views you only require to install Hana studio and hana client. Hana client maily installs the dependencies. Main component to install is Hana Studio.

Install Client first and then studio. Coz some runtime components are installed by client.

Kepler is mainly used for developing SDK components and for application development. But you can achieve it from Hana studio itself via different perspective available.

Regards,

Safiyu

[babu_kilari4 · Accepted solution]

Hello Safiyudeen,

Thank you for your reply.

Is there a sequence in which I should install these ? Are they mutually exclusive ? or dependent on each other.

Babu Kilari

[former_member210482 · Accepted solution]

Hi Babu,

To brief this.

There is no sequence of installations. Will work either ways.

The main component to be installed is HANA Studio. you can work with hana studio without the client but will lack certain features like exposing the objects to reporting tools.

Are they dependent. Yes. To connect to databases you require jdbc and odbc drivers on you client system. And also for reporting you require these drivers to expose your objects to reporting tool.

And also if you require python libraries, client is needed.Some visual runtimes are also installed by the client. These components are provided by the client.

Hope this helps.

Regards,

Safiyu

[babu_kilari4 · Accepted solution]

Hello Safiyudeen,

Based on your experiences with the setup, would the following sequence of installation work without any run time errors ?

HANA Studio

HANA Client

Eclispe IDE

Cheers,

Babu Kilari

[former_member210482 · Accepted solution]

Hi Babu,

Hana Client

Hana Studio

Eclipse IDE.

Note:

There are two versions of eclipse ide.

• one is from kepler repositoty, ie "http://download.eclipse.org/releases/kepler" .
• Another from sap development tools. "https://tools.hana.ondemand.com/kepler/".

Install the second one. Also make sure which version of hana studio is compatible with your Hana box.

Regards,

Safiyu

[babu_kilari4 · Accepted solution]

Hello Safiyu,

the second is actually not a Eclipse tool right ? Rather it is the URL for addding the Plugins for the Eclipse Kepler. This is my understanding.

Babu Kilari

[former_member210482 · Accepted solution]

Hi Babu,

Yeah you are right.

My bad.. You can download the kepler from that link too. But it takes us to the first link i provided. Didn't Notice that.. Thanks for correcting.

Cheers,

Safiyu

[nithinu · Accepted solution]

Hi Safiyudeen,

Eclipse is also allowing us to create tables,procedures,views and modeling views. Correct? Also we can use the web based development tool for building these. Is there any other differences with using Eclipse and HANA Studio ?

Thanks in advance!

Regards,

Nithin

[former_member210482 · Accepted solution]

Hi Nitin,

Yes, you can install the hana tools in eclipse and use as an alternate for hana studio. As of now Eclipse Luna has the necessary plugins. Eclipse Mars have fewer plugins. Like HCP integration plugins are not yet available for Mars.

Hope this is helpful.

Cheers,

Safiyu