Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
abhishek_bigdat
Contributor III
Contributor III

Is incremental load possible while fetching data from SAP

I have extracted data from SAP sources using SAP Netweaver Connector. But i have been asked to write an incremental script to fetch monthly data automatically in the future. I dont think so this is possible.Can anyone throw light on this question of mine.Will be appreciated.Thanks.

9 Replies
abhishek_bigdat
Contributor III
Contributor III
Author

Can anyone help me on this?

tresesco
MVP
MVP

You have to just identify a field in SAP table set that holds modification timestamp, then the approach would be similar to other general incremental loads.

rajeshvaswani77
Specialist III
Specialist III

Hi Deepak,

Incremental load is possible from any data source in general.

You need to identify for that table the Primary Key as well as the modified date time stamp.

If you have these, you can do incremental loads.

thanks,

Rajesh Vaswani

abhishek_bigdat
Contributor III
Contributor III
Author

We generate excel everytime by feeding parameters in the SAP system.Seriously will this work?

tresesco
MVP
MVP

Fortunately this community is for serious discussion. . Try and let know if you have further issues.

ashfaq_haseeb
Champion III
Champion III

Hi,

All that you need to have is a primary key and date time field.

Regards

ASHFAQ

abhishek_bigdat
Contributor III
Contributor III
Author

I know the concept Ashfaq. I do not know how will it be implemented

ashfaq_haseeb
Champion III
Champion III

Hi,

Give it a try and if you face any difficulty do let us know.

Regards

ASHFAQ

abhishek_bigdat
Contributor III
Contributor III
Author

Expecting some miracle