IDOC-Database Scenario

[Former Member]

Dear All,

I am working on IDOC - Database scenario.

Below is the scenario:

u2022 The data received through the IDocs will be uploaded into respective temporary tables in Target SQL Sytem by means of stored procedures.

u2022 The data stored in temporary tables are picked up and distributed to various other main tables by the job running at Target SQL server.

1) Can I call directly Stored procedures from JDBC Adapter?

If so, can anyone help me in providing some pointers on this?

Thanks

Babu

[Former Member]

Done

[former_member183906]

For sending IDoc to XI we need to write one ABAP program to trigger the IDoc.

We will create the Port and partner profiles based on that the XI takes the IDoc.

We will write the update SQL statement in the Receiver Communication channel

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

The above document gives a good insight towards the understanding of the JDBC adapter.

How can i test the whole integration?

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e573e690-0201-0010-e098-f90e8dad...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/d0111fef-d311-2a10-c0b9-f33a49c1...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/3a67c790-0201-0010-89aa-d27d97dd...

http://help.sap.com/bp_bpmv130/Documentation/Operation/TuningGuide.pdf

[dharamveer_gaur2]

use also

Recent Enhancements to JDBC Adapter:

[dharamveer_gaur2]

hi

use similar thread for using stored procedure from JDBC adapter.

how to use JDBC Stored Procedures:

[Former Member]

Refer this blog