ApplicationIntent=ReadOnly

[vvvvvvizard]

i have a oledb connection to a database in qlik sense , i was asked to make sure i add 

ApplicationIntent=ReadOnly; to the connection string so i dont connect to the primary db 

How do i even view the connection string in Qlik sense 

Where do i add ApplicationIntent=ReadOnly

[vvvvvvizard]

@sunny_talwar  

[vvvvvvizard]

Does anyone know ?

[vvvvvvizard · Accepted solution]

You can in the QMC under data connection 

[RenukaSasikumar15]

Even after adding "ApplicationIntent=ReadOnly" to the data connection, it still connects to the primary database instead of the ReadOnly node.

Any solution to it?