April 2, 2014 2 minute read

Connecting to #SAP #HANA Instances on #SAPHCP from #Eclipse IDE

I seem to be in a blogging mood recently. 😉 Unfortunately, I missed the chance to give a shout about a cool new feature which was released couple of weeks ago (on March 13, precisely speaking) but apparently has left unnoticed by many folks and friends of SAP HANA Cloud Platform. So – and as a wise man had once said – I thought “better late than never” and decided to try and fix this lapse.

What am I talking about? Well, until March 13, if you wanted to connect to an SAP HANA instance on SAP HCP, you had to open a DB tunnel in the Console Client by executing the open-db-tunnel command, copy the connection details it returned to you (including the instance number, DB user and password), go to your HANA Studio (and yes, it had to be a separate standalone IDE from your other Eclipse IDE which you were using for Java development on HCP and/or any other development you do!) and paste those connection details into the corresponding wizard pages. Oh, and did I mention that you had to keep the DB tunnel in the Console Client open while you were working on the remote HANA instance? Sounds fun? Guess not.

Well, forget about the above. We’ve put an end to all those tedious, awkward and error-prone steps within so many different tools. Now you can do everything in a single tool (Eclipse IDE) with just a couple of clicks. The prerequisite is that you have installed an Eclipse Kepler IDE and the SAP HANA Cloud Platform Tools on top, as described in Setting Up the Tools. (And yes, you got it right – all necessary SAP HANA Tools now can be installed as well from the SAP Development Tools for Eclipse – Kepler Software Repository, so you don’t need a separate HANA Studio installation any longer.)

Now, if you already have a trial or productive SAP HANA instance in your account (see e.g. Creating a Trial SAP HANA Instance), you can just go to the SAP HANA Development perspective in your Eclipse IDE, right click in the Systems view and select Add Cloud System… which should open up this nice wizard:

Enter your account info and click Next. This will lead you to the second page where you have to select an instance from the list:

Click Finish and in a few seconds it will be added in the Systems view. If you are working with a productive instance, you also need to provide your own DB user and password. See in the official documentation how to create it. In this case, as a last step the wizard might ask you to change your DB password if it is an initial one and you haven’t changed it yet.

That’s it! Now you can go on and import some sample apps, play with them, or develop your own XS app – it’s up to you. Enjoy! And don’t hesitate to share your feedback and comments – we are always looking for further improvements and simplifications. 🙂

53 Comments

You must be Logged on to comment or reply to a post.

Wolfgang Weinmann

April 9, 2014 at 2:11 pm

Hi Pavlov,

thanks very, very much for sharing that! I got a HCP instance and I already installed the Eclipse - Kepler - Addon in my HANA Studio and get the option "Add Cloud System".

This all looks very great.

But unfortunately I have no idea, where the password for the access is derived from. I tried all my "standard" passwords, but nothing worked. And obviously there is no option to reset the password.

So the big question is: where can I reset the password? Or from which system is the password derived? Since 2 days I have a ticket open and this ticket goes like a ball in a ping-pong-match.....

Thanks a lot in advance

Wolfgang

Dobromir Zahariev

April 9, 2014 at 2:19 pm

Hello Wolfgang,

from your post I can consider that you have a productive HANA instance.

You need to create DB user that you can use to connect from Eclipse based HANA tools.

More details how you can create and manage DB users for productive HANA instance operated on SAP Hana Cloud Platform, please see the following section inside documentation: SAP HANA Cloud Platform

Best regards,

Dobri

Wolfgang Weinmann

April 9, 2014 at 2:27 pm

yes, sorry, I got it in the meantime!

thanks a lot!

Vladimir Pavlov

Blog Post Author

April 9, 2014 at 5:03 pm

Hi,

@Dobri: thanks for stepping in and helping Wolfgang at such a record-breaking response time! 🙂

@Wolfgang: thanks for the kind words! (please feel free to also rate and/or like it using the buttons at the top right and below the post 😉 )

btw, it's actually mentioned in the last paragraph:

If you are working with a productive instance, you also need to provide your own DB user and password. See in the official documentation how to create it.

I'm really sorry that you had to wait for two days to have your ticket resolved (perhaps it got into the wrong queue?) - as you can see, it's a piece of cake.

Cheers,

--Vlado

Wolfgang Weinmann

April 10, 2014 at 5:10 am

🙂

Former Member

May 7, 2014 at 6:18 am

Just a small side note from my end: I had to install the "SAP HANA Cloud Platform Tools" from the "SAP Development Tools for Eclipse Kepler - https://tools.hana.ondemand.com/kepler"-package to get the "Add Cloud System"-option

Searching for "standard Kepler" wasn't enough.

Vladimir Pavlov

Blog Post Author

May 7, 2014 at 9:03 am

Yes, that's what described above:

The prerequisite is that you have installed an Eclipse Kepler IDE and the SAP HANA Cloud Platform Tools on top, as described in Setting Up the Tools.

What do you mean by "standard Kepler-Addon"?

Former Member

May 7, 2014 at 10:48 am

"Eclipse Kepler IDE" as description was just not precise enough for me, "SAP Development Tools for Eclipse Kepler" is what is needed to find the Addon without searching too long and I just wanted to point also directly to the addon URL https://tools.hana.ondemand.com/kepler

With "standard Kepler" I ment the IDE release version which itself is called "Kepler": http://download.eclipse.org/releases/kepler

Muhammad Muaz Qazi

June 17, 2014 at 3:26 pm

I am following the same steps mentioned above but not successful.

Message is: JN5 localhost00 - System state cannot be determined

What is wrong I don't understand ?

Vladimir Pavlov

Blog Post Author

June 18, 2014 at 11:45 pm

You can ignore that message - it does not have functional impact.

Former Member

June 18, 2014 at 11:21 pm

In the "Add SAP HANA cloud Platform system' I specified

Landscape host = hanatrial.ondemand.com

Account name

User name

Password

I get the following error: The information about trial and productive SAP HANA instances cannot be fetched from SAP HANA Cloud Platform. Check the error log for more information.

1. What am I doing wrong?

2. Where is the error log please?

Thanks.

Soyab

Former Member

June 18, 2014 at 11:26 pm

Problem resolved by logging off and restarting Eclipse.

Former Member

July 31, 2014 at 7:36 pm

Thank you, very helpful

You have an idea of why we might have a Insuffisant Privelege message on the content folder, while the only access existing is the one I created with the session, DB & schema?

Same for Repositary View

If you met the same issue, I will be pleased to read your solution

Thanks

Dobromir Zahariev

August 1, 2014 at 6:20 am

Hello Lilya,

you need following permissions added to your user:

HCP_PUBLIC

HCP_SYSTEM

Probably you miss the step 2 from importing sample scenario - details here.

Enjoy,

Dobri

Former Member

August 3, 2014 at 8:18 pm

Hi,

Thaks a lot but the sample scenario seems to apply only on HCP XS, doesn't it?

Vladimir Pavlov

Blog Post Author

August 1, 2014 at 1:00 pm

Could it be that it's a HANA instance (just DB) and not HANA XS? Please check in your Cockpit.

Former Member

August 3, 2014 at 8:16 pm

Hi, It is a HANA instance (just DB) yes, but I'm able to see the and create tables

Former Member

August 6, 2014 at 6:40 am

Hi ,

I am getting below error while adding could system 'hanatrail.ondemand.com'

"Could not populate schemas UI."

pls help me to fix this.

Exception stack trace:

java.lang.reflect.InvocationTargetException

at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:421)

at org.eclipse.jface.wizard.WizardDialog.run(WizardDialog.java:1028)

at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionSchemasWizardPage.fetchSchemasAndDbs(CloudSystemConnectionSchemasWizardPage.java:243)

at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionWizard.nextPressed(CloudSystemConnectionWizard.java:174)

at com.sap.cloud.tools.eclipse.hana.tunnel.ui.CloudSystemConnectionHandler$1.nextPressed(CloudSystemConnectionHandler.java:26)

at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:428)

at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:628)

at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)

.................................................

Thanks!!

Dobromir Zahariev

August 6, 2014 at 6:55 am

Hello Naresh,

can you please post the whole stack trace. The real reason is not included inside this fragment.

The problem can be:

- proxy settings are wrong and landscape cannot be reach and validated

- landscape name is misspelled

- wrong user or password

- wrong account name

- or something else ...

Also, please be sure that you use the latest version of the plugin.

Best,

Dobri

Former Member

August 6, 2014 at 7:08 am

Hi Dobromir,

Here is complete trace: