How to Read Master-detail tables with XI?????

[Former Member]

Hi ,

I have to develop an interface to send sales orders (header and details), how can i configure the JDBC sender adapter to do this???? and the receiver????

thank's a lot , any help would be great,

regards

[Former Member]

Something wrong. Sorry about this.

[Former Member]

i reviewed the weblogs attached but is not my case, somebody knows how can i do this config ???, i need to send information that exist in two tables (header -items)

[Former Member]

Morales,

Check Bhavesh reply in this thread:

Regards,

---Satish

[Former Member]

Something wrong. Sorry about this.

Message was edited by:

Satish Reddy

[Former Member]

Something wrong. Sorry about this.

Message was edited by:

Satish Reddy

[Former Member]

Something wrong. Sorry about this.

Message was edited by:

Satish Reddy

[Former Member]

Something wrong. Sorry about this.

[Former Member]

Morales,

If you want you pull the data from R3 database using JDBC sender adapter you can do it. Its just like pulling the data from any database. But I think it is not possible to post the data using JDBC.

Also I would recommend to use IDOCs to send data to XI instead of JDBC adapter.

Regards,

---Satish

[Former Member]

sorry, i wanted to say that i need integrate two legacy systems, i mean a database Oracle with a SQl Server, but in the legacies i have the data in two tables (heeader -detail) and i need to transfers to ther database (header-detail),

the scenario is JDBC - JDBC

thank's

[Former Member]

Hey

have a look at the following

thanx

Ahmad

[justin_santhanam]

Francis,

You can achieve it using , Sender JDBC adapter with driver configured for oracle and receiver JDBC adapter driver configured for SQL-server. It can be easily done. Kindly tell us where u got stuck up, so that it can be easy for us to suggest u to proceed further.

Best regards,

raj.

[Former Member]

can we connect directly to sap db like we connect to other databases?then how data consistency will be maintained in SAP DB?I am thinking like get data from or to sap by idoc,rfc,proxies.

babu

[Former Member]

Hey

>>I have to develop an interface to send sales orders (header and details), how can i configure the JDBC sender adapter to do this???? and the receiver????

if you want to read these details from R/3,you need to use IDOC adapter(or proxies or RFC).JDBC can't be used to integrate R/3

use ORDERS05 IDOC for this

Thanx

Ahmad