transfer data from BW Open Hub Service via Process Integration (PI) to external database

[Former Member]

Hello,

I'm searching a step-by-step description to transfer data provided by the BW Open-Hub-Service via PI to a Oracle-database.

I found a document for an old configuration (BW 3.x and former XI)... would be nice to have a newer.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e698aa90-0201-0010-7982-b498e02af...

Today, we are on BW-Release 7.31 and PI-Release 7.00.

Thanks for your replies,

Thomas

[Former Member]

Hi Thomas,

Could you achieve this requirement. can you please share in details the steps to be followed for integration for SAP BW 7.x version

[baskar_gopalakrishnan2]

This is what I would suggest...

Sender side : BW to PI ( since your version is only 7.0, you can use XI proxy adapter) as client proxy.

You need to configure proxy communication between BW and PI. 

Create ESR objects

service interface for outbound (sender) and service interface for the inbound (receiver) , message mapping and operation mapping

ID objects

as usual.. You don't need communication channel and sender agreement for proxy ... receiver side create jdbc adapter.

you will use jdbc communication between PI and database.

Your scenario is proxy to jdbc

Please search scn for the client proxy scenario and receiver jdbc scenarios.. You will find plenty of documents. Plus refer the following links for your references,

http://saptechnical.com/Tutorials/XI/ABAPClientProxy/page1.htm

Since you use pi 7.0, refer the below two links for configuring jdbc adapter in ID and creating receiver structure for jdbc in ESR

http://help.sap.com/saphelp_nw70/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

[Former Member]

Hello Baskar,

thanks for your reply. I will check in detail.

Which steps are necessary to connect from an existing Open-Hub to the PI? Which entry should be done in rsa1 / Open Hub / create / database-name?

Regards,

Thomas