Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

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

No ratings
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.

Last Update:

Feb 10, 2022 6:55:42 AM

Updated By:

Caterina_Fruci

Created date:

Apr 14, 2021 7:40:18 AM

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: