In another installment of the SAP HANA Academy’s video series on SAP HANA Cloud Platform Jamie Wiseman demonstrates how to connect a database schema hosted in the SAP HANA Cloud Platform to SAP HANA Studio.
As a prerequisite for this tutorial a user must first follow the steps outlined in this video from the SAP HANA Academy on Setting up the Eclipse IDE.
Creating a New Schema (0:18 – 1:08)
Go to the SAP HANA Cloud Platform cockpit on a web browser and login with your credentials. Next click Database Schemas on the left hand side and then select New Schema. Enter any name you desire for the Schema ID and then hit the Save button to put the newly created schema into the above list of database schemas in the cockpit.
Connecting to the SAP HANA Cloud Platform Schema in SAP HANA Studio (1:08 – 3:46)
In SAP HANA Studio click on Window in the menu bar and choose Open Perspective and select other. Then scroll down and choose SAP HANA Development. Now go to the systems tab, right click anywhere in the area and select Add Cloud System… . Set the Landscape host as hanatrial.ondemand.com and then enter your account name (which is your user name plus the word trial appended at the end), your user name and password. Also choose to save your password before clicking on the Next button.
On the following screen choose the recently created schema as the Trial instance and press finish to successfully connect SAP HANA Studio to the SAP HANA Cloud Platform schema.
Now within the Catalog folder there is a personal development schema and another schema for the user beginning with DEV.
The description of the systems added to SAP HANA Studio shows the SAP HANA instance name along with the user name created in the SAP HANA Cloud Platform connection. This may not be ideal especially if more systems are added to the SAP HANA Studio. To differentiate between systems right click on the system and choose properties. After selecting Resource on the left hand side type in a name applicable to the schema in the Description text box and then click Ok.
If the tunnel connection is disconnection via signing out or 24 hour passing then SAP HANA Studio will need to be restarted once the tunnel connection has been reestablished.
Check out Jamie’s video on connecting SAP HANA Studio to schema created in the SAP HANA Cloud Platform.
View more tutorial videos about SAP HANA Cloud Platform at the SAP HANA Academy.
SAP HANA Academy – over 500 free tutorial technical videos on using SAP HANA.
SAP HANA Academy