How to connect SAP HANA Cloud from DBeaver

01/02/2021

6402

Dear SAPLearners, in this blog post you will learn the steps to connect SAP HANA Cloud from DBeaver, a free and open-source universal database tool to manage SAP HANA cloud database.

Prerequisites

Step-by-Step Procedure

Please follow the below steps to connect the SAP HANA Cloud database to manage database artifacts in DBeaver.

SAP HANA JDBC Driver.

Download the SAP HANA JDBC driver ngdbc.jar from here. Connect DBeaver to SAP HANA Cloud Step1

Extract and execute the jar file

After downloading the jar file, extract and execute the jar file which will install/set the SAP HANA JDBC drivers onto your local machine. Connect DBeaver to SAP HANA Cloud Step2

New Database Connection

Launch the DBeaver application, click on New Database Connection, and select the SAP HANA database driver. Click Next. Connect DBeaver to SAP HANA Cloud Step3

Connection Settings

Under the General section enter SAP HANA Cloud Host and Port details. Provide authentication details with which you want to connect to the SAP HANA database and click Ok. Connect DBeaver to SAP HANA Cloud Step4

Successfully connected.

Connect DBeaver to SAP HANA Cloud Step5

Now that we have successfully established a connection between DBeaver and SAP HANA Cloud database. Let’s create a table from the DBeaver tool.

Create a Table in SAP HANA Cloud

1. Right-click on the schema in which table is to be created and select Create New Table.

Create Table in DBeaver for SAP HANA Cloud Step1

2. Enter Table Name and right-click on the Columns section. Choose to Create New Column to create a column in the table.

Create Table in DBeaver for SAP HANA Cloud Step2

3. Add column details like Name, Data Type, Length, etc. in the pop-up window.

Create Table in DBeaver for SAP HANA Cloud Step3

4. Repeat steps 3 & 4 to add all columns to the table.

Create Table in DBeaver for SAP HANA Cloud Step4

5. Go to the Unique Keys section. Right-click and choose Create New Unique Key. Select the columns which should be marked as Primary Key. Similarly, you add all other keys to the table.

Create Table in DBeaver for SAP HANA Cloud Step5

6. Finally, click on Save and then Persist to create the table in SAP HANA Cloud.

Create Table in DBeaver for SAP HANA Cloud Step6

7. Navigate back to SAP HANA Cloud to verify the table creation and you can see the table is successfully created in SAP HANA Cloud.

Create Table in DBeaver for SAP HANA Cloud Step7

Conclusion

Congrats!! you have successfully learned the steps to connect SAP HANA Cloud from DBeaver and also create a new table in SAP HANA Cloud from the DBeaver tool. This is just an introductory blog post and we will be writing more tutorials on DBeaver and SAP HANA Cloud.