Azure Synapse Analytics and Analytics Platform System

The driver transparently connects to Microsoft Azure Synapse Analytics and Microsoft Analytics Platform System; however, the following limitations to features and functionality apply.

• No support for connecting to an instance using an IP address for the server. A named instance must be specified for the ServerName property.
• No support for unquoted identifiers. The driver always enforces ANSI rules regarding quotation marks for Azure Synapse Analytics and Analytics Platform System connections.
• No support for connection pooling reauthentication.
• No support for Data Definition Language (DDL) queries within transactions.
• No support for closing holdable cursors when a transaction is committed.
• No support for server-side cursors; therefore:
  • Scroll-sensitive result sets are not supported.
  • The UseServerSideUpdatableCursors property is set to false, and server-side cursors are not used.
• No support for XA connections.
• Support for isolation levels is limited to only the read uncommitted level. See "Isolation Levels" for more information.
• No support for the following SQL Server data types in either the Azure Synapse Analytics or Analytics Platform System.

  decimal() identity	timestamp
  image	tinyint identity
  numeric() identity	ntext
  smallint identity	xml
  text

• Support for scalar string functions is limited to the following functions.

  ASCII	LEFT	RTRIM
  CHAR	LTRIM	SOUNDEX
  CONCAT	REPLACE	SPACE
  DIFFERENCE	RIGHT	SUBSTRING

• Support for scalar numeric functions is limited to the following functions.

  ABS	EXP	ROUND
  ACOS	FLOOR	SIGN
  ASIN	LOG	SIN
  ATAN	LOG10	SQRT
  CEILING	PI	TAN
  COS	POWER	TRUNCATE
  COT	RADIANS
  DEGREES	RAND (Azure Warehouse only)

• Support for scalar date and time functions is limited to the following functions.

  CURDATE	DAYOFWEEK	QUARTER
  CURRENT_DATE	DAYOFYEAR	SECOND
  CURRENT_TIME	HOUR	WEEK
  CURTIME	MINUTE	YEAR
  DAYNAME	MONTH
  DAYOFMONTH	MONTHNAME