Hi Experts,
I have a scenrio JDBC -PI7.1- RFC syn. I got a table in JDBC . First i have to read the table and responce i need to update back to same table..
Jdbc table:
H Delivery no stutus cust addre XX XXXXX XX XXXXX
D Delivery no XXXX XXX XXXX 10 materail1 10 100.00
D Delivery no XXXX XXX XXXX 20 material2 20 200.00
D Delivery no XXXX XXX XXXX 30 maserial3 3 300.00
H
D
D
H :header D: details XX: empty space
If the table is like that. How can i create sturucture in PI as source side ?
What are the steps need to follow for RFC to JDBC syn scenrio ?
Note : In the table H D D ,like that repeating headers and items
Do you recomend , change request from oracle structure ?
Regards,
vasu
Edited by: vasudeva gembali on Sep 22, 2010 4:51 AM
Edited by: vasudeva gembali on Sep 22, 2010 4:54 AM
Edited by: vasudeva gembali on Sep 22, 2010 4:55 AM
Hi Vasu,
you will read the data from DB Table and will sedn it to RFC,RFC response will be send it JDBC,tjis is your requirement right??
JDBCsender adapter will not support Synchronous mode,so you have to think ither option to use BPM.
Regards,
Raj
Hi Vasudev,
I understand the your requirement, JDBC to RFC synchronous scenario. Generally JDBC not preferred the Synchronous support.
You can go for BPM for this
Receive---Send(synchronous)- Send(asyn).
These steps are enough for this scenario.
But about your table, I am n't understand clearly, Kindly tell the column fileds.
Thank you.
Sateesh
Add a comment