SAP HANA

This is the implementation of the SAP HANA data handler for MindsDB.

SAP HANA, where HANA stands for High-performance ANalytic Appliance, is a multi-model database that stores data in its memory instead of keeping it on a disk. The column-oriented in-memory database design used by SAP HANA allows users to run advanced analytics alongside high-speed transactions in a single system.

​

Implementation

This handler is implemented using hdbcli, the Python driver for SAP HANA.

The required arguments to establish a connection are as follows:

• host is the host name or IP address of the SAP HANA instance.
• port is the port number of the SAP HANA instance.
• user specifies the user name.
• password specifies the password for the user.
• schema sets the current schema, which is used for identifiers without a defined schema.

​

Usage

You can use the below SQL statements to create a schema in SAP HANA called MINDSDB and a table called TEST.

CREATE SCHEMA MINDSDB;

CREATE TABLE MINDSDB.TEST
(
    ID          INTEGER NOT NULL,
    NAME        NVARCHAR(1),
    DESCRIPTION NVARCHAR(1)
);

CREATE UNIQUE INDEX MINDSDB.TEST_ID_INDEX
    ON MINDSDB.TEST (ID);

ALTER TABLE MINDSDB.TEST
    ADD CONSTRAINT TEST_PK
        PRIMARY KEY (ID);

INSERT INTO MINDSDB.TEST
VALUES (1, 'h', 'w');

In order to make use of this handler and connect to the SAP HANA database in MindsDB, the following syntax can be used:

CREATE DATABASE sap_hana_trial
WITH
    ENGINE = 'hana',
    PARAMETERS = {
        "user": "DBADMIN",
        "password": "password",
        "host": "<uuid>.hana.trial-us10.hanacloud.ondemand.com",
        "port": "443",
        "schema": "MINDSDB",
        "encrypt": true
    };

You can use this established connection to query your table as follows:

SELECT *
FROM sap_hana_trial.test;

On execution, we get: