SAP HANA

This documentation describes the integration of MindsDB with SAP HANA, a multi-model database with a column-oriented in-memory design that stores data in its memory instead of keeping it on a disk. The integration allows MindsDB to access data from SAP HANA and enhance SAP HANA with AI capabilities.

​

Prerequisites

Before proceeding, ensure the following prerequisites are met:

1. Install MindsDB locally via Docker or Docker Desktop.
2. To connect SAP HANA to MindsDB, install the required dependencies following this instruction.

​

Connection

Establish a connection to SAP HANA from MindsDB by executing the following SQL command and providing its handler name as an engine.

CREATE DATABASE sap_hana_datasource
WITH
    ENGINE = 'hana',
    PARAMETERS = {
        "address": "123e4567-e89b-12d3-a456-426614174000.hana.trial-us10.hanacloud.ondemand.com",
        "port": "443",
        "user": "demo_user",
        "password": "demo_password",
        "encrypt": true
    };

Required connection parameters include the following:

• address: The hostname, IP address, or URL of the SAP HANA database.
• port: The port number for connecting to the SAP HANA database.
• user: The username for the SAP HANA database.
• password: The password for the SAP HANA database.

Optional connection parameters include the following:

• ‘database’: The name of the database to connect to. This parameter is not used for SAP HANA Cloud.
• schema: The database schema to use. Defaults to the user’s default schema.
• encrypt: The setting to enable or disable encryption. Defaults to `True’

​

Usage

Retrieve data from a specified table by providing the integration, schema and table names:

SELECT *
FROM sap_hana_datasource.schema_name.table_name
LIMIT 10;

Run Teradata SQL queries directly on the connected Teradata database:

SELECT * FROM sap_hana_datasource (

    --Native Query Goes Here
    SELECT customer, year, SUM(sales)
        FROM t1
        GROUP BY ROLLUP(customer, year);

    SELECT customer, year, SUM(sales)
        FROM t1
        GROUP BY GROUPING SETS
        (
        (customer, year),
        (customer)
        )
    UNION ALL
    SELECT NULL, NULL, SUM(sales)
        FROM t1;    

);

​

Troubleshooting