Write data from SAP BW into an external system

[Former Member]

Hi everyone,

I read that UD connect enables to extract data from an external system into SAP BW, I would like to know if there is a way to insert data from SAP BW into the table of the external system.

Thanks for your help. 

Mario        

[former_member526411]

Hi all,

regarding the question of Mario, does anyone knows if there is a java method/funcionality to write records in a table/view of an external system (no SAP)?

Thanks in advance,

Alessandro

[former_member183121]

This message was moderated.

[Former Member]

Hi Mario,

Open Hub Destination functionality suits your requirement.

Thanks,

Purushotham.

[former_member229708]

Hi Mario,

SAP having OPENHUB Destination concept for sending data from BW to external system.  

Try to search with “OPENHUB Destination” there are documents in SDN which explaining
implementation steps in details. 

Thanks & Regards,

Vipin

[jaigupta]

Hi Mario,

If you have SAP PI implemented in your landscape then you can use ABAP proxy via open hub for this purpose otherwise you can use open hub to save the data in the flat files or BW and then can load this data into your system.

Regards,

Jai

[former_member183012]

Hi Mario,

Please search on google with keyword "openhub destination".

You will find step by step document for transfering data from BW to file,database table,Third party tool.

Hope it will help .

Regards,

Ganesh Bothe

[Former Member]

Hi Ganesh,

thanks for you reply.

I created the open hub destination as third party tool. In addition I wrote records into the hub (/bic/oh...), I would like to know what is the best way to transfer those records to the external target system.

Should I create an InfoSpoke?

Thanks in advance,
Mario

[RamanKorrapati]

Hi,

info spoke is bw 3.x version, open hub destination concept is bw 7.x version. both are same.

As per your bw version you can info spoke or open hub destination concept.

if you have very less data then go with flat file concept other wise choose table concept in open hub.

there is no specific cases to use them. its all depend on client needs.

for ex: if you client need to load the same data to another requirement. in that case if we have required data in flat file format then it can be used easily.

Thanks

[Former Member]

Hi,

thanks for you reply.

After that I load the open hub destination as third party tool, should I use an API that allows you to transfer data to external target system?

Then this API must be implemented in SAP BW or into the external system?

Thanks in advance,
Mario

[RamanKorrapati]

Hi,

Thru open hub which destination you like to load? to flat file type or table type?

What is your external system?

Thanks

[Former Member]

Hi Mario,

Using Open Hub Destination you can write data to a table in SAP BW system to put this data in external system you can pull the data or write ABAP program to insert data intot external system.

Also you can use SAP XI for same.

Regards,

Ganesh

[RamanKorrapati]

Hi,

Please check about open hub functionality.

we can saved data info flat files or tables/ i think flat file might be useful in your case.

once we have flat file data, then we can updated flat files into external systems.

Thanks