The Qlik ODBC Connector Package must be installed manually for QlikView.
Install the Qlik ODBC Connector Package
Information noteIndustry-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 Client-Managed Mobile
- Qlik Sense Business
- Qlik Sense Enterprise on Windows
- Qlik Sense Enterprise SaaS
- QlikView (Requires separate installation)
Encryption keys
If you are using this connector on Qlik Sense Enterprise on Windows you will need to set an encryption key on each node in a multinode environment.
For more information, see Setting an encryption key.
Supported Azure SQL data types
The following Azure SQL data types are supported by the Azure SQL Database connector.
- BigInt
- BigInt Identity
- Binary
- 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
- Varbinary
- VarChar
- VarChar(max)
- XML