Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hassansm
Contributor II
Contributor II

How to load Incremental data from Oracle using data loader APP?

Hi,

I am new to QLIK sense and preparing Data loader QVD, my requirement is to load the incremental data from Oracle Database (table,views).

can any one suggest best possible way to load incremental data.

Regards,

Hassan

4 Replies
Vasiliy_Beshentsev
Creator III
Creator III

vlad_komarov
Partner
Partner

QS and QV incremental loading processes are pretty much the same (as shown by vasiliy_beshentsevabove).

There are multiple ways to organize it.

I am usually using a DATE/TIMESTAMP approach:

  LastLoad:

  LOAD * FROM iLastLoad.qvd' (QVD);

  LET MaxDateTime = PEEK ('prevloaddate', 0, 'LastLoad');

  DROP TABLE LastLoad;

DATA:

  LOAD

*

  SQL SELECT *

 

  FROM ABC

  WHERE "timestamp" > '$(MaxDateTime)';

hassansm
Contributor II
Contributor II
Author

Hello,

Thanks for your solution, I will try to implement and see the result.

hassansm
Contributor II
Contributor II
Author

Hello ,

For the below statement I am getting connector reply error.

Is this below statement is correct for incremental load. please help.

Incremental:

LOAD PURCHS_INVC_ID,

MODFCTN_DATE;

SELECT "PURCHS_INVC_ID",

"MODFCTN_DATE"

FROM "AC_PURCHS_INVC_HEDR" where MODFCTN_DATE> $(last_updated_date);