Configure access to SAP HANA configure-access-to-sap-hana
Use Campaign Federated Data Access (FDA) option to process information stored in an external databases. Follow the steps below to configure access to SAP HANA.
- Configure SAP HANA database
- Configure the SAP HANA external account in Campaign
SAP HANA drivers sap-config
Connecting to an SAP HANA external database in FDA requires certain additional configurations on the Adobe Campaign server:
-
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 wizard 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).
SAP HANA external account sap-external
The SAP HANA external account allows you to connect your Campaign instance to your SAP HANA external database.
-
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
-