SAP HANA agent

Target SAP HANA

Prerequisites

To have Gluesync working on your SAP HANA instance you will need to have:

Valid user credentials with permission to read, and write to the target tables and respective database;
SAP HANA 2.0 SPS04 or above, or SAP HANA Cloud;
For TLS connections: proper SSL certificates configured on the SAP HANA server;

To create a valid user for Gluesync on your SAP HANA database with the minimum required privileges, you can run/adapt the following SQL statements:

CREATE USER GLUESYNC_TARGET_USER PASSWORD 'your_secure_password' NO FORCE_FIRST_PASSWORD_CHANGE;
GRANT CREATE ANY ON SCHEMA TARGET_SCHEMA TO GLUESYNC_TARGET_USER;
GRANT SELECT, INSERT, UPDATE, DELETE ON SCHEMA TARGET_SCHEMA TO GLUESYNC_TARGET_USER;

Setup via Web UI

Hostname / IP Address: DNS record or IP Address of your SAP HANA server;
Port: Optional, defaults to 30015 (single tenant) or 30013 (multi-tenant with MDC). For SAP HANA Cloud, use 443;
Database name: Name of your SAP HANA tenant database (for multi-tenant configurations);
Username: Username with read/write access to target schema;
Password: Password belonging to the given username;
Max connections count: Maximum number of connections the pool can instantiate;
Enable TLS: Optional, defaults to false. Required for SAP HANA Cloud connections.

Specific configuration

This agent has no specific configuration properties.

Setup via Rest APIs

Here following an example of calling the Core Hub’s Rest API via curl to setup the connection for this Agent.

Connect the agent

curl --location --request PUT 'http://core-hub-ip-address/pipelines/{pipelineId}/agents/{agentId}/config/credentials' \
--header 'Content-Type: application/json' \
--header 'Authorization: ••••••' \
--data '{
        "hostCredentials": {
        "connectionName": "myAgentNickName",
        "host": "host-address",
        "port": 30015,
        "databaseName": "HXE",
        "username": "GLUESYNC_TARGET_USER",
        "password": "your_secure_password",
        "maxConnectionsCount": 100,
        "enableTls": true
      }
}'

SAP HANA Cloud specific setup

For SAP HANA Cloud connections, use the following configuration:

curl --location --request PUT 'http://core-hub-ip-address/pipelines/{pipelineId}/agents/{agentId}/config/credentials' \
--header 'Content-Type: application/json' \
--header 'Authorization: ••••••' \
--data '{
        "hostCredentials": {
        "connectionName": "mySAPHANACloudTarget",
        "host": "your-instance.hana.trial-us10.hanatrial.ondemand.com",
        "port": 443,
        "databaseName": "HANADB",
        "username": "GLUESYNC_USER",
        "password": "your_secure_password",
        "maxConnectionsCount": 100,
        "enableTls": true
      }
}'

Performance considerations

UPSERT operations: Gluesync uses SAP HANA’s MERGE statement or UPSERT semantics for optimal insert/update performance during bulk operations.
Column store optimization: When Gluesync creates target tables, it uses SAP HANA’s column store format by default for analytical workloads.
Connection pooling: The agent maintains a connection pool to SAP HANA for efficient concurrent operations.