Extract data from BW ODS to external application

[Former Member]

Hello,

We have the following interface challenge:

We need to interface data from an ODS to an external application. The request for this data comes from the external application and contains selection parameters.

The datasets are small and the responses need to be fast.

How to do this?

We do not want to use Query_data_view, it is not performing and contains too much meta data

Preferably we define a webservice either in BW or XI/PI that receives the request and send back the answer.

What are the possibilities/best practices?

Brokered or non-Brokered?(using XI or PI or just using an BW webservice)

Do we need to publish the webservice to an UDDI?

How do we extract the data from the ODS, via a Function module? If so i guess that FM can be made externally available and callable from XI/PI.

Does ehp1 provide more fucntionalities in this area than 7.00?

Does PI provide more functionalities than XI in this area?

Do we need proxies for this?

Thanks for any insights

[Former Member]

Tom,

How to do this?

External application (SOAP request) <-> PI <-> SAP BW (ABAP Proxy response). Make both - web service and proxy - sync.

Preferably we define a webservice either in BW or XI/PI that receives the request and send back the answer.
What are the possibilities/best practices?

Web service will be defined in external application, proxy will be created in BW. Search on SDN for the detailed steps.

Brokered or non-Brokered?(using XI or PI or just using an BW webservice)

If you have PI as the integration hub, then prefer using PI.

Do we need to publish the webservice to an UDDI?

Not required.

How do we extract the data from the ODS, via a Function module? If so i guess that FM can be made externally available and callable from XI/PI.

Call the function module / any other extraction program from the proxy. No need to make FM externally available.

Does ehp1 provide more fucntionalities in this area than 7.00?
Does PI provide more functionalities than XI in this area?
Do we need proxies for this?

PI 7.1 EhP1 SP 6 is the latest, so it will definitely provide more functionality over older versions.

Yes, use proxy at BW side.

Hope this answers all your questions.

Regards,

Neetesh