Hello,
It would be nice if we could have more authentication options in Qlik Sense connection dialog for MS SQL connection related to Azure. Current drivers like ODBC Connector Package or OLE DB provide just basic options as Windows or SQL authentication which is not enough for connecting to Azure Synapse database. Of course this is possible using ODBC but nobody wants to be managing tenths of ODBC connections on multiple servers. Intention is to provide a developer freedom and not to be dependent to the infrastructure team to create a ODBC.
All these options are available when installing MS OLE DB driver to a workstation/server with QlikView client/server .
Is there any reason why all options supported by MS OLE DB driver are limited in Qlik Sense OLE DB connection dialog? It looks pretty much modestly for both SQL driver and Microsoft SQL driver within ODBC Connector package?
Thank you in advance for considering this idea.
Kind Regards,
Ladislav