JDBC-RFC-File

[vijay_kumar133]

Hi friends,

Is there any chance of doing a Asyncronous jdbc to syncronous RFC and response i need to collect in file with out using BPM..

I know With Bpm we can complete this scenario. I need any options other than bpm to collect error(Responce) from rfc to a file..

In this scenario i am updating rfc from jdbc and error records i nead to capture in file..

Thanks & Regards..

Vijay

[Former Member · Accepted solution]

hi

i believe that you need to use BPM since rfc call will be sync call and call from jdbc would be async

You will have to create a Sender JDBC adapter. Check the link below for configuring a JDBC sender adapter.

An important point to note are 2 fields, QUERY this will contain the select query. Next will be the UPDATE.this will contain the UPDATE statement after the rows are selected from your database.

The reason an update statement has to be given is, as the JDBC adapter will continually poll over your database, the rows read in one polling interval should not be read again.

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

2. Next, you will have to configure a receiver RFC adapter. This can be done following this link,

http://help.sap.com/saphelp_nw04/helpdata/en/c8/e80440a832e369e10000000a155106/content.htm

For a blog on how to use Synch / Asybnch Bridge, I would suggest this link,

/people/sriram.vasudevan3/blog/2005/01/11/demonstrating-use-of-synchronous-asynchronous-bridge-to-integrate-synchronous-and-asynchronous-systems-using-ccbpm-in-sap-xi

For blog on how RFC is to be used in a BPM,

/people/arpit.seth/blog/2005/06/27/rfc-scenario-using-bpm--starter-kit

https://weblogs.sdn.sap.com/pub/wlg/1403 [original link is broken] [original link is broken] [original link is broken]

I guess you will have to combine all this info and use it in a single BPM.

For more info on Synch/ Asynch Bridge and how to create a BPM ,

http://help.sap.com/saphelp_nw04/helpdata/en/62/dcef46dae42142911c8f14ca7a7c39/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/ae/fd773f12f14a18e10000000a114084/content.htm

note:reward points if solution found helpfull

regards

chandrakanth.k

[Former Member]

Hey

>>i am updating rfc from jdbc and error records i nead to capture in file..

Here i am assuming that you will only get a response from RFC if there is any error,if there is no error then the tables in R/3 will be updated and no response will be sent,if my understanding of your scenario is correct you can have a look at the below thread.

Thanx

Aamir

[Former Member]

>

> Hi friends,
> 
> Is there any chance of doing a Asyncronous jdbc to syncronous RFC and response i need to collect in file with out using BPM..
> 
> I know With Bpm we can complete this scenario. I need any options other than bpm to collect error(Responce) from rfc to a file..
> 
> In this scenario i am updating rfc from jdbc and error records i nead to capture in file..
> 
> 
> Thanks & Regards..
> Vijay

yes, its possible to do it with bpm.

Basically your bpm steps will be like this:

Receive,

Transform if needed,

Syncronously Send and receive response,

Transform again if needed,

Send Asynchronously.

Take a look at the image in the link to have a better idea on the BPM setup

https://weblogs.sdn.sap.com/weblogs/images/251764026/bpmAsync2Sync2Async.JPG

Now, if your R3 is 6.20 or higer, use abap proxys instead rfc... theres no point on using the old technology and proxys are better in terms of monitoring and performance.

i hope this helps.

Regards and good luck

[Former Member]

Hi,

In this case, you can construct Your scenario as JDBC--Proxy

1) Send the JDBC data to SAP R/3 and while posting the data to SAP R/3 DB, collect the Error records in Internal Table

2) And now send those Error Records to File( Proxy--File)

Regards

Seshagiri