SAP HANA Database

Create an SAP HANA Database datastore to connect to an SAP HANA database.

SAP HANA database datastores support a number of specific configurable options. Configure the datastore to match your SAP HANA configuration.

Note

HANA modeling views such as attribute views, analytical views, and calculation views from a SAP Cloud Integration for data services (HANA schema) datastore, can be used as a data source.

Option	Possible Values	Description
Name	Alphanumeric characters and underscores	The name of the object. This name appears in the datastores tab and in tasks that use the datastore.
Description	Any text	The description of the datastore.
Type	Database	Select the type of datastore to which you are connecting.
Database	SAP HANA	A type of SAP HANA Database
Agent	The agents that have been defined in the agents tab	Specifies the agent that should be used to access this data source.
HANA version	HANA 1.x or HANA 2.x	Select the version of the HANA datastore to which you are connecting.
Use Data Source (ODBC)	Yes No	Select to use a DSN to connect to the database. By default, this option is set to Yes. To use a DSN connection, you must also specify the ODBC data source name. If you set this option to No, you must also specify the Database server name, Database name, and Port number for a DSN-less connection.
ODBC data source name	Refer to the requirements of your database	The ODBC data source name (DSN) defined for connecting to your database. This option is required if Use Data Source (ODBC) is set to Yes.
Database server name	Refer to the requirements of your database	The HANA database server name. This option is required if Use Data Source (ODBC) is set to No.
Port number	Integer	The number of the database port. This option is required if Use Data Source (ODBC) is set to No.
User name	Alphanumeric characters and underscores	The name of the account through which the software accesses the SAP application server.
Password	Alphanumeric characters, underscores, and punctuation	The password of the account through which the software accesses the database.
Additional connection information	Alphanumeric characters and underscores or blanks	Information for any additional parameters that the data source supports (parameters that the data source's ODBC driver and database support). Uses the format: `<parameter1=value1; parameter2=value2>`
Use SSL encryption	yes no	SSL encryption protects data as it is transferred between the database server and the Agent. The default is Yes. Selecting Yes displays the Validate Server Certificate and Server Certificate Hostname fields
Validate Server Certificate	yes no	Indicates whether to use server certificate authentication. The default is No. Setting this to Yes requires you to provide a certificate keystore.
Server Certificate Hostname	Alphanumeric characters and underscores	Specifies the hostname used to verify server’s identity. The host name specified here verifies the identity of the server instead of the host name with which the connection was established. For example, if a connection is established to the same host, it might be established to localhost instead of the actual host name in the certificate. Note This parameter should be used only if you absolutely require it for your use case, such as in the example given above, since it bypasses the security of validating the established connection. In most cases, it would not be used.
Use Client Certificate Authentication	yes no	Indicates whether to use client certificate authentication. The default is No. Setting this to Yes requires you to enter a certificate keystore and hides the User name and Password fields under Credentials. Setting this to No indicates authentication is done using the User name and Password fields under Credentials.
Certificate Keystore	Alphanumeric characters, underscores, and punctuation	Name of the certificate keystore PSE file that contains the client and/or server identities. This file is located either in SECUDIR or in a path you specify, which should be validated against your AllowedList. Required when Validate Server Certificate or Use Client Certificate Authentication is set to Yes.
Rows per commit	Positive integer Default: 1000	Enter the maximum number of rows loaded to a target table before saving the data. This value is the default commit size for target tables in this datastore. You can overwrite this value for individual target tables.
Overflow file directory	Directory path	Enter the location of overflow files written by target tables in this datastore. You can enter a variable for this option.
Additional session parameters	A valid SQL statement or multiple SQL statements delimited by semicolon	A valid SQL statement or multiple SQL statements delimitated by semicolon.