SAP HANA Connector

SAP HANA sits at the center of some of the most complex data estates in the world — finance closes, materials movements, master data, supply chain. The problem has never been that the data isn’t there. It’s that getting a question answered against it has always meant filing a ticket, waiting for an analyst, or learning a tool most business users never will. The SAP HANA connector removes that friction. Connect your HANA instance — on-premise or HANA Cloud — in under two minutes: host, port, credentials, schema, done. SSL/TLS on by default. Test before you save. Once connected, Ana can query HANA directly, join it against anything else you’ve connected — a cloud warehouse, a REST API, a spreadsheet — run analysis on the combined result, and return a narrative with the SQL and the chart. No data movement, no ETL pipeline to maintain, no separate BI layer to configure. The data stays in HANA. Ana comes to it.

​

Supported Deployment Models

TextQL ships a native SAP HANA connector supporting both deployment models out of the box:

• SAP HANA on-premise — direct connection over your network path (VPN, VPC peering, private endpoint, or self-hosted deployment inside the customer’s VPC)
• SAP HANA Cloud — single-toggle configuration that handles port 443 and the TLS server-name requirement automatically

​

Prerequisites

To connect TextQL to your SAP HANA instance, you will need:

• Host — your HANA server hostname or IP address
• Port — typically 39015 for on-premise, 443 for HANA Cloud
• Username and password — a database user with read access to the target schema
• Database name — defaults to SYSTEMDB
• Schema (optional) — the default schema Ana will use for queries

​

Creating the Connector

Navigate to the TextQL Connectors Page and click New Connector. Select SAP HANA from the available connectors.

​

Connection Fields

​

SAP HANA Cloud

Toggle SAP HANA Cloud? when connecting to a HANA Cloud instance. This automatically:

• Forces the port to 443
• Appends the TLS server name to the connection string

You do not need to manually adjust the port or SSL settings when this toggle is on.

​

SSL/TLS

SSL/TLS is enabled by default. For on-premise deployments using self-signed certificates, you can disable the toggle to skip certificate verification — only do this in environments where you control the certificate chain.

​

Testing the Connection

Click Test Connection before saving to verify your credentials and network access. Fix any errors before clicking Create Connector.

​

Troubleshooting

​

Connection timeout

• Verify the host and port are reachable from TextQL’s network (or your VPC, if using a private deployment)
• Confirm no firewall rules are blocking the connection
• For on-premise instances, ensure VPN or VPC peering is active

​

Authentication error

• Double-check the username and password
• Confirm the user has SELECT privileges on the target database and schema
• For HANA Cloud, ensure the user is not subject to an IP allowlist that excludes TextQL

​

Certificate error

• If using a self-signed certificate on-premise, disable Enable SSL/TLS to skip verification
• For HANA Cloud, leave SSL/TLS enabled — HANA Cloud requires TLS

​

Wrong schema or missing tables

• Specify the Schema field explicitly rather than relying on the default
• Confirm the database user has visibility into the schema you expect Ana to query

​

What’s Next

Once your SAP HANA connector is set up:

• Ask Ana natural language questions about your HANA data
• Join HANA tables against other connected sources in a single query
• Build playbooks that run recurring analysis against HANA and deliver results to Slack or Teams
• Use the Ontology layer to define business metrics on top of your HANA schema