Setup Connection SAP HANA Database (Cloud Foundry) with Eclipse IDE 2019-09 (for SAP HANA Modelling)

[former_member521924]

Dear SAP Community,

I try to connect my SAP HANA Database (in Cloud Foundry) with Eclipse IDE 2019-09 (to create SAP HANA Views for SAP Marketing Cloud later on).

To setup the connection, I followed the instructions from
https://blogs.sap.com/2018/08/19/setting-up-the-new-hana-service-in-sap-cloud-platform-cloud-foundry...

Below, you find the steps, I performed to setup the connection.

When I now try to connect to my SAP HANA Database (in Cloud Foundry), I always get the error
The system cannot be reached. The Logon Data cannot be used. Do you want to add the system anyway?

I would be greateful to anybody who can help me to establish the connection correctly!

Best regards,
Denny

_____________________________________________________________________________________________

Step by Step:

1. I created a Global Account (e.g. MyAccount) having a Subaccount (e.g. CloudFoundry) (with Provider Amazon Web Services (AWS), Region Europe (Frankfurt) and Environment CloudFoundry) containing a Space (e.g. dev). Note: API Endpoint https://api.cf.eu10.hana.ondemand.com is still needed below.
2. The Space dev contains the Service SAP HANA Service for which we created the Instance (e.g. HanaServiceInstance) (with Plan 64premium). For the Instance (e.g. HanaServiceInstance) we did not create any Service Key. Select Open Dashboard.
3. In SAP HANA Service Dashboard, select Go to SAP HANA Cockpit. Note: The Direct SQL Connectivity zeus.hana.prod.eu-central-1.whitney.dbaas.ondemand.com:28779 is still needed below.
4. In SAP HANA Cockpit, the Overall Database Status provides us the Database Name H00, which is still needed below. Select Open SQL Console to arrive in the SAP HANA Database Explorer.
5. We next install eclipse IDE 2019-09, all SAP Development Tools for Eclipse 2019-09, and add the Perspectives to the upper right corner.
6. Select Add System.
   

   

   In Specify System, enter Host Name zeus.hana.prod.eu-central-1.whitney.dbaas.ondemand.com (= Direct SQL Connectivity without colon and port), Instance Number 00 (= Database Name without leading letter), select Multiple Containers and Tenant Database, enter Name H00:28779 (= Database Name + : + Port of Direct SQL Connectivity), Description (e.g. SAPHana2), Locale English (United States of America), and select Next.
   
   In Connection Properties, enter User Name SYSTEM, Password *******, check Connect using SSL, and select Finish.

   

7. Eclipse cannot reach the system

   

   but ping to system is successful.

   

What I am doing wrong? From technical perspective, you should know, that I

• did not create any destination (in SCP – Subaccount CloudFoundry)
• did not deploy any application (in SCP – Space dev),
• did not create any tunnel (if needed)
• did not create any user (SAP HANA Cockpit - only user SYSTEM exists)

[draschke]

Hi Denny,

could you solve your issue. I do have the same issue.

BR,

Dirk

[former_member521924]

Hi Dirk,

no, the problem has still not been solved. The port (which is used by the JDBC connection) is not the correct one, cf. one of my posts below. A colleague told me, that he had the same problem some years ago and that I first have to this. Then, establishing the connection should hopefully work.

Best regards,
Denny

[Former Member]

Could you ping sucesfully? I have the same problem

[lindsay_wang2]

How did you ping successfully? My ping shows request time out even though I set to allow all ip address.

[former_member226]

Hi,

Based on my Neo experience with HANA on SCP, I think the system user needs to be assigned additional roles (“sap.hana.ide.roles::CatalogDeveloper” and “sap.hana.ide.roles::EditorDeveloper”) before it can be really used with web-based workbench editor.

Hence can you please try to login to the Web-based HANA cockpit in SCP CF and try to create a new user with an additional role as mentioned here? Then you can try to use the newly created user to login as mentioned here.

Thanks

Saurabh

[former_member521924]

Hi Saurabh,

thank you for your response. I additionally performed the following step:

4.a. In Cloud Foundry > SAP HANA Service > SAP HANA Cockpit, I create a user group, a user (assigned to the group), and I assigned the following roles to the user:

6. Now, I repeated Step 6 (from before) with Credentials (Username and Passwort) of the new user.

But, again I receive an JDBC error:

Do you have any idea, how to solve that? I think its an JDBC problem. Perhaps the port is not the correct one. But where can I change the port for JDBC and to which value?

Thanks & best regards,

Denny

[former_member521924]

Some more details on JDBC error: