Help: how to initiate from JDBC to R/3 Syn.Proxy, and S.Proxy resps to JDBC

[Former Member]

Hi friends, I have a scenario:

1. Iniatiate, select data from MS SQL DB using JDBC

2. Transfer the SQL data to R/3 using Synchronous Proxy

3. From the Synchronous Proxy response, write the result flag to the SQL DB

But I failed create the Synchronous Proxy in R/3 for no vendor specified, could you show me how to create the Synchronous Proxy and the proxy response to XI.

Thanks !!!

Edited by: SongLi on Nov 27, 2008 9:26 AM

[Former Member · Accepted solution]

You could use BPM and design a Async-Sync bridge for this. JDBC sender adapter will execute your SQL query in specific time intervals -> transfer this data to BPM -> In BPM call your Synchronous Server proxy , response from the proxy can be captured in BPM and sent to the database using JDBC receiver adapter.

Thanks

Saravana

[Former Member]

Thank you for your reply!

But I am a newer in XI ,and I knew few about BPM.

Could I do my scenario without using BPM Bridge !?

Edited by: SongLi on Nov 27, 2008 9:43 AM

[prateek]

You could use BPM as JDBC does not support sync behaviour. Other option could be use of adapter module

http://help.sap.com/saphelp_nw04/helpdata/en/45/20c210c20a0732e10000000a155369/frameset.htm

Regards,

Prateek