on 03-26-2007 12:40 PM
I need to design a scenario,
Data is coming from two tables in mainframe.....that data i need to combine and process it and insert to ECC.
How to design?.
What will be the steps using BPM?.
Can u please give me broad view on designing this scenario.
make use of <b>joins</b> in the query ...or also one simple way to do it liek below:
select....where <condition> UNION select....where <condition>
the above query also works here.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Will you be able to use JDBC adapter to access the mainframe tables? Does XI have the correspodning DB level access?
if yes. you can use the Sender JDBC adapter and use a Join Statament in the Sender JDBC adapter to seletc the data from these 2 tables and then use the correspodning idoc or Proxy to send the data to ABAP proxy.
Regards
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Well, at times there can be firewall issues and also IT Policies in place that might restrict access to the tables directly.
Normally the means of integration with Mainframes is either a Flat file ( use File Adapters here ) or JDBC adapters.
As you pointed out you are planning to use JDBC adapters . So, in this case you will need to identify ,
1. Select Query --> How to select the data from the database / mainframe. As you are going to select data from 2 tables, you will need to join to select the data from these tables.
2. Update Query --> What happens after XI selects the data. Should it reselect it or should it update the data so that the same data is not selected again.
Regards
Bhavesh
Thanks Prabhu..for the input.
Thanks Bhavesh. You got the point...that is what i am going to do.
I have a select with join....then i update the records selected from database.
But now, i want to resign the scenario..
What i want to do is...write a sync send. Then use the join sql to get data, send to BPM.
Then inside BPM, use select with for update only and update sql.
For getting records on fly and send to BPM, how can i do?. Can u please elaborate this?.
What all i need to do to run the join sql against table and get data to BPM?.
(Advanced mode in JDBC Adapter setting to serializable queries is not working). So i need to do this step to overcome.
Hi,
SQL multiple taables see the below link
multiple tables with JDBC - http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
Also see the below links
JDBC - http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm
JDBC Response /people/swaroopa.vishwanath/blog/2006/12/28/send-rfc-to-sap-xi-150-asynchronous
Regards
Chilla
><i>Transaction Isolation Level : serializable is not working for me...</i>
How do you know it is not working? Can you let me know further what the issue with this is?
Norammyl, Serializable makes sure that the database gets write locked to make sure that no data is available between the execution of the Select and Update Query.
Regards
Bhavesh
Issue is, It locks the table, same time some other programs will updating the same table. So it will throw error.
So i thins situation, we can's use Transaction Isolation Level : serializable.
what is the solution for this situation?. We can't lock the table using Transaction Isolation Level : serializable.
Transaction Isolation Level : serializable.
It locks the table..right?. or it locks the database?.
How long it locks the table?. We set the time?.
I can't lock the table, so i need some work around to fix this issue.
What will be work around?.
Can i use a sync send and qurey tables using sql join...then send this join result to BPM?.
Is this best work around?......Anybody done this before?.
Hi,
Processing can only be performed correctly when the isolation level for transaction is set to repeatable_read or serializable.
SQL statement for query: SELECT * FROM table WHERE processed = 0;
SQL statement for update: UPDATE table SET processed = 1 WHERE processed = 0;
processed is the indicator in the database
See the below link
http://help.sap.com/saphelp_erp2005vp/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm
Regards
Chilla
Hi,
one way:
you can use a fork step with two receiver steps
this way the fork will wait for both messages
and only then continue to execute
so you'll be able to map 2 message to 1 in a transformation step and
send it as a one message - IDOC, RFC, abap proxy
second way:
if both messages are exactly the same
you can use a BPM to collect two messages
(2 will be the end of the loop parameter)
and them transtormation step and sending to ECC
Regards,
michal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
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.