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

[Jon_Donker]

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. 

I found the following article that seems what I need: https://community.qlik.com/t5/Official-Support-Articles/Force-Qlik-Replicate-to-connect-to-secondary...

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 · Accepted solution]

Hello @Jon_Donker ,

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]

Thanks - option is there

[john_wang]

Thank you for your support! @Jon_Donker