Qlik Fix: How to add a table to logstream task on Qlik Replicate

[Troy_Raney]

This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.

Environment

• Qlik Replicate

This video demonstrates how to safely add a table to an existing Log stream task in Qlik Replicate without affecting the parent tasks.

Here is a link to more information in the Support Knowledge Base

Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.

Transcript

Hi and Welcome to Qlik Fix
This video will demonstrate how to safely add a table to an existing Log stream task in Qlik Replicate.
Here is an example Log Stream Staging or Parent task
With a PostgreSQL Source and a Log Stream target already configured.
There are three tables: Branch, Branch Supplier and Csub Test that have been fully loaded.
The task is running and Change Data Capture or CDC is in progress.
Here is the child task that also points to PostgreSQL for the full load and then the log stream for CDC changes.
It’s using a File target for this demo.
In order to add a new table without impacting other tables,
First, stop the parent task.
Notice back on the child task, there is a warning log message stating that changes are not being captured.
Once the parent task is restarted the child task will pick up and continue where it left off.
Now stop the child task.
Back to the parent task, click on Table Selection to choose the table to add
Search, the trailspace table is the one that will be added. Add it with the arrows, OK.
Save that with the new table added.
Now from the Child task, Table Selection, Search
Notice that this new table isn’t available on the child task yet, as the parent task hasn’t been restarted yet.
Now from the Parent task, select Run > Resume Processing.
This will pick up where it left off with the original tables, and it will initiate a Full Load on the newly added table.
You can see this demonstrated with the different load time stamps of 1:08 for the original three tables and 1:17 for the fourth table.
Now that the parent task has completed a full load on the new table,
Go to the child task, table selection, search, and now the new table is available.
Bring that over, click ok.
Save.
And Run > Resume Processing on the child task.
Again, it initiated a Full Load only on the trailspace table, and not impacting the original tables.
Now Change Data Capture is running.
I’ll just add some inserts into that new trailspace table from PGAdmin to demonstrate this.
Qlik Replicate picks up those changes on the parent and child tasks and applies those changes to target.
I hope that helped.

If you'd like more information
Take advantage of the expertise of peers, product experts, Community MVPs and technical support engineers
by asking a question in a Qlik Product Forum.
Hiding in plain sight is the Search tool.
This engine allows you to search Qlik Knowledge Base Articles,
Qlik Community forums,
Help dot Qlik dot com, Qlik Gallery,
multiple Qlik YouTube channels and more, all from one place.
There’s also the Support space.
We recommend you subscribe to the Support Updates Blog,
And learn from Qlik experts via a webinar, like Techspert Talks or Q&A with Qlik.
Thanks for watching.
(music)
Nailed it!