on 02-28-2015 6:58 AM
Hi,
I had a scenario JDBC->PI->Proxy.
I want to fetch data from multiple tables i.e. to use multiple SELECT queries.
I cannot write JOIN in query also database is not accessible to create stored procedure.
Thanks & Regards,
Parin Chahwala.
And there is a reason why you can't. Architectural reason.
SAP PI is a message based platform, and as such the data that is send to the PI Integration server should already be in business granularity and have all the required data to complete the transaction a business transaction.
You will always get a flat structure from a relational DB selects on the JDBC sender side so there is no proper\stable\correct way to do it (dont even think of ccBPM...) . on the Receiver side however you have much more flexibility.
I would recommend you to try and use a select from an intermediate table where the xml will be stored in a CLOB type field. this will allow a "queu like " work with the database receiving all the info you need. the logic however should be written in SQL language on the Application side.
Hope this is clear enought.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Parin,
You have set hard premises. If you don't want a join operation and SP is not possible you can't achieve your goal with only on scenario. You can do two scenarios:
1. JDBC - Proxy (async): you do the select in the main table with the status flag.
2. Proxy - JDBC (Sync): in your proxy abap code when a data is received you call this second scenario with the necessary data to get the data for the set of tables needed. You can do this scenario enough generic to deal will the different tables.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Y don't you write JOIN operation ?
Select <f1,f2,.. m_id, n_id...fn> from M1 M2 M3 where M1.m_id = M2.m_id and M2.n_id = M3.n_id.
Here f1,....m_id,n_id,.....fn are fields.
you don't have any other option other then having JOIN or Stored procedure.
Br,
Manoj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.