SAP HANA Cloud Platform: Accessing HCP from your Development Environment

[Former Member]

SAP HANA Academy’s Jamie Wiseman details how to access SAP HANA in the cloud platform via the SDK tools console. Jamie is using a free developer license for SAP HANA Cloud Platform. Please follow these instructions to get your own free license.

First, Jamie goes to the cloud platform at hanatrail.ondemand.com and logs in with his credentials.  Once in the SAP HANA Cloud cockpit Jamie selects HANA XS Application and then clicks on add a new package. Jamie names the package mychppackage and clicks save.

Next, Jamie notes that in the Database Schemas option on the left hand side a new database schema named mychppackage has been created. Jamie then suggests that users should download the syntax file (available here) so that they can easily copy and paste the syntax that will be used throughout the creation of the XS application.

Next, Jamie details how to connect SAP HANA Studio to the objects that reside in the SAP HANA Cloud Platform by tunneling into the platform using the HDP SDK that was installed earlier. Opening a command prompt window Jamie navigates to the directory where the HDP SDK is stored and then enters c:\Program Files\SAP\hdbsdk\tools> neo open-db-tunnel -i myhcppackage -a YOURUSERIDtrial -h hanatrial.ondemand.com -u YOURUSERID (the part after tools> is from the first item in the syntax txt file) in the command prompt window. After entering his SAP HANA Cloud Platform password Jamie is notified that he has successfully tunneled into the platform.

However, if a user gets a connection error due a proxy issue when trying to tunnel then the user will need to set up their proxy using the SDK tools. Jamie details how to troubleshoot this error. Jamie goes to the SDK directory and then drills down into the tools folder and selects the readme.txt file. This file contains instructions on how to use a proxy with this SDK.

Back in the command prompt window Jamie describes the information that is displayed after successfully tunneling into the platform. The user and password listed will be used to set the SAP HANA Studio to the local host. Jamie also suggests that users take note of the instance number and the schema name. Jamie also notes that the tunnel is only open for 24 hours. After 24 hours the user and password information will change but the tables that are added to the schema will not change. If a user creates a new package or a new SAP HANA XS application in the Cloud Platform portal then a new and empty schema will be created. Also, a user can only access one personal development schema at a time in their SAP HANA Studio.

Next, Jamie connects SAP HANA Studio to the SAP HANA Cloud Platform by using the details from the SDK tools console. Once in SAP HANA Studio the user should open the developer perspective by clicking on window, then open perspective, then other, and then SAP HANA Development. Jamie then goes to the system tab, rights clicks and chooses add system. Jamie enters localhost for the host name and enters the instance number from the host console before clicking next. Jamie then copy and pastes the user and password from the SDK tools console to complete the connection. The personal development schema is now contained in the Catalog folder.

Jamie’s tutorial video details how to access the SDK tools console and how to connect SAP HANA Studio to the SAP HANA Cloud Platform.

View other tutorials on SAP HANA Cloud Platform at the SAP HANA Academy.

SAP HANA Academy - over 500 free tutorial technical videos on using SAP HANA.

-Tom Flanagan

SAP HANA Academy

Follow @saphanaacademy