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

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)

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

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

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"

• How to find User Assistance for SAP Analytics Cloud?
• Ask a question on the SAP Community!
• 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)

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.

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