Microsoft SQL Server

Connections to a Microsoft SQL Server database are made by selecting Microsoft SQL Server from the list of drivers in the list of connectors in the QlikView ODBC Connection dialog or the Qlik Sense Add data or Data load editor dialogs.

Industry-accepted best practices must be followed when using or allowing access through the ODBC Connector. Administrators must follow The Principle of Least Privilege when setting up source database privileges and permissions.

Supported offerings

Qlik Sense Desktop/Qlik Sense Mobile Client Managed
Qlik Sense Enterprise on Windows
Qlik Sense Enterprise SaaS
QlikView (Requires separate installation)

Supported Microsoft SQL Server versions

The followings data versions are supported:

2012 to 2019

Supported Microsoft SQL Server data types

The following Microsoft SQL Server data types are supported by the Microsoft SQL Server Connector.

BigInt
BigInt Identity
Bit
Char
Date
DateTime
DateTime2
Decimal
Decimal Identity
Float
GUID
Int
Int Identity
Money
NChar
NText
Numeric
Numeric Identity
NVarChar
NVarChar(max)
Real
SmallDateTime
SmallInt
SmallInt Identity
SmallMoney
SysName
Text
Time
TinyInt
TinyInt Identity
VarChar
VarChar(max)
XML

Learn more

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here