on 02-13-2013 6:59 AM
Hi All,
JDBC to IDOC interface:
I have few queries in how PI behaves when connecting with JDBC adapter:
Case 1: The data from oracle is picked up successfully by the Query statement, if any mapping failure happens in Integration server in this case will update statement mentioned in JDBC will execute or not.
For Example: Select * from Emp_Table WHERE Status = 'y';
in Update: Update Emp_Table SET Status = 'n' WHERE Status ='y';
If it updates then how the status of the select statement records are backrolled
Case 2: If R/3 is down then it will be in Queue, so if we clear the queue then it creates IDOC at r/3 side. (Correct me if I am wrong)
Case 3: My scenario is JDBC to IDOC, here at the source end the data is provided as view (they collect data from 4 tables and gives that as view), so we cannot update the data as the view holds queried data, so I am planning to approach like after creating the IDOC's successfully at the target end I take the unique fields which present in the 4 tables and using stored procedures is it possible to update at oracle end; So the final scenario will be synchronous but the one way comm is JDBC to IDOC and using abap proxy I will get the list of records that I need to update at the oracle end.
(Correct me If I my approach is good and is that have any performance issue)
So finally its 2 asnyc scenarios.
Thanks,
--Sai
Hi All,
Can i get few answers for this query..
Suitable answers will be awarded with points.
Thanks,
--Sai
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi sai,
Same scenario, i am doing mine is jdbc to rfc sync, i am doing without BPM, see do test, with the help of one entry.
give status = x, and close the table , refresh and open again , xi will pick the record and update the query.
for ex. select * from table , when status = x;
update table set status= y where status= x;
then check in moni, or else in RWB .Commn channel moni and Msg moni.
This is ur first doubt.
Let me know once u clear the flow from db to pi.
Regards,
dhanush
Hi,
>>>>The data from oracle is picked up successfully by the Query statement, if any mapping failure happens in Integration server in this case will update statement mentioned in JDBC will execute or not.
update will be executed and message will stay in error in mapping - so you can do something with it
>>>>If R/3 is down then it will be in Queue, so if we clear the queue then it creates IDOC at r/3 side.
message will stay in PI and only after R3 is up will PI restart the message and create the IDOC
Regards,
Michal Krawczyk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hai Sai,
" If update statement is executed and if it failed in Integratin engine due to mapping errors , then if i want to reprocess those records, how do one can change the status at the source end? it will be very difficult to change the status of every record? "
In this case i suggest not to use update statement in jdbc channel, instead you can design another mapping to update the status field and add this mapping in interface determination next to ur first operation mapping. Make sure " maintain order at runtime " is checked in interface determination.
Doing so the update mapping will execute only if ur first mapping executes successfully.
User | Count |
---|---|
89 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.