Connection String for SAP HANA


This page describes how to set the connection string for an SAP HANA system.

Entries into the Sensitive Part field will be stored encrypted in Salesforce. If you want to secure the username also, include it in the field separated by a semi-colon.

The <hostname> can be either an IP address or system name.

All keys are case insensitive and may be entered in the connection string in any order. All values except PASSWORD must be terminated with a semi-colon (;).

The full list of supported connection properties is available from the SAP HANA documentation.


Format

Enter the following text into the Connection String field

SERVER=<hostname>:<port>; DATABASE=<database name>; UID=<username>;

Enter the following text into the Sensitive Part field

PWD=<password>

 

Sample

Enter the following text into the Connection String field

SERVER=10.100.100.1:3000; DATABASE=SAMPLE; UID=user1;

Enter the following text into the Sensitive Part field

PWD=mypassword

 

Each time you create or modify a connection string in Overcast, validate your connection by clicking the Check button to ensure the connection can be established successfully. 

 

Parameter Keys

Key Description
SERVER IP address or system name and port
DATABASE Database name
UID, USERID, USERNAME Username
PWD, PASSWORD, PASSWD Password

 

The full list is available from the SAP HANA documentation. Connection properties are passed through to the database engine but some properties are removed for security reasons.

 

1. Go to the Connection Strings tab and select the New button.

 

2. Enter a Connection String Name and select "HANA DB" for Connection Type. Enter your Connection String and its Sensitive Part as described above, and select Save. Description and Named Credential are optional.

 

3. Select Check to validate your connection. A green checked circle will appear once a successful connection is established.

 

Access via Secure Agent

To access a HANA DB through the Overcast Secure Agent, you must install the 64-bit SAP HANA DB ODBC drivers for Windows and the SAP ADO.NET drivers. The driver can only be downloaded through the SAP Downloads Software Center.  

 

Follow the guide for ODBC and ADO.NET driver installation. In summary, after installing the HDBClient, run the following command to install the drivers into the .NET Framework GAC.

c:Program Filessaphdbclientado.netv4.5SetupNet.v4.5.exe /i /hl "C:Program Filessaphdbclientado.net"

An ODBC User or System DSN is not needed. The HDBODBC entry should appear in the 64-bit ODBC Drivers tab in Windows. 

 

You will encounter an error like the following if the ADO.NET drivers are not installed correctly.

Could not load file or assembly 'Sap.Data.Hana.v4.5, Version=2.6.61.0, Culture=neutral, PublicKeyToken=0326b8ea63db4bc4' or one of its dependencies. The system cannot find the file specified.

 

Blocked Properties

The following connection properties are not passed through to the database engine for security reasons.