How to handle Dynamic Tables in Qlik Replicate

[sureshkumar]

This article describes how to handle dynamic tables in Qlik Replicate, such as when source tables are frequently added and deleted. This avoids having to manually add the table to a task each time.

The methods described will work for most source endpoints. 

Our example uses Oracle as the source.

1. Select the pattern in the Table Section
   Make sure the task is set to Full Load + CDC
   
   
   
   
2. Review the list of tables for the selected pattern under Full Table List
   
   
   
   
3. After the initial load, the tables are successfully created at the target:
   
   
   
   

4. Create a new table in the source:
   
   create table SYSTEM.suri4(id int primary key, anane varchar(10))
   
   

5. The table is automatically added to the task
   
   
   
   CDC Status:
   
   
   
   Log Entry:
   
   
   
   Table entry in the target:
   
   
   
   
6. Drop table from the Source:
   
   drop table SYSTEM.suri4;
   
   
7. The table is automatically dropped from the target. We can observe the Drop DDL command entry in the log:
   
   
   

 

Environment

• Qlik Replicate