Qlik Replicate: How to convert a Direct Task into a Log Stream Task without reloading

[sureshkumar]

This article documents how to convert a Direct Task into a Log Stream Task without reloading the target.

Resolution

1. Stop the Direct task (Oracle-SQLServer)
   
   
2. Create a new Log Stream (Parent Task)
   
   In our example, the task is called Logstream_new
   
   In Parent Task (a), add same source (b) and same table(s) (c) as the ones used it in Direct Task and run the task
   
   
   
   
3. Create a Dummy Replication (Child) task 
   
   In our example, the task is called Child_Task_new
   
   
   
   
4. Open Qlik Enterprise Manager 
   
   
5. Select the Direct Task (Oracle-SQL Server)
   
   
6. Click Export Task > With Endpoints Export
   
   This exports the Direct Task JSON
   
   
   
   
7. Repeat the export for the Child Task, exporting the JDSON With Endpoints
   
   
   
   
8. Open the Child Task JSON and copy all instances of the Source name 
   
   In our example, this is Duplicate_Oracle_Src
   
   
   
   
   
9. Open the Direct task (Oracle-SQLServer) JSON and replace all instances of the source name with child task source name 
   
   In our example, this is Duplicate_Oracle_Src
   
   
   
   
10. Import the Direct Task JSON (Oracle-SQLServer).
    
    
11. Go to Qlik Replicate Server and Open the Oracle-Sqlserver Task and click on Source endpoint 
    
    
12. Enable Read changes from log stream staging folder and select your Staging directory in Log stream staging task
    
    

    Re-enter the Password

    
    
    
13. Start the task using the Advanced Run (a) option and select (b) Source change position: 0 
    
    
    

Environment

• Qlik Replicate 
• Qlik Enterprise Manager