SAP->JDBC(synch)->SAP scenario

[Former Member]

Hi All,

I have a requirement in which user runs Report in SAP which initiates a PI scenario. This PI scenario runs a select query on external Oracle database and returns the data back to SAP to display as the report output on screen. This report needs real time data.

How should be my approach to design the PI scenario?

Here on database side I can use JDBC receiver synchronous adaptor but on SAP side which channel should I use? Will proxies help? If yes then will it be server/client proxies?

Thanks in Advance.

Regards,

Atul

[udo_martens]

Hi Atul,

>Here on database side I can use JDBC receiver synchronous adaptor but on SAP side which channel should I use?

ABAP proxy or RFC support synchronous scenarios

>Will proxies help?

Yes

>If yes then will it be server/client proxies?

Client proxies

Regards,

Udo

[Former Member]

Hi Udo,

Thanks for your quick responce.

What is the best approach for my requirement RFC or Proxies?

If possible can you explain pros and cons of both approaches?

Thanks and Regards,

Atul

[udo_martens]

Hi Atul,

>What is the best approach for my requirement RFC or Proxies?

Depends on your requirements

>If possible can you explain pros and cons of both approaches?

Proxies: good performance and stability, need to be developed

RFC: medium performance and stability, SAP modules can be reused

Regards,

Udo

[shivhare]

Hi Atul ,

if you transfer bulk data then proxy is best ... and all thing depend on your requrement as Udo told

Regards,

Amit