Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS

Qlik ODBC Connector Package supports Microsoft SQL Server 2019 starting QS February 2021.

cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

Qlik ODBC Connector Package supports Microsoft SQL Server 2019 starting QS February 2021.

The Qlik ODBC Connector Package uses 3rd party drivers for ODBC connectivity. The current drivers for Microsoft SQL Server driver from 3rd party vendor Simba supports Microsoft SQL Server 2019  starting QS February 2021. For older versions of Qlik, SQL Server 2019 is not supported, see the resolution.

See Qlik ODBC Connector Package help page for supported data sources; Supported Microsoft SQL Server versions

 

Environment

 

Resolution

Data can be loaded from Microsoft SQL Server 2019 by using ODBC or OLEDB drivers from Microsoft.

The vendor driver must be installed and configured in Windows on each Qlik Sense node that has a Qlik Sense Engine service running. It is also recommended to test and validate connectivity in a Test or stage environment before promoting to a Production environment. 

Review existing data connections and update accordingly, if they need to refer to a new Windows DSN or OLEDB connection. This is mostly relevant database server that has been migrated or upgraded to Microsoft SQL server 2019. 

Tags (1)
Labels (1)
Version history
Last update:
‎2022-02-10 06:55 AM
Updated by: