Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Adam37168
Contributor
Contributor

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

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

Labels (2)
1 Solution

Accepted Solutions
john_wang
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

3 Replies
PGN
Creator II
Creator II

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.

SushilKumar
Support
Support

Hello @Adam37168 

You may refer below community link.

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

Regards,
Sushil Kumar

john_wang
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!