Incremental Load Through ODBC Connection

[Gautam]

Hi All,  I am extracting the data through ODBC connection, how to make data load incremental i,e only Delta data (Change or New or Delete ). Right now my Select extracts the data from 2016 Yr for every load this has become a stress on the network and leads to performance issue. Kindly suggest the Best approach to over this.

Every load QlikView Document will be dropped and recreated ?or Qlikview document updates the data comparing with existed data and Current load data?

Thanks in Advance.    

[mrtinsjoao]

Great Day, 

You can store this information in a QVD(Qlikview Database).

Load your information with ODBC

and you store like this example:  Store Table1 into [C:\Test\database.qvd](qvd);

now you load the information from QVD not from ODBC again and again. 

[Brett_Bleess]

Here are some links that may prove helpful:

http://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/QVD_Incremental....

https://community.qlik.com/t5/Qlik-Design-Blog/Overview-of-Qlik-Incremental-Loading/ba-p/1466780

Regards,
Brett