docs/integrations/data-integrations/sap-hana.mdx
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.
Before proceeding, ensure the following prerequisites are met:
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:
schema: The database schema to use. Defaults to the user's default schema.encrypt: The setting to enable or disable encryption. Defaults to `True'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;
);