how Qlik replicate reads the transactional log files from a MS SQL Server

[TNJ]

Does Qlik used background process or database API to read from the transaction logs from MS SQL Server?

like how Tlog are accessed by Qlik replicate?

Any particular Tlog (name and location) that Qlik access to perform Log-Based CDC?

[Dana_Baldwin · Accepted solution]

Hi @TNJ 

By default, Qlik Replicate uses functions to query the TLOG, fn_dblog for the online log and fn_dump_dblog for the backup TLOG. If your endpoint is set to only read backups from disk, then we open and read the backup TLOG file itself.

For the configuration options, here is the page in our User Guide: Setting advanced connection properties #Setting advanced connection properties | Qlik Replicate Help

Hope this helps!

Dana

[TNJ]

Thank you @Dana_Baldwin for the information.