Skip to Content
avatar image
Former Member

Help on RFC to JDBC and JDBC to RFC

Help on RFC to JDBC and JDBC to RFC

Hi Gurus

I have the scenario where an RFC will be triggered in SAP , to write to a DB2 database and insert new records in a table

and vice versa the JDBC has to read som data from a table based on a primary key, mark them as read for not be read next time and send the data to an RFC where a table in SAP will be updated.

I have never worked with JDBC before , pls advice.

is there any new issue to consider in PI 7.0 regarding JDBC

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 11, 2010 at 07:37 AM

    You may create an SP doing Insert and then your select to read som data from a table based on a primary key.

    Look at the structures to be created in PI for same:

    http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 11, 2010 at 10:40 AM

    The requirement looks standard,

    SEARCH IN SDN FOR JDBC scenarios,you will find many docs for sender as well as Receiver.

    >

    > is there any new issue to consider in PI 7.0 regarding JDBC

    >

    no issue with PI7.0.

    Regards,

    Raj

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 11, 2010 at 07:44 AM

    Hi,

    Do u mean,you have to configure a synchronous scenario RFC to JDBC.Please find below links for the same.

    http://wiki.sdn.sap.com/wiki/display/XI/stepbystepRFCtoJDBCscenario

    /people/peng.shen2/blog/2010/06/07/rfc-to-jdbc-synchronous-scenario-guide-part-i

    Thanks

    nidhi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 11, 2010 at 08:53 AM

    Hi

    Thanks for the answers , it is not a synchr. scenario

    it is 2 different scenarios.

    regards.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 12, 2010 at 05:20 PM

    Thank you all

    closing

    Add comment
    10|10000 characters needed characters exceeded