topic Re: Single MS Sql Server CDC source - to multiple SQL Server targets in Qlik Replicate

Single MS Sql Server CDC source - to multiple SQL Server targets

RonFusionHSLLC — Tue, 11 Apr 2023 13:00:08 GMT

Is it possible to use a single source MS Sql Server MSCDC in several tasks and use different targets without conflicts.

Re: Single MS Sql Server CDC source - to multiple SQL Server targets

Dineshan — Tue, 11 Apr 2023 13:57:35 GMT

If the source is not going to change then you should consider using LogStream. This way you can have one parent task and multiple child tasks with different targets. Link to user guide below.

https://help.qlik.com/en-US/replicate/November2022/Content/Replicate/Main/Log%20Stream%20Staging/intro.htm

Thank you,

Dinesh

Re: Single MS Sql Server CDC source - to multiple SQL Server targets

RonFusionHSLLC — Tue, 11 Apr 2023 14:02:44 GMT

If I don't mind the extra overhead, can it be done without logstream? This is a temp situation so would like to take the path of least resistance

Re: Single MS Sql Server CDC source - to multiple SQL Server targets

Dineshan — Tue, 11 Apr 2023 14:09:09 GMT

Hello @RonFusionHSLLC,

Yes, it would still work fine.

Thank you,

Dinesh

Re: Single MS Sql Server CDC source - to multiple SQL Server targets

RonFusionHSLLC — Tue, 11 Apr 2023 14:12:12 GMT

Perfect...thanks