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 Azure Synapse Analytics versions
The following 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