Skip to main content

Azure Synapse Analytics

Connections to Azure Synapse Analytics are made by selecting Azure Synapse Analytics from the list of drivers in the list of connectors in the Qlik Sense Add data or Data load editor dialogs if the driver is available on the product and version you use.

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 Enterprise on Windows
  • Qlik Sense Enterprise SaaS
  • QlikView (Requires separate installation)

Supported Azure Synapse Analytics versions

The followings data versions are supported:

  • 2020

Supported Azure Synapse Analytics data types

The following Azure Synapse data types are supported by the Azure Synapse Analytics 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

See also