Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers,
I have one question and probably you know the answer.
I have Qlik Sense Enterprise May 2024 running and I would like to create a connection agains a Listener which is part of an Always On SQL service (MSSQL Standard 2019).
So far I understand it must work, isn't it? does anyone already tested it? is there any kind of compatibility issue?
Doesn't it matter if I use the OLE DB connector instead of the SQL Server one?
Thanks in advance
Hi @LDR Yes, Qlik SQL connector should works, as well as ODBC connector.
Hi @LDR Yes, Qlik SQL connector should works, as well as ODBC connector.
Hi @Jack_Guo
Sorry because I forgot to come back to my post and give my feedback. Maybe it could be useful for any other Qliker so, I'm going to explain it a little bit more in detail:
Of course, we can find that Qlik is running a heavy query and in the middle of the process, the failover is activated and the AG is moved to another node, in this case, even if the listener IP address doesn't change, the transaction will fail. If we run it again, it will work.
In summary, Always On is a technology 100% compatible with Qlik SQL and ODBC connectors.
Regards