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? =>
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.
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
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
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)
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!