Skip to Content
avatar image
Former Member

Question regarding JDBC - XI -RFC

Hi all,

I have a scenario which XI will get data from database (using jdbc adpater) then send data to execute in RFC. This is an asynchronous call. My question is that.

1. If XI can get many records from database in 1 select, will it send many records to RFC at once? Is there any way i could tell XI to split input data into many message (1 message for each record) without using BPM? or Is it possible or better to set import parameter of RFC into table to get many record from XI at once?

2. If i manage to make 1 message for each record, Could i use queue for sending data to RFC? I want the first record to be completed before sending second record. Since this is an asynchronous call, I'm not sure that XI could be able to know when to send the second record or Do I have to make it synchronous call to get return response from RFC after RFC finish execution and use BPM to get return response before sending next data to RFC.

Any suggestion from expert?

Thanks,

Pavin

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 25, 2008 at 09:25 AM

    Hi

    1. If XI can get many records from database in 1 select, will it send many records to RFC at once? Is there any way i could tell XI to split input data into many message (1 message for each record) without using BPM? or Is it possible or better to set import parameter of RFC into table to get many record from XI at once?

    Yes you can do multi mapping 1:N without BPM

    Message Splitting Using the Graphical Mapping Tool

    /people/jin.shin/blog/2006/02/07/multi-mapping-without-bpm--yes-it146s-possible

    2. If i manage to make 1 message for each record, Could i use queue for sending data to RFC? I want the first record to be completed before sending second record. Since this is an asynchronous call, I'm not sure that XI could be able to know when to send the second record or Do I have to make it synchronous call to get return response from RFC after RFC finish execution and use BPM to get return response before sending next data to RFC.

    You can queue to process one by one. Response can be obtained with or without BPM

    https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/file-rfc-file(Without%2bBPM)

    https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/jdbcTOJDBC

    jdbc-to-rfc-mapping-problem

    Thanks

    Gaurav

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 25, 2008 at 09:17 AM

    Hey Pavin

    Without BPM , huh ....it all depends upon how message mapping is done between the input data and the output data structure.....and enhanced interface determination can be helpful.....

    For more details can refer the blog , think it will helpful as it was for me

    /people/jin.shin/blog/2006/02/07/multi-mapping-without-bpm--yes-it146s-possible

    This is also good the basic of messge split

    http://help.sap.com/saphelp_nw04/helpdata/en/42/f3b31d48fb1bc8e10000000a11466f/content.htm

    Enjoy

    Abhishek

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 26, 2008 at 02:39 PM

    Thank you very much for your help. Point rewarded.

    Pavin

    Add comment
    10|10000 characters needed characters exceeded