SAP Bex Web connection

Four Stars

SAP Bex Web connection

Dear community 
Looking to connect to a SAP BW instance via its Netweaver Web interface.
Do I use a HTTP call, or how to manage a SAP Web BI report? Can I submit variable selection parameters from the job and start the query automated?
The report has an entry selection screen, then an output screen with result to be parsed?? Or is there a direct connector to the web interface?
=>
Four Stars

Re: SAP Bex Web connection

Hmm, cannot see my screenshots?
test to upload again
Employee

Re: SAP Bex Web connection

We don't support the BEX interface. We have dedicated components though to interact with DSO, InfoCube and InfoObject. Would that suffice?
Thomas Steinborn
VP Product Management
Four Stars

Re: SAP Bex Web connection

I appreciate, though in most (especially bigger) companies these accesses are strictly governed to stay with developers only.
Hence a more user oriented way would be to be able to read from user facing results which is Bex Web or Excel.
Hence BEx Web can be automatically triggered through calling a URL, I thought I could use HTML PARSE or similar and a trigger call to use it.
This way I could maybe use a bookmarked report, but tHe only thing missing is to enter filter parameters to the startup selection screen of a Bex query.
Maybe this describes better what I am facing.
Employee

Re: SAP Bex Web connection

So you need something like a "REST" call with the right query paramters set and then parse the HTML response, correct?
In that case you can use components like tRestClient or maybe tFileFetch to do so
Thomas
Thomas Steinborn
VP Product Management
Four Stars

Re: SAP Bex Web connection

Sounds very much like it. 
If you happen to know Bex Web client - can you send me a short example how to configure these components?
I never used these two.
Thanks!
Four Stars

Re: SAP Bex Web connection

An example path to one of our reports:
This brings up following screen:
Four Stars

Re: SAP Bex Web connection

Forgot I cannot post links....
xxxx2.eu.xxxx.net:8070/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!2fcom.sap.pct!2fplatform_add_ons!2fcom.sap.ip.bi!2fiViews!2fcom.sap.ip.bi.bex?QUERY=C9_D_C9_RMMM03_SC_FS809_LC9_M
Employee

Re: SAP Bex Web connection

as example for tRestClient
Thomas Steinborn
VP Product Management
Employee

Re: SAP Bex Web connection

or tFetchFile with GET verb and downloading to local file sytem.
Thomas Steinborn
VP Product Management
Four Stars

Re: SAP Bex Web connection

Sorry for late reply. I get a ton of errors using both methods. Must be a security/authentication issue of SAP.
Any other ideas how to fetch a SAP BEX WEB output?
xception in component tFileFetch_1
javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at sun.security.ssl.Alerts.getSSLException(Unknown Source)
at sun.security.ssl.SSLSocketImpl.fatal(Unknown Source)
at sun.security.ssl.Handshaker.fatalSE(Unknown Source)
at sun.security.ssl.Handshaker.fatalSE(Unknown Source)
at sun.security.ssl.ClientHandshaker.serverCertificate(Unknown Source)
Employee

Re: SAP Bex Web connection

sounds just to be an issue of an unknown server cert. Use tSetKeystores to provide the right certs
Thomas Steinborn
VP Product Management
Four Stars

Re: SAP Bex Web connection

I will not give up, thanks!  Although meanwhile, you SAP expert, Robert Zenkert has said that Bex is not supported by Talend at all.
Would be great if we still could find a way - can you maybe also align - you seem to know a way.
Thanks!