Scenario File-JDBC-RFC

[Former Member]

hi,

we receive a file with a key, we want to retrieve data from the database and return them to an RFC, it is possible to do file-jdbc-rfc?, no problem that the sender JDBC adapter does not allow sync?

another way that I can do?

very thanks

[Former Member · Accepted solution]

Hi,

use BPM.......have a recive step for file.........then have a recive step for JDBC........then have a transformation to map it to RFC req........then have a synch send step to send the RFC req to r/3 and get back its response..........then have a transformation to map it to JDBC response........then have a send step to send it to JDBC database............

in reciver step for JDBC you will require a sender JDBC comm channel and for the send step you will require a reciver JDBC comm channel...........

no problem that the sender JDBC adapter does not allow sync? - No, it allows synch but you can use sender JDBC in exactly once mode in your scenario.

Regards,

Rajeev Gupta

Edited by: RAJEEV GUPTA on Feb 11, 2009 1:38 PM

[vijayabaskaranj · Accepted solution]

Rajeev,

I tried JDBC as sender with excatly once for SYNC scenario. It is not working.

Our scenario :

select max numbers from table A using sender channel and pass the max number to table B to get values greater than max number and insert the selected value back to table A.

request

JDBC sender (maximum number is selected from table A)

using mapping to build select statement --- send to receiver JDBC communication channel to select values from table B.

response :

selected values from the above is converted as insert values to be inserted into table A.

Everything is working up to this point but the last step insert to table A using the sender channel is not working.I assume that the same sender channel will be used for insert.

we are using only two communication channels (one sender JDBC and one receiver JDBC).

Can you pl give more info on how to set up the directory configuration.

thanks

Vijayabaskaran johnwesley

[Former Member]

Hi ,

You can Go with JDBC lookup if there is any one field else use BPM to Collect the data and then retrieve it.

Best Regards,

Sainath

...

[prateek]

If you want to retrieve just a single field from database, then simply configure File to RFC scenario with jdbc lookup in mapping. If you want complete structure, then configure BPM.

no problem that the sender JDBC adapter does not allow sync?

It would be jdbc receiver

Regards,

Prateek