Connect to HANA MDC, Create Schema & first DB table
In this blog I will show you how to connect to your HANA MDC DB through your SAP Cloud Platform trial account, create your first Schema and DB table.
Prerequisites
SAP Cloud Platform Trial account (https://account.hanatrial.ondemand.com/)
HANA MDC DB created (Click here to see how)
SAP Web-based Development Workbench configured
Connect to your HANA DB
In this section I will show you two ways to connect to your HANA DB instance, first through the SAP Web-based workbench and second through Eclipse using the HANA tools.
SAP Web-based Development Workbench
Navigate to Persistence > Databases & Schemas > Select your DB
Select SAP Web-based Development Workbench
Enter username and password and click OK
Click on Catalog
You are now connected to your HANA MDC DB.
Eclipse with HANA Tools
Open Eclipse > Select Window > Show View > Other
Select SAP HANA > Systems > Click OK
On the systems tab select Add cloud System
Note: Before you can connect your will need your Account Name for your SAP Cloud Platform trial, it can be found here.
Enter your user credentials.
Select your Hana MDC DB click finish.
You are now connected to your HANA MDC DB.
Create Schema and first DB table
Create Schema
In this section we are going to perform the titled tasks using the SAP Web-based Development Workbench for ease.
Navigate to the SAP Web-based Development.
Click on the Catalog button.
Right click on Catalog > Select New Schema
Enter a name for the Schema and click OK
Notice the new Schema “DEMO” has been created.
Create Table
In the Catalog of the SAP Web-based Development click the SQL button to open the SQL editor.
Enter the following code into the SQL editor:
CREATE TABLE DEMO.TBL_CUSTOMER (
ID INTEGER,
FIRSTNAME VARCHAR(40),
LASTNAME VARCHAR(40),
EMAIL VARCHAR(120),
PRIMARY KEY (ID)
);
Note: we have not specified a DB table type, by default it will be a Row based table. Also notice the table name DEMO.TBL_CUSTOMER, the relates to <Schema>.<Table>.
Press Run button
If the SQL is correct you will see the following.
Now check your table has been created.
Notice TBL_CUSTOMER now exists under the table section of the DEMO schema.
Nice blog Shaun. I think Hana DB on HCP represents a great way for people to try out HANA and start to use it. I'm currently developing a CDS view to speed up a search in a Fiori app. Maybe next you could show how to create tables and views using CDS...
Thanks Mike,
I plan on putting up a few more tutorials very soon!
As for a using CDS views this is something that a few of us @Keytree are looking into heavily, Hopefully we can get something up for you soon!
Cheers
Shaun