Skip to Content
1
Jan 25, 2020 at 04:55 PM

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

1951 Views Last edit Feb 06, 2020 at 11:28 PM 2 rev

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)

Attachments

bild03.png (141.6 kB)
bild06.png (93.2 kB)
bild07a.png (162.7 kB)
bild08.png (173.4 kB)
bild12.png (74.9 kB)
bild13.png (120.2 kB)
bild14.png (31.2 kB)
bild15.png (13.9 kB)
bild16.png (152.6 kB)
bild17.png (58.7 kB)