cancel
Showing results for 
Search instead for 
Did you mean: 

Adatpter Jdbc Sender

Former Member
0 Kudos

Hi everybody....

I have a jdbc sender. The table is huge and I´d like to know how to import data gradually.

Thank you so much

Accepted Solutions (1)

Accepted Solutions (1)

former_member187339
Active Contributor
0 Kudos

Hi

I can suggest you either go for Stored Procedure in Sender Channel, which regulates the messgae size or do as suggested in these notes

Note 1253826 - Configuring Maximum Message Size Limits

Regards

Suraj

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Christian ,

Directly use JDBC sender adapter....keep the polling interval high ( atleast 2 min )....make the query in batches of 500 or 1000 will help you keep track or records..

No issue...,we have moved 45K employee master records like this only..

Regards,

former_member183906
Active Contributor
0 Kudos

Hi,

1.JDBC sender support adapter modules.

Use PayloadZipBean adapter module.

/people/stefan.grube/blog/2007/02/20/working-with-the-payloadzipbean-module-of-the-xi-adapter-framework

2. Please try to look into the link below hope this could be of any help.

In saptechnical dot com-->Tutorials/XI/ZippingFiles/demo

Best Regards