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.

  1. Configure SAP HANA database
  2. 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:

  1. 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.
  2. 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
      
  3. 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.

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

  2. Click New and select External database as Type.

  3. 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

recommendation-more-help
601d79c3-e613-4db3-889a-ae959cd9e3e1