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?
=>
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!
Bumping up this topic, as it still does not seem to have a solution. As said big corporations (~1bn turnover upwards) do not support direct connections to backend for users.
I have seen meanwhile ETL tools that can easily handle SAP Web BEX interfaces.
Any chance the Gartner top Quadrant company could develop this already in the last 3 years we are discussing this?
I am sitting now again in another company with 50.000 cells standard download limit, so we need to iterate 10-15 reports manually to download full data set (and a simple one like current inventory on detailed level).
Talend would be a dream to do this scheduled in the background.
