Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
abhishek_bigdat
New Contributor II

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
New Contributor II

Re: Is incremental load possible while fetching data from SAP

Can anyone help me on this?

MVP
MVP

Re: Is incremental load possible while fetching data from SAP

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
Valued Contributor III

Re: Is incremental load possible while fetching data from SAP

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
New Contributor II

Re: Is incremental load possible while fetching data from SAP

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

MVP
MVP

Re: Is incremental load possible while fetching data from SAP

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

Re: Is incremental load possible while fetching data from SAP

Hi,

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

Regards

ASHFAQ

abhishek_bigdat
New Contributor II

Re: Is incremental load possible while fetching data from SAP

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

Re: Is incremental load possible while fetching data from SAP

Hi,

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

Regards

ASHFAQ

abhishek_bigdat
New Contributor II

Re: Is incremental load possible while fetching data from SAP

Expecting some miracle

Community Browser