I have ReadOnly access to MsSql database. I am not able to connect using Qlik MsSql connector because by default Qlik has "ReadWrite" as connect options.
Is it possible to change "ReadWrite" to "Read" option in data load editor or in QMC --> data connection?
I know I can ditch the Qlik MsSql connector and use ODBC connector and in Windows configure it by including "Application Intent" as "READONLY". But this would eventually result in our organisation using only windows ODBC drivers instead of any of the Qlik connectors.
I think "QvxConnectOptions" type is responsible for this Qlik default behavior. Is it advisable to change that file? do you know where I can find this file related to mssql connector?
If this is not possible, please let me know your opinion.