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 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