Connect SAP BW to Google Analytics

[j_vandersterren]

Hi,

We want to connect SAP BW to Google analytics.

Unfortunately we cannot use Data Services.

Flat files extraction is probably an option, but is there an alternative?

We are using SAP BW 7.0

Please advise.

Regards,

Jos.

[Former Member]

HI, Jos van der Sterren.

Is there any examples to do it???

Thanks,

Alex.

[j_vandersterren]

Hi Alex,

We solved it by creating an ABAP which calls a web service.

This web service returns a file which will be saved on the SAP directory.

A Process Chain (flat file) can read this file and store it in BW.

Regards,

Jos.

[Former Member]

Jos, can you explain in more detail, with example, please. If honestly, I don't understand how to do this.

Thanks,

Alex.

[j_vandersterren]

any suggestions?

for the time being we have the following solution:

- Create ABAP which calls a web service and returns a list (CSV format);

- file CSV format on SAP dir.

- In process Chain check if file is available

- If yes load data to DSO.

[john_lang]

Hi Jos,

You could simplify the process by moving the ABAP into a different part of the ETL and bypassing the need to output/input a file.

Option 1: Use the API to write directly into a DataStore. See

Option 2: Define a function module generic extractor (in BW) and instead of outputing CSV you output the transaction data records as DataPackets. See http://help.sap.com/saphelp_nw70/helpdata/en/3f/548c9ec754ee4d90188a4f108e0121/content.htm

Hope this helps.

Kind regards,

John.