topic Re: Microsoft SQL Server (MS-CDC) - option to ApplicationIntent=ReadOnly in Qlik Replicate

Microsoft SQL Server (MS-CDC) - option to ApplicationIntent=ReadOnly

Jon_Donker — Wed, 03 Sep 2025 01:49:32 GMT

Hi Team,

We're upgrading a MS SQL database from 2012 to 2022.

The DBAs would like us to use the MS-CDC connector and to read from the secondary node.

But the options are not present in the Microsoft SQL Server (MS-CDC) connector.

Is this option only available from the straight Microsoft SQL Server connector and not for the Microsoft SQL Server (MS-CDC) connector?

john_wang — Wed, 03 Sep 2025 01:57:54 GMT

Thanks for the post here!

The parameter name in the referenced article is incorrect. I’ll update it shortly.
The correct parameter is: additionalConnectionProperties

Hope this helps.

John.

Jon_Donker — Thu, 04 Sep 2025 05:26:12 GMT

Thanks - option is there

john_wang — Thu, 04 Sep 2025 06:22:46 GMT

Thank you for your support! @Jon_Donker