JDBC adapter : Extracting high volume of data

[Former Member]

Hi Experts,

I am working on a scenario where I need to extract some 80,000 volume of data on every 15 days from oracle database to SAP R/3 via SAP XI. I am using JDBC adapter.

What should be my approach to handle such a huge volume by using JDBC adapter?

I would be thankful to every one. Please provide your valuable suggestions.

Thanks

Veeru

[former_member186158]

Not a problem for 80,000 per half a month, even every second, based on my experience.

[madhusudana_reddy2]

Dear Srivastava,

Instead of reading all records at a time, read top 5000 records at a time. You can use either orderBy clause for this.

thanks,

madhu

[Former Member]

Select Query:

You can limit your records by using the Rowcnt or limit (depends on the DB) using the JDBC sender adapter.

update Query:

Update the selected rows by set the flag(new column) values as Y or N to avoid the repetition.

Regards

Ramg