SAP Knowledge Base Article - Public

2561570 - What profile and HttpModHandler entries are required in SAP Web Dispatcher for SAP HANA Live Path connection in SAP Analytics Cloud (BOC)?

Symptom

What profile and HttpModHandler entries are required in SAP Web Dispatcher for SAP HANA Live Path connection in SAP Analytics Cloud (formerly known as SAP BusinessObjects Cloud / BOC)

Environment

  • SAP Analytics Cloud
  • SAP Web Dispatcher
  • SAP HANA, S/4HANA

Cause

Want to connect to SAP HANA with a Live Data Source Connection using Path in SAP Analytics Cloud

Resolution

Example SAP Analytics Cloud Tenant: https://mytenant.us1.sapanalytics.cloud

Example SAP Web Dispatcher: https://mydispatcher:4310

Example SAP HANA: http://myhana:8000

Assume User Name and Password authentication

  1. Add profile entries (default file is sapwebdisp.pfl)
    • wdisp/system_conflict_resolution = 1
    • wdisp/system_0 = SID=HDB, EXTSRV=http://myhana:8000, SRCURL=/mypath, SRCSRV=*:4310, STANDARD_COOKIE_FILTER=OFF
    • wdisp/system_1 = SID=SAC, EXTSRV=https://mytenant.us1.sapanalytics.cloud:443, SRCSRV=*:4310, SRCURL=/, STANDARD_COOKIE_FILTER=OFF
  2. Add HttpModHandler entries (default file is rewrite.txt)
    • if %{SID} = SAC
        begin
          SetHeader X-Custom-Host mytenant.us1.sapanalytics.cloud
          RegIRewriteResponseHeader LOCATION https://mytenant.us1.sapanalytics.cloud(.*) https://mydispatcher:4310/$1
        end
    • if %{SID} = HDB
        begin
          SetHeader clientProtocol HTTP
          RegRewriteUrl ^/mypath(.*) /$1
      end

  3. Check http://myhana:8000/sap/hana/ide/editor/index.html?startURI=sap/bc/ina/service/v2/.xsaccess&fileLine=1 and if "cors" is present add "https://mydispatcher:4310" to "allowOrigin"

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

reverse, web dispatcher, webdispacher, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, web, dispatcher, CORS, 403 , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , How To

Product

SAP Analytics Cloud 1.0