best way for join query

[Former Member]

Hi,

we need to get data which join table where located at Legacy Oracle and R/3 side.

we are using java proxy for sender or soap in order to send join query.

i think it is not possible even though we are using BPM

is it true? and what is the best way to approach this?

thanks

venjamin

[udo_martens · Accepted solution]

Hi Venjamin,

no, this is not true. It is your choice which XI adapter you are using. BPM and the choice of adapter has no connection. You can send native SQL via <a href="http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm">JDBC Adapter</a>.

Regards,

Udo

[Former Member · Accepted solution]

hi

you mean, it is possible to get data joined between one table Legacy oracle and one of CBO Table in sap r/3.

main my question is above.

if we have legacy oracle and another legacy oracle,

is it possible to get data joined?

thanks

venjamin