topic Re: Installation and setup of replication on sql server for reading data from SQL Server backup logs in Qlik Replicate

Installation and setup of replication on sql server for reading data from SQL Server backup logs

Rak — Wed, 18 Sep 2024 23:49:14 GMT

Installation and setup of replication on sql server for reading data from SQL Server backup logs using qlik replicate tasks.

We have plans to use Qlik Replicate to read data from SQL Server backup logs, is it still necessary to configure replication in SQL Server and enable it?

Please provide documentation on reading from backup logs and its connection to replication.

Re: Installation and setup of replication on sql server for reading data from SQL Server backup logs

Dana_Baldwin — Wed, 18 Sep 2024 23:56:34 GMT

Hi @Rak

Yes, you still need to enable MS-Replication so that the CDC data is written to the TLOG.

Documentation on configuring the advanced options in the source endpoint are here:

Setting advanced connection properties #Setting advanced connection properties | Qlik Replicate Help

Pre-requisites are here:

Prerequisites | Qlik Replicate Help

These links are for version 2024.5, you can scroll to the top left and change it for the version you're working with.

Thanks,

Dana

Re: Installation and setup of replication on sql server for reading data from SQL Server backup logs

john_wang — Thu, 19 Sep 2024 01:13:54 GMT

Besides @Dana_Baldwin comment, if you want to read changes from from backup logs only then please set:

Change processing mode (read changes from) to Backup Logs Only, as:

Hope this helps.

John.