Send Data out of BW

[Former Member]

I want to use openhub to send data out BW. But my question is how do I recieve a request in BW saying that I want this fields from BW?

Secondly, other than open hub what all options do we have to send data out of BW?

Also, Can we push data out of source system to BW? I dont want to pull data from source system.

Please help me out with my questions.

Thanks in advance.

Sam

[Former Member]

Hi Shylaja,

Can u please tell me the Pros and Cons of using PUll and PUSH from the Source system to BW.

Thanks a lot.

Sam.

[Former Member]

Hi,

Push data out into BW means that data is sent to BW as soon as it arrives(<b>Synchronously</b>) in Source system(R/3).

Pull data from source system means when ever a request is received by the source system, it sends the data from the source system.(<b>Asynchronous/Rquires Scheduling</b>).

Hope its clear.

Shylaja.

[Former Member]

Thanks a lot AHP for a quick response. Can ypu please provide some more information like:

What are the implication when u push data from Source system to BW compare to Pull data from the source system.

Your reply wouldbe highly appreciated.

Thanks a lot.

[edwin_harpino]

hi,

take a look sap help open hub doc

http://help.sap.com/saphelp_bw33/helpdata/en/ce/c2463c6796e61ce10000000a114084/frameset.htm

http://help.sap.com/saphelp_bw33/helpdata/en/66/76473c3502e640e10000000a114084/frameset.htm

the other ways

1. program rscrm_bapi

https://websmp202.sap-ag.de/~sapdownload/011000358700004400232004E/HowToRSCRM_BAPI.pdf

2. abap

/people/durairaj.athavanraja/blog/2005/04/03/execute-bw-query-using-abap-part-i

/people/durairaj.athavanraja/blog/2005/04/03/execute-bw-query-using-abap-part-ii

/people/durairaj.athavanraja/blog/2005/12/05/execute-bw-query-using-abap-part-iii

3. olap bapi

http://help.sap.com/saphelp_bw33/helpdata/en/64/9b8f3c855f0454e10000000a11405a/frameset.htm

4. odbo - vb/.net/c sharp

'connecting to sap bw using vb and ado md'

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/ee19e9c7-0301-0010-8f84-97e...

'connecting to sap bw with excel and odbo'

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/a06a51f3-0201-0010-8591-b74...

'odbo'

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/7f88b390-0201-0010-ae94-fdf...

'sap .net connector' (seems old version)

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/fb4dc990-0201-0010-429a-bf4...

.net connector

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/5a04426d-0601-0010-5e99-aee...

'Access SAP BW ODS BAPI Using C-Sharp and SAP .NET Connector 2.0' doc can be download here

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/12f6d390-0201-0010-e18d-cdb...

hope this helps.