JDBC to IDOC scenario

[Former Member]

Hi Experts,

I have to design an interface to process 2Lakhs of records for a JDBC to IDOC scenario.

Kindly give me some valuable inputs, i mean how to design it?

[baskar_gopalakrishnan2 · Accepted solution]

It's easy. You can use select query to pull records at your convenience. Select only 5000 records for each time. This way you can do many times as seperate message. This is one example. Refer sap help forum for jdbc sender.

http://help.sap.com/saphelp_dm40/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

[Former Member · Accepted solution]

Hi Bhaskar,

Thanks for the inputs, I have few queries in this case.

As you said select 5000 records in first go, How can i repeat this query untill all records get completed.

Is this can be achieved by means of stored procedure at sender side where cursor returns 5000 records at one go, and repeating the same by using some loop conditions. Please advise?

[rajasekhar_reddy14 · Accepted solution]

> 
> Is this can be achieved by means of stored procedure at sender side where cursor  returns 5000 records at one go, and repeating the same  by using some loop conditions. Please advise?

This is right option to go .

or

Write select statement such a way that it pussles only 5000 records at a time(and process as a one message).

If you process 2lacs records in once selecty Definetly there is a high prabability to face perfromance issues.

Regards,

Raj

[Former Member · Accepted solution]

this blog will help u in case u r using SQL server DB ortherwise SP will suit ur design

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/18652

[MichalKrawczyk]

Hi,

>>>I have to design an interface to process 2Lakhs of records for a JDBC to IDOC scenario.

for 7.3 - standard JDBC - IDOC configuration ( use AEX to process on java stack only)

for < 7.3 - use jdbc to - abap proxy (ICO object) and from proxy call IDOC

Regards,

Michal Krawczyk

[Former Member]

Hi Michal,

Kindly let me know how do i can call Idoc by using proxy?

I have used proxies for XML interfaces but not for proxies by using SPROXY tcode in R/3 system.

Finally, can i process 2 lacks records at a time in this way, I mean is this not going to create any performance issues?

Thanks for ur suggestions