Connect to HANA MDC, Create Schema & first DB table

[former_member369619]

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.