cancel
Showing results for 
Search instead for 
Did you mean: 

Need help with scenario design

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

prabhu_s2
Active Contributor
0 Kudos

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.

bhavesh_kantilal
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Yes...i will be using JDBC Adapter to access mainframe tables.

what is this means "Does XI have the correspodning DB level access?"...

bhavesh_kantilal
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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.

bhavesh_kantilal
Active Contributor
0 Kudos

Jay,

Was not able to get this new requirement at all.

For Synchronous Select From a Receievr JDBC adapter take a look at my blog,

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

Regards

Bhavesh

Former Member
0 Kudos

Do we have any docs or blog written on this?

Transaction Isolation Level : serializable is not working for me...

So what is the work around for solving this issue?.

I have a join sql on two tables, then update sql to change status of the selected records.

Former Member
0 Kudos

thanks Bhavesh,

u should write more blogs...u r expert.

Former Member
0 Kudos

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

bhavesh_kantilal
Active Contributor
0 Kudos

><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

Former Member
0 Kudos

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.

Former Member
0 Kudos

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?.

Former Member
0 Kudos

make Transaction Isolation Level : serializable. if you cant use this then use separator field indictor for this.

Former Member
0 Kudos

I am using JDBC as sender adapter and RFC as receiver adapter.

Former Member
0 Kudos

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

Former Member
0 Kudos

thanks sree...

how to do this "separator field indictor" ?

MichalKrawczyk
Active Contributor
0 Kudos

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