on 09-22-2010 3:47 AM
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 😧 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sateesh,
These are the colum fields.
DELIVERY_ID VARCHAR2(40) H/D Delivery Number
FLAG_STATUS
CUSTOMER_NO VARCHAR2(30) H Customer Number
SAP_CUSTOMER_NO VARCHAR2(30) H SAP Customer Number from Attribute 8
SHIP_TO_NO VARCHAR2(30) H Ship to number
SHIP_TO_ADDRESS1 VARCHAR2(240) H Ship to address 1
SHIP_TO_ADDRESS2 VARCHAR2(240) H Ship to address 2
SHIP_TO_ADDRESS3 VARCHAR2(240) H Ship to address 3
SHIP_TO_ADDRESS4 VARCHAR2(240) H Ship to address 4
SHIP_TO_CITY VARCHAR2(60) H Ship to city
SHIP_TO_POSTALCODE VARCHAR2(60) H Ship to postal code
LINE_ITEM VARCHAR2(6) D LINE ITEM NUMBER
INVENTORY_ORG VARCHAR2(10) D Default u2018DS1u2019 u2018DRS2u2019
CUST_ITEM_CODE VARCHAR2(40) D Customer Item code
GF_ITEM_CODE VARHCAR2(40) D Internal Item code
ITEM_DESCRIPTION VARCHAR2(240) D Item Description
PLAN_ISSUE_DATE DATE D Schedule Shipment Date
QUANTITY NUMBER??? D Shipment quantity
UOM VARCHAR2(3) D Unit of Measure
As I understood your query,
you have two tables one is header and second is detail, in that you can use the combine structure in PI and use join query in sender adapter.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What are the steps need to follow for RFC to JDBC syn scenrio ?
What is your exact scenario?
In subject line you mentioned JDBC --> RFC ......in thread you mentioned RFC --> JDBC....
If it is JDBC to RFC, then use a BPM.
Receive --> Transformation --> SYNCSend --> Transformation --> AsyncSend
Or if the RFC is able to operate in Async mode then, have two Async scenarios....one would be JDBC --> RFC and other would be RFC --> JDBC.
Regards,
Abhishek.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.