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.



SAP Cloud Platform Trial account (

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:

        ID INTEGER, 
        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

      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!