Skip to main content
Version: v11.7.1

Connect To SAP Hana Cloud Database


Introduction

This document provides the steps to connect to SAP HANA Cloud Database and configure the relational Database schema in WaveMaker. SAP HANA Cloud is a fully managed in-memory cloud Database as a Service (DBaaS) offered by SAP. It helps manage your data storage and integration while running powerful applications.

Prerequisites

  • SAP HANA Cloud connection details such as:
    • Host
    • DB name
    • DB Credentials
  • Allow connections from WaveMakerOnline (reach out to support for the Gateway IP)

Steps

  1. Navigate to the Databases section and click on the plus icon to add the Database to the project. From the popup, choose Connect To a DB option.

  1. In the next step, choose the Database provider. Select SAP HANA.

  1. In the next step, enter the details of the SAP HANA Cloud Database.
    • Database Info:
      • Username and Password: DB Credentials.
      • Database Name: Provide the name of the Database to connect.
      • Host: Hostname of the Database to connect.
      • Schema Filter: List of schema names to be imported in the WaveMaker.
    • Advanced Settings:
      - **Port**: Port on which SAP HANA is configured (default is 443).
      - **JDBC URL**: JDBC connection string of the DB.
      (Example: **jdbc:sap://< hostname>:< port>/?encrypt=true&validateCertificate=false&nonBlockingIO=false**)

  1. Test the connection and click on the Next button.

  2. Select the desired tables to be imported and click on the Next button. This will now automatically generate the CRUD APIs for the select entities. The imported tables can be viewed from the DB designer.