topic Re: Connection from Qlik Cloud to SQL database with ApplicationIntent=ReadOnly in Connectivity & Data Prep

Connection from Qlik Cloud to SQL database with ApplicationIntent=ReadOnly

rubenmarin — Mon, 26 Sep 2022 13:56:30 GMT

Hello, we have to access a database wich is in a cluster, and we have to access to an instance with ApplicationIntent=ReadOnly.

In OnPremise version we used and ODBC driver, but in cloud there is no option to do this.

We tried different advaced parameters of the Microsoft SQL Server connector like ApplicationIntent=ReadOnly or application intent=readonly but without success. There is an option we can set to configure this connection?

Thanks.

Re: Connection from Qlik Cloud to SQL database with ApplicationIntent=ReadOnly

Albert_Candelario — Sat, 08 Oct 2022 15:43:30 GMT

Hello @rubenmarin ,

Thanks for posting.

So, what you are saying is that with Qlik Sense client managed you use a 3rd party ODBC driver by creating a ODBC connection and not the SQL native one provided on Qlik Sense itself?

If that is correct, does such parameter works on Qlik Sense client managed when using the Qlik SQL native connector?

Thanks for providing such information.

Cheers,

Albert

Re: Connection from Qlik Cloud to SQL database with ApplicationIntent=ReadOnly

rubenmarin — Tue, 11 Oct 2022 06:20:59 GMT

Hello @Albert_Candelario, we didn't found any way to set the same parameter in the SQL native connector, we tried some options with the advanced parameters but, if there is an option to set there, we didn't found how exactly has to be written.

At the end we used the ODBC connector with the 3rd party connector that has the option to select in a drop-down.

Re: Connection from Qlik Cloud to SQL database with ApplicationIntent=ReadOnly

rubenmarin — Tue, 11 Oct 2022 15:37:07 GMT

In case someone else looks for this.

I got this from @JoelCarter

Name: Application_Intent (Note the underscore between Application and Intent) -and-
Value: ReadOnly (No separator between Read and Only)

as shown in the screenshot below. Hope this helps!

Re: Connection from Qlik Cloud to SQL database with ApplicationIntent=ReadOnly

Albert_Candelario — Wed, 12 Oct 2022 05:19:33 GMT

Correct @rubenmarin , I have been in contact with Joel too and that is correct set up.

I am glad we find the proper name of the parameter for the advance setting.

Thanks @JoelCarter !

Cheers,

Albert