Skip to Content
avatar image
Former Member

scenario regarding fetching data from database

Hi,

i am trying to create a scenario which will have a source file in XML format that contain only the primary key of a table that exists in SQL server. inside IP, a synchronous call is made to JDBC and the records corresponding to the primary key will be fetched and finally will be written to a output file(XML). I need help for designing the IP.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 10, 2008 at 11:35 AM

    Hi,

    Choose the Quality of service : "Best effort" in your JDBC receiver communication channel to create synchronous flow.

    With receiver JDBC adapter you can use it as Synchronus way.

    You need to create the statement with Select as an SQL query along with the primary Key as selection criteria

    SAP Network Blog: JDBC Receiver Adapter -- Synchronous Select – Step by Step

    /people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

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

    Thanks

    Swarup

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 10, 2008 at 12:28 PM

    From XI you can send data to database and get the response from JDBC to xi back using these two weblogs:

    /people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response

    /people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

    *******************Reward points,if found useful

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 10, 2008 at 11:50 AM

    hi,

    check the sender side configurtion using below link and receiver should be File

    JDBC to JDBC

    https://wiki.sdn.sap.com/wiki/display/XI/JDBCTOJDBC

    Reagards

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 10, 2008 at 12:20 PM

    Hi,

    Using java mapping plus JDBC look up will avoid the usage of BPM in this scenario. This would be more performance effective.

    Add comment
    10|10000 characters needed characters exceeded