topic Re: Is it possible to configure Qlik Replicate without enabling SQL Server replication? in Qlik Replicate

Is it possible to configure Qlik Replicate without enabling SQL Server replication?

Adam37168 — Fri, 30 May 2025 10:59:37 GMT

Is it possible to configure the data exchange process in Qlik Replicate in such a way that SQL Server replication is not created or enabled?

I’m looking for a solution that would allow me to completely replace traditional replication, which is why this question is so important to me.

Best regards,
Adam

Re: Is it possible to configure Qlik Replicate without enabling SQL Server replication?

PGN — Fri, 30 May 2025 11:52:06 GMT

If all of your tasks are snapshot, then yes. Otherwise, I don't believe there's any way since Replicate needs to keep track of what tables are changing and it uses native SQL replication to create a publication and mark the tables as articles.

Re: Is it possible to configure Qlik Replicate without enabling SQL Server replication?

SushilKumar — Fri, 30 May 2025 11:52:08 GMT

Hello @Adam37168

You may refer below community link.

Why it needs SQL Server to enable replication when... - Qlik Community - 2065595

Regards,
Sushil Kumar

Re: Is it possible to configure Qlik Replicate without enabling SQL Server replication?

john_wang — Fri, 30 May 2025 14:06:41 GMT

Hello @Adam37168 ,

MS-CDC (Microsoft Change Data Capture) is a suitable option when using SQL Server as a source database, especially when SQL Server MS-REPLICATION is not enabled or not desired.

Hope it helps.

John.