Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
5u88u_qlik
Contributor
Contributor

Batch and realtime replication

Whether I can do both batch and realtime replication on the same table.

I have realtime replication enabled.  If I want to load historical data to the same table is it possible.

Labels (1)
1 Reply
Pierretim
Contributor III
Contributor III

Yes, I think it is possible, something like this:

- keep the real time apply running

- create a new task, temporary, to load the history. Set it the task as full load only, and of course that it does not drop the target if it exists. In the task you can put a filter condition,  on a date field. I did not test it but I think something similar to

$MY_DATE_FIELD <= date('now','start of month')

so that it will only load data from the past and will not interfere with the real time capture.

Pierre