Creating a Live Data Connection to SAP HANA or SAP HCP via SAP Web Dispatcher;

 

Sharing a functioning Webdispacher profile for reference. Supports HANA Live and BPC Systems

 

=> Install SAP Webdispacher (follow standard install process)

 

=> cat sapwebdisp.pfl

 

# Profile generated by sapwebdisp bootstrap

# unique instance identifier

SAPSYSTEMNAME = WDP

 

# unique instance number

SAPSYSTEM = 88

 

# add default directory settings

DIR_INSTANCE = /usr/sap/SID/sapweb

DIR_EXECUTABLE = $(DIR_INSTANCE)

DIR_PROFILE = $(DIR_INSTANCE)

DIR_HOME = $(DIR_INSTANCE)

Autostart = 1

Restart_Program_00 = local $(DIR_EXECUTABLE)/sapwebdisp$(FT_EXE) pf=$(DIR_PROFILE)/sapwebdisp.pfl

 

# Backend System

wdisp/system_0 = SID=ORI, EXTSRV=https://epmxxxxx.sap1.hana.ondemand.com, SRCURL=/sap, SRCSRV=*:4388, PROXY=proxy:8080 (Our BOC Tenant)

wdisp/system_1 = SID=HDB, EXTSRV=http://hanahost:8004, SRCURL=/myxxsap, SRCSRV=*:4388 ( HDB Instance for HANA Live Connectivity)

wdisp/system_2 = SID=BPC, EXTSRV=http://bpchost:8070, SRCURL=/sap/epm/bpc, SRCSRV=*:4388 ( For Connecting BPC System)

 

# number of parallel connections

icm/max_conn      = 200

 

# SAP Web Dispatcher Ports

icm/server_port_0 = PROT=HTTP,PORT=8088

icm/server_port_1 = PROT=HTTPS,PORT=4388

 

# SAP Web Dispatcher Web Administration

icm/HTTP/admin_0 = PREFIX=/sap/wdisp/admin,PORT=4388,DOCROOT=./admin,AUTHFILE=icmauth.txt

 

wdisp/system_conflict_resolution = 1

 

# URL rewrite

icm/HTTP/mod_0 = PREFIX=/,FILE=./rewrite

 

—————-Also adding file ‘rewrite’ which is critical for successful exchange —————

>cat rewrite

if %{SID} = ORI

begin

SetHeader HOST epmxxxxx.sap1.hana.ondemand.com

RegRewriteResponseHeader location https://epmxxxxx.sap1.hana.ondemand.com:443/(.*) https://webdispacherhost:<wdport>/$1

end

 

if %{SID} = SDB

begin

RegRewriteUrl ^/myxxsap(.*) /$1

end

 

if %{SID} = BPC

begin

SetHeader HOST bpchost

RegRewriteResponseHeader location http://bpchost:8070/(.*) https://webdispacherhost:<wdport>/$1

end

———————————————————————————————————————————

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply