
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Number of Connections Qlik Replicate Uses on Source/Target
May 22, 2023 8:50:25 AM
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.