Configure the SAP® HANA® ODBC publish target

Install the SAP HANA server and the SAP HANA Database Client.

Create the SAP HANA ODBC target before you configure it. For more information, see Add a publish target.

Verify the following permissions for the SAP HANA ODBC target:

• By default within SAP HANA, ODBC access to SAP HANA data is enabled for all users. You can limit access by disabling ODBC access in SAP HANA for specific users. However, be sure that the SAP HANA user that you enter in the PI Integrator for Business Analytics publish target configuration has the following access permissions:.

  • Select permission on SYS.SCHEMAS, SYS.TABLES, and SYS.TABLE_COLUMNS.

  • The following permissions on the schema(s) where tables will be created:

  • ALTER

  • CREATE ANY

  • DELETE

  • DROP

  • EXECUTE

  • INSERT

  • SELECT

  • UPDATE

1. Configure the SAP HANA ODBC target with the following parameters:

   Parameter	Description
   Hostname	Host name or IP address of the SAP HANA server.
   Port	Port number used to connect to the SAP HANA instance.
   Username	Username used to connect to the SAP HANA instance.
   Password	Password used to connect to the SAP HANA instance.
   Database	(Optional) If there are multiple databases in the instance, the database to which to connect.
   Use TLS/SSL Connector	Use TLS/SSL to connect to the SAP HANA server. Note: Only certificates stored in the SAP HANA certificate store are supported.

2. Click Get Schemas to populate the schema list.

3. Select the schema where the tables are written from the list.

   Note: If the list is empty, then one or more of the parameters is incorrect.

4. Click Connect to verify that you can open the ODBC connection to SAP HANA.

5. Click Save Changes.

Give users access to the SAP HANA target. For more information, see Grant access to targets.