JDBC syn to proxy syn Scenario

[Former Member]

Hi firnends,

JDBC (syn) to Proxy (Sys)

I need to pick the data from JDBC and status need to update back from ECC (proxy).

What are the best possible soluctions ? With or without BPM ?

Pls reply back.

Regards,

vasudeva

Edited by: vasudeva gembali on Oct 7, 2010 7:40 AM

[Former Member · Accepted solution]

Hi,

Go for RequestResponse Bean(without BPM) in this case.

Refer this:

http://wiki.sdn.sap.com/wiki/display/XI/UsingRequestResponseBeanModuleinFILE+Adapter(look under Summary and Feature of this scenario section for ur doubts)

http://wiki.sdn.sap.com/wiki/display/XI/File-RFC-File%28Without%20BPM%29

Ur Scenario will be:

JDBC-PROXY-JDBC

Thanks

Amit

[Former Member]

Hi,

If possible develop an RFC, as then it can be a synchronous scenario. you can also have a common structure for source and target and try for a synchronous proxy. Avoid BPM as far as possible.

regards,

Milan Thaker

[Former Member]

Hi friends,

I started my scenario like

JDBC syn - proxy syn - JDBC without BPM using Using Request Response Bean Module

as in link

http://wiki.sdn.sap.com/wiki/display/XI/UsingRequestResponseBeanModuleinFILE+Adapter

. Now i am getting the issue like

JDBC is picking the data and can't update the status SET = 1 instead of 0.

It was working when it was asynch.

2. Do i need to create Receiver determination or receiver agreement two times ?

[Former Member]

Hi all,

It is a resolved blog . please check

[Former Member]

Whats the error you are getting in sender adapter??

[Former Member]

HI,

For JDBC Synch is Better to create 2 Asynchronous Scenario.

Scenario1. JDBC Sender - Xi - ECC Proxy (Call Proxy of Scenario 2 Here and Pass the response for JDBC )

Scenario 2. ECC Proxy - XI - JDBC Receiver

Good in Performance Cz 1. Both is asynchrnous scenario and Without BPM approach.

How this will be Helpful.

Regards

Prabhat Sharma.

[Former Member]

Hi,

You can achieve this easily with BPM.

Or otherwise yopu can go for request/response bean module, it doesn't require BPM to be configured.

Refer the thread :

-Supriya.

[Former Member]

Hi Vasudev,

For JDBC- ECC synchronous scenario ,My suggestion is better to use the BPM for this.

Thank you,

Sateesh