Skip to Content

JDBC-RFC-File

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 17, 2008 at 01:28 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 17, 2008 at 09:33 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 17, 2008 at 11:52 AM

    >

    > 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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 17, 2008 at 02:47 PM

    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.

    File - RFC - File without a BPM - Possible from SP 19.

    Thanx

    Aamir

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.