topic Re: Incremental Load Through ODBC Connection in QlikView

Incremental Load Through ODBC Connection

Gautam — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Incremental Load Through ODBC Connection

mrtinsjoao — Tue, 25 Jun 2019 13:47:33 GMT

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.

Re: Incremental Load Through ODBC Connection

Brett_Bleess — Mon, 22 Jul 2019 20:12:51 GMT

Here are some links that may prove helpful:

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

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

Regards,
Brett