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