Configure access to SAP HANA configure-access-to-sap-hana

Install the ODBC drivers for SAP HANA, according to the operating system that you use:

• hdb_client_linux.tgz for Linux. Once unzipped, launch the hdbinst command and follow the instructions to finish installing the drivers.
• hdb_client_windows.zip for Windows. Unzip the file and start the executable: hdbinst.exe. Follow the assistant instructions to finish installing the drivers.

Configure the ODBC driver. The configuration can be carried out in the standard files: /etc/odbc.ini for general parameters and /etc/odbcinst.ini for declaring drivers.

• /etc/odbc.ini

  code language-none
  [ODBC] InstallDir=/etc/ [HDB] Driver=HDBODBC servernode=localhost:39013 (this value depend of your server) User:SYSTEM

  “InstallDir” corresponds to the location of the odbcinst.ini file.

• /etc/odbcinst.ini

  code language-none
  [HDBODBC] Description = "SmartCloudPT HANA" Driver = /usr/sap/hdbclient/libodbcHDB.so

Specify the environment variables of the Adobe Campaign server:

• LD_LIBRARY_PATH: It should include the link to your SAP Hana client (https://experienceleague.adobe.com/usr/sap/hdbclient/libodbcHDB.so?lang=en) by default).
• ODBCINI: location of the odbc.ini file (for example /etc/odbc.ini).

From Campaign Explorer, click Administration ‘>’ Platform ‘>’ External accounts.

Click New and select External database as Type.

To configure the SAP Hana external account, you must specify:

• Type: SAP Hana

• Server: URL of the SAP Hana server

• Account: Name of the user

• Password: User account password