topic Qlik Replicate - Triggering Full loads from different tables manually from one task in Qlik Replicate

Qlik Replicate - Triggering Full loads from different tables manually from one task

Jon_Donker — Tue, 10 Oct 2023 21:52:04 GMT

Hi All,

For a project I developing a QR task that does a full load and CDC on large DB2 tables and replicating them on AWS RDS postgres.

On implementation day the downstream team wants the full loads to run at different stages of the implementation plan.

So for instance:

Run full load on table1 and start cdc
Implementation team does some work on the database on table1 destination and prep for table2
Trigger full load of table2 and start cdc

Is this possible from the one task? I don't want to split up the task in multiple tasks as this adds extra overhead for management and impact on the database.

Thanks.

(PS -> I have to ask the question to appease the project management 🙂 )

Re: Qlik Replicate - Triggering Full loads from different tables manually from one task

jcjames — Tue, 10 Oct 2023 23:22:26 GMT

Hey @Jon_Donker ,

There is a way to achieve this. As long as the full load for the later tables are only initiated once the full load of table 1 is completed and is in CDC mode.

1. Create Task with only Table 1 in scope and start the task.

2. Complete the full load and make sure the task is in CDC mode.

3. When table 2 is ready to be added to scope, Stop the task and add the table. Then resume the task. This will initiate the full load for Table 2. CDC will continue for Table 1. This can be continued for multiple tables.

This does not comply with a task promotion process that you may have in the current environment. But this in my opinion is the only possible way to achieve such a behaviour when using a single task.

Re: Qlik Replicate - Triggering Full loads from different tables manually from one task

Jon_Donker — Tue, 10 Oct 2023 22:13:06 GMT

Cheers - I was anticipating that I would have to do it this way. Was just hoping for a neater method.