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;    

);
The above examples utilize sap_hana_datasource as the datasource name, which is defined in the CREATE DATABASE command.

​
Troubleshooting

Database Connection Error
  • Symptoms: Failure to connect MindsDB with the SAP HANA database.
  • Checklist:
    1. Make sure the SAP HANA database is active.
    2. Confirm that address, port, user and password are correct. Try a direct connection using a client like DBeaver.
    3. Ensure a stable network between MindsDB and SAP HANA.
SQL statement cannot be parsed by mindsdb_sql
  • Symptoms: SQL queries failing or not recognizing table names containing spaces or special characters.
  • Checklist:
    1. Ensure table names with spaces or special characters are enclosed in backticks.
    2. Examples:
      • Incorrect: SELECT * FROM integration.travel-data
      • Incorrect: SELECT * FROM integration.‘travel-data’
      • Correct: SELECT * FROM integration.`travel-data`