topic Re: SAP Bex Web connection in Talend Studio

SAP Bex Web connection

Anonymous — Tue, 20 Dec 2016 14:45:38 GMT

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?
=>

Re: SAP Bex Web connection

Anonymous — Tue, 20 Dec 2016 14:48:49 GMT

Hmm, cannot see my screenshots?
test to upload again

Re: SAP Bex Web connection

Anonymous — Fri, 23 Dec 2016 11:43:21 GMT

We don't support the BEX interface. We have dedicated components though to interact with DSO, InfoCube and InfoObject. Would that suffice?

Re: SAP Bex Web connection

Anonymous — Fri, 23 Dec 2016 12:06:49 GMT

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.

Re: SAP Bex Web connection

Anonymous — Fri, 23 Dec 2016 14:01:41 GMT

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

Re: SAP Bex Web connection

Anonymous — Fri, 23 Dec 2016 14:21:49 GMT

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!

Re: SAP Bex Web connection

Anonymous — Fri, 23 Dec 2016 14:23:36 GMT

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

Re: SAP Bex Web connection

Anonymous — Fri, 23 Dec 2016 14:24:38 GMT

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

Re: SAP Bex Web connection

Anonymous — Tue, 27 Dec 2016 09:36:26 GMT

as example for tRestClient

Re: SAP Bex Web connection

Anonymous — Tue, 27 Dec 2016 09:38:49 GMT

or tFetchFile with GET verb and downloading to local file sytem.

Re: SAP Bex Web connection

Anonymous — Tue, 07 Feb 2017 11:01:23 GMT

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)

Re: SAP Bex Web connection

Anonymous — Wed, 08 Feb 2017 11:36:26 GMT

sounds just to be an issue of an unknown server cert. Use tSetKeystores to provide the right certs

Re: SAP Bex Web connection

Anonymous — Wed, 08 Feb 2017 11:59:13 GMT

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!

Re: SAP Bex Web connection

Anonymous — Tue, 16 Apr 2019 10:57:56 GMT

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.

please put this on your development roadmap!

Thanks!

Re: SAP Bex Web connection

Prakhar1 — Fri, 15 Jan 2021 14:07:29 GMT

Any idea on this topic? i also want to do this..