Extract Data from one BW to another BW using ODP Extraction while using only BW on HANA Objects

[former_member202517]

How to Extract Data from one BW to another BW using ODP Extraction while using only BW on HANA Objects

Earlier we had export datasource but on ADSO this is obsolete.

Is there any blog about the end to end of this process, as i searched many places where there is very limited information but not complete information.

Request to Please share.

Thanks,

Jagadeep.

[shraddha_mundwadkar]

Hi Jagadeep,

Yes you are correct, In Target BW system you should have a ODP_BW connection under ODP folder(Basis should be able to configure it if not there), Once its there you have to create a datasource on ODP_BW in Target BW system and in the steps it will ask you for the source if you do F4 or look for *technical name* of the object you should be able to see the ADSO from the source BW system.

Exchanging Data Between BW Systems Using the ODP Source System | SAP Help Portal this is the only link available you can refer to the procedure section of same. or you can follow below url

or

Data Provisioning Options for SAP BW (ODP) with ODP DEMO example | SAP Blogs - do same steps mentioned in the blog just one change in the " Practical Demo: ODP Source Systems" source systems screen shot you have to use ODP_BW instead of ODP_SAP and rest all steps remains same.

If you find shared info helpful, feel free vote (arrows on left side) for it.

Thanks,

Shraddha

[former_member202517]

Hi shraddha_mundwadkar bhavin.vyas

Thank you for your valuable inputs.

Do we manually create a datasource in target BW system with source as source BW infoprovider (like ADSO) etc.

Is there any blog where I could refer the steps in doing so.

Thanks,

Jagadeep

[bhavinvyas]

Please refer this help page,

Exchanging Data Between BW Systems Using the ODP Source System

Thanks,

Bhavin

[shraddha_mundwadkar]

There is an ODP_BW connection available, where you can have BW DSO's , CP, SPO's , Queries and Infoobjects(Master data ,texts , Hierarchies) should be released as infoproviders. It is accessible via the RFC implementation of the ODP consumer interface.