Connect to secondary replica of SQL Server using applicationintent= readonly

[jananireddy1]

Hello fellow Qliker's 

I am making a connection to Microsoft SQL DB using the Qlik MIcrosoft SQL connector from data sources list. 

How would I be able to mention in here applicationintent= readonly as I do not want to load data from the primay db, iI always want my queries to hit the secondary db

Thanks in advance

Janani

[jananireddy1]

Here are the two articles i have been referring too  but no luck on fix yet 

1. https://www.sqlservercentral.com/forums/topic/read-only-routing-on-qliksense-application

2. https://community.qlik.com/t5/QlikView-Scripting/How-to-connect-to-secondary-replica-of-SQL-Server-A...