Skip to main content
Announcements
Qlik Connect 2025! Join us in Orlando join us for 3 days of immersive learning: REGISTER TODAY

Number of Connections Qlik Replicate Uses on Source/Target

0% helpful (0/1)
cancel
Showing results for 
Search instead for 
Did you mean: 
Dana_Baldwin
Support

Number of Connections Qlik Replicate Uses on Source/Target

Last Update:

May 22, 2023 8:50:25 AM

Updated By:

Sonja_Bauernfeind

Created date:

May 22, 2023 8:50:25 AM

The number of connections that Qlik Replicate will use varies depending on the following:

  • the database
  • if it is a source
  • or if it is a target 

Some of these connections may appear idle for periods of time.

The following is a general description of the number of connections Qlik Replicate will open.

During Full load:

On Source:

Up to 4 X [Tables_loaded_in_parallel] (as defined per table for the selected tables in the task) + 6 connections. This should be a total of 10 connections, for example, if you're replicating one table with no tables being loaded in parallel.

On Target:

Up to 2 X [Tables_loaded_in_parallel] + 6 connections

During CDC (after full load is over):

On Source:

Up to 6 connections

On Target:

Up to 6 connections

The number of connections might increase when replicating LOB columns due to connections needed to perform source lookups due to incomplete LOB data written to source database log files, and to apply this data to the target.

 

Labels (1)