cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC 2 RFC Scenario

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

rajasekhar_reddy14
Active Contributor
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Qualification
Explorer
0 Kudos

Hi Vasu,

Your scenario will be done like this: JDBC=> BPM (Receive)=> Send (Synchronous)- Send(Asyn) =>RFC (Syn) => JDBC Receiver =>StoredProcedure in Taraget Side based on the Unique Key fields in the same table for updation of the response status.

Regards

Venkat Rao .G

Former Member
0 Kudos

Hi Vasudev,

I didn't find any difference for this table and normal table.

So you can create source datatype below format

for ex:

DT_vasudev

--row 0 to unbounded

-


DELIVERY_ID 0 to 1

-


FLAG 0 to 1

-


CUstomerNo 0 to 1

...

....

......

Thank you

Sateesh

Former Member
0 Kudos

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.

Former Member
0 Kudos

Only one table.

former_member200962
Active Contributor
0 Kudos
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.

Former Member
0 Kudos

Sorry Its JDBC to RFC syn.

SO i f i am using BPM, how can i mapp the return mapping ?

former_member200962
Active Contributor
0 Kudos
how can i mapp the return mapping ?

All your mappings will be between Async Interfaces. JDBCReq_to_RFCReq and RFCResp_to_JDBCResp.