The driver provides read-write access to the Synapse Data Warehouse endpoints of Microsoft Fabric; however, the following limitations to features and functionality apply:
Note: The Microsoft Fabric data source is constantly evolving; therefore, the limitations given in this section may not apply in the future. For the latest information, refer to the Microsoft Fabric documentation.
  • The PRIMARY KEY and UNIQUE constraints are only supported when NONCLUSTERED and NOT ENFORCED are both used, whereas the FOREIGN KEY constraint is only supported when NOT ENFORCED is used. These keys cannot be created while creating a table, but can be added later using ALTER TABLE.
  • No support for distributed transactions and named transactions.
  • No support for CREATE INDEX.
  • getTablePrivileges() and getCoumnPrivileges() return empty result sets.
  • connection.getMetaData().getSchemas() returns the schema names in an unsorted order.
  • CREATE FUNCTION can create inline table-value functions, but not scalar functions.
  • No support for the following T-SQL commands, queries, and features:
    • ALTER TABLE (ADD, ALTER, and DROP COLUMN): Currently, only the following subsets of ALTER TABLE are supported in Warehouse in Microsoft Fabric:
      • ADD nullable columns of supported column data types.
      • ADD or DROP PRIMARY KEY, UNIQUE, and FOREIGN KEY column constraints, but only if the NOT ENFORCED option has been specified. All other ALTER TABLE operations are blocked.
    • MERGE
    • Schema and table names containing / or \
    • CREATE ROLE
    • OPENROWSET
    • SELECT - FOR XML
    • CREATE USER
    • PREDICT
    • SET ROWCOUNT
    • Hints
    • Queries targeting system and user tables
    • SET TRANSACTION ISOLATION LEVEL
    • IDENTITY columns
    • Recursive queries
    • Temporary tables
    • Manually created multi-column statistics
    • smallint identity
    • Triggers
    • Materialized views
    • Result Set Caching
  • No support for the following keywords:
    • ALLOW_SNAPSHOT_ISOLATION
    • COLLATE
    • COLUMN ENCRYPTION
    • DECLARE CURSOR
  • No support for the following SQL Server data types:
    • bigint identity
    • money
    • smallmoney
    • binary
    • nchar
    • text
    • datetime
    • ntext
    • timestamp
    • datetimeoffset
    • numeric() identity
    • tinyint
    • decimal() identity
    • nvarchar
    • tinyint identity
    • image
    • nvarchar(max)
    • uniqueidentifier
    • int identity
    • smallint identity
  • 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 (ADW only)
    • RADIANS
    • DEGREES
    • RAND
  • 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
Note:

Refer to Scalar functions in the Progress DataDirect for JDBC Drivers Reference for more information.