Connect SAP HANA

The SAP HANA source reads tables from an SAP HANA database into the Lake. Use this page to fill in each field of the SAP HANA form. The steps shared by every SQL engine are on Connect a SQL database.

---

Prerequisites

• An SAP HANA user with read access to the schemas and tables you want to load.
• The SQL port of the tenant database you want to read, usually 30015. The database accepts connections from DataMind on that port.
• Create/Edit Lake Objects in DataMind. See Who can do what in the Lake.

---

Add the source

1. Open Lake and click Add datasource, or open the New menu in the toolbar above the tree.
2. Choose SAP HANA in the picker.
3. Fill in the General, Connection and Datetime steps as described below.
4. Click Add.

---

Connection settings

General step

Name (Mandatory)

• The name the source carries in the Lake.
• At least 3 characters. The field reads Enter name until you type.

Code (Mandatory)

• A short code, at least 2 characters, made of letters and numbers only.
• It becomes the prefix of the table names the source forms. It fills in from Name while you type; edit it to set your own.
• Name and Code cannot be changed after the source is created.

Folder (Optional)

• The Lake folder the source is filed under. Leave it empty to keep the source at the top level.

Connection step: Address

Paste connection string (Optional)

• Click Paste connection string, paste a JDBC URL, and click Fill.
• Example: jdbc:sap://<server>:30015/.
• The string fills Host and Port, and Database when the URL carries databaseName. A password inside it is never read.

Host (Mandatory)

• The server name or IP address of the SAP HANA database.

Port (Mandatory)

• The SQL port of the tenant database you want to read. The port decides which tenant database the source reaches.
• Default: 30015. A whole number from 1 to 65535.

Database (Optional)

• Leave it empty. The placeholder reads All databases.
• With the field empty, the Lake lists every schema the user can read.

Connection step: Authentication

Username (Mandatory)

• The SAP HANA user the source signs in with.

Password (Mandatory)

• The password of that user.
• After you save, the field reads Stored password with Replace beside it. The password is never shown again.

Connection step: Security

SSL/TLS (Optional)

• Leave it off. The SAP HANA source connects the same way with the switch on or off.
• Default: off.

Datetime step

Timezone (Optional)

• The IANA timezone the database writes its datetime values in, for example Europe/Berlin.
• Leave it empty when the database runs in the same timezone as the platform.

Datetime values (Optional)

• Keep as written (wall clock) (default) stores each value exactly as the database shows it.
• The other option converts each value from the source timezone into platform time on load.

Timezones and datetime values explains both settings in full.

---

Test and save

1. On the Connection step, click Test connection. The button reads Testing… while it runs.
2. Connection test passed means DataMind reached the database and signed in. Connection test failed shows the server's message with a copy button; fix the settings and test again.
3. On Datetime, check the summary: Name, Server, Database (or All databases), Username and Security.
4. Click Add. Then import its tables.

The test is optional and never saves the source. To edit or duplicate the source later, see Connect a SQL database.

---

Questions, answered

Why does each SAP HANA schema show as a database with one schema named default?

The Lake shows each SAP HANA schema as a database with a single schema called default, and the tables sit under it. A table you import from schema SALES is read from SALES on the server.

Which schemas does the Lake list?

The schemas on which the source user holds privileges. Schemas whose name starts with an underscore are not listed. Grant the user read access to another schema to see it.

Are views listed?

No. The SAP HANA source lists tables, both row and column tables. Views are not offered for import.

Which port do I enter for a tenant database?

The SQL port of that tenant database. The form starts on 30015; your SAP HANA administrator can confirm the port of each tenant. Leave Database empty: the port alone decides which tenant database the source reads.

Which sync types can an SAP HANA table use?

The same sync types as the other SQL sources, with no SAP HANA-specific restriction. Sync types explains each one.

Can I send data back to SAP HANA?

No. SAP HANA is a source only and is not offered as a Writeback destination. The destinations are listed on Add and manage destinations.