How to Integrate SAP EP with SAP PI to send data for creating reports in BW

[Former Member]

Hi Gurus

I am struck with an Object/Interafce Creation in my project. My requirement is to Integrated SAP Enterprise Portal and SAP BW using SAP Pi. I am working on SAP PI7.1. The SAP EP sits on the Oracle Database and it will send some data required for generating some reports in BW.

My question is how to integrate the above systems by which adapters and which will be the best approach. If we use PI, the major advantage is we can Monitor the flow of the messages .

Cant the BW System directly talk with the SAP EP System. If there is an approach, can we monitor the message flow with out PI involvement.

All the above mentoined systems(SAPEP,SAPPI,SAPBW,SAPSRM,SAPABAP) are in the client landscape only.

Please suggest me the approach.

Thanking you

[rajasekhar_reddy14 · Accepted solution]

Hi,

If you have PI system in your client landscape then integrate SAP EP and SAP BW using SAP PI.

use ABAP proxy communication to connect BW System and use JAVA proxy/web service to connect EP System.

Without PI also we can integrate SAP BW and SAP EP.

Regards,

Raj

[Former Member · Accepted solution]

Hi rajshekar

Thanx for the reply

In the current project we are having an Interafce which is a B pass sceanrio from MDM to BI; MDM is dat , pi is picking the data by Sender File CC and Posting the Data to BW by using Receiver File CC. this does not involve any developemnt of ESR Objects.

My current requirement also seems to be the same Pick thhe date from SP Portal and give it to BW for generaiting reports.

Can i use the SOAP at sender side and File at receiver side with out the involvement of ESR Objects.

Does the By Pass aprroach work for this aprticular interafce.

How can we integrate SAP EP with BW withour Pi?

please share any blogs or forums

please help

Thank you

Edited by: VArjun86 on Jan 4, 2012 10:27 AM

[rajasekhar_reddy14 · Accepted solution]

Hi,

If you are dumping data likw how you had done in MDM->BW scenario is possible but using web service in sender side(EP) may be not possible.

Check with EP team if they are putting data in on any FTP/NFS then use MDM-->BW approach.

Regards,

Raj

[prateek · Accepted solution]

You shouldn't use PI for integrating BW and EP systems for just data transfer. As BW deals with lot of data, you will be unnecessarily increasing load on PI server. You anyway don't need any data transformation. Monitoring can be done in end systems and it shouldn't be a big problem. Even if you use PI monitoring, it can only ensure that the message is sent from one system to another, which for the same client network shouldn't be hard to find.

>>How can we integrate SAP EP with BW withour Pi?

There are some articles and blogs on SCN which explains entire process. Try it.

Regards,

Prateek Raj Srivastava

[Former Member · Accepted solution]

Hi All

I am procedding furtehr as suggested.

will update any information, i am not closing the thread yet

Thank you

[former_member596513 · Accepted solution]

Hi Vemuganti,

I have a similar scenario but integrating SAP EP and ECC with PI.

Can you please share the interface details and the approach with me?

Regards,

Archana