PhloemDocs
Markdown
Integration

SAP HANA

SAP HANA in-memory database

Category
Databases
Runs in
The Phloem cloud — nothing to install

Lets you and Hamming query an SAP HANA database with SQL, with its schemas and tables listed in Trace.

What Phloem reads

  • The schemas the user has privileges on, with their tables and columns, listed in Trace for Hamming and SQL autocomplete
  • Schemas starting with SAP or _SYS are left out of Trace, but you can still query them by name

What you need

  • The server's host and SQL port, reachable from Phloem's cloud: 30015 for a tenant database, 30013 for the system database
  • The tenant database name, unless you connect to the system database
  • A database user and password that can read the schemas you want

Connect

  1. In the console, open Connectors, choose Add connector, then SAP HANA.
  2. Enter a Display Name, then Host, Port, Database/Tenant, Username and Password.
  3. Leave Use SSL/TLS on (the default) to encrypt the connection.
  4. Choose Test Connection, then Create Connection.

What Hamming can do

  • Run SQL that you or Hamming write

Notes

  • Phloem runs any statement, not only SELECT. The user's privileges decide what a query can change.
  • Use SSL/TLS encrypts the connection but does not check the server's certificate.

#Connection fields

What the Add connector form asks for.

FieldTypeRequired
Host
SAP HANA server hostname or IP address
hana-host.example.com
TextYes
Port
Default: 30015 for tenant DB, 30013 for system DB
Number—
Database/Tenant
Tenant database name (optional for system DB)
HDB
Text—
Username
SYSTEM
TextYes
PasswordSecretYes
Default Schema
Default schema to use for queries
SYSTEM
Text—
Use SSL/TLS
Enable encrypted connection (recommended)
On / off—

Updated