Details on SAP HANA Connection

Connect to

Select which type of SAP HANA data you are going to connect to:

• Relational data

• Multidimensional data

Connect using SSL

The SAP HANA connector has SSL support.

Note: If you are using Kerberos authentication with delegated credentials on your Spotfire Server, you cannot use this connector with SSL in Spotfire web clients. The ODBC driver provided by the database vendor expects to find SSL certificate information in user specific directories or Windows registry entries. These are not available on the server when using Kerberos with delegated credentials.

Include system schemas

Select this check box if you want system tables to be included.

   Show column labels for calculation views

Select this check box if you want to use display names, instead of technical names, for columns originating from calculation views.

   Language

Make a selection in the drop-down list to view data in a specific language.

Authentication method

The authentication method to use when logging into the database. Choose from Username and password, or Kerberos authentication.

Username and password

With Username and password authentication, the authentication is done using a database user. Database credentials can be stored, unencrypted, as part of the analysis file, using a setting in the Data Source Settings dialog. If credentials are found in the analysis file, they will be used to automatically authenticate against the database.

If no credentials or credentials profiles are found in the analysis file, all who open the file will be prompted for database credentials.

Note that there will be no prompting for credentials if the credentials embedded in the analysis file fail.

Kerberos

When using Kerberos authentication, the access token of the logged in user will be used. Users that have been given the appropriate access rights to SAP HANA will be able to connect and read data.

Domain credentials are not stored in the analysis file.

Option

Description

Connection timeout (seconds)

Specifies the maximum time, in seconds, allowed for a connection to the database to be established.

Note: By default, this field is left blank, and the default timeout settings in the data source driver will be used.

Special property settings

Use this control to specify additional ODBC connection properties that you want to use to connect to your SAP HANA instance. This enables you to configure and use connection properties that are supported by the SAP HANA ODBC driver, but for which there are no dedicated controls in Spotfire.

In the Special property settings control, each row represents a connection property. To add and configure a connection property, enter the name of the connection property in Property field, and enter the value in the Value field.

For more information about the available and supported ODBC connection properties, see the official documentation from SAP; SAP HANA Client Interface Programming Reference.

Note: The connection property names that you enter in the Property field must be exact. Depending on the version of the ODBC driver you use, the property names might be case sensitive.

When you enter a name and value for a connection property, a new row is added where you can add additional properties. To remove a connection property that you have added, click the leftmost cell in the row to select the entire row, and then press the Delete key.

Tip: If your keyboard does not have a Delete key, use the corresponding keyboard shortcut instead. On a Mac computer, for example, the keyboard shortcut is Fn + Backspace.