Skip to Content
Author's profile photo Shaun Bradridge

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.

 

 

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Mike Doyle
      Mike Doyle

      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...

      Author's profile photo Shaun Bradridge
      Shaun Bradridge
      Blog Post Author

      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