MS SQL connector

Verify staging area compatibility

Refer to the Staging area support matrix for certified connector and staging area configurations.

Supported versions

Microsoft SQL Server 2019

Supported data types

The following are the different data types that are tested in our lab setup:

  • VARCHAR

  • CHAR

  • DATETIME

  • INT

  • TEXT

  • VARBINARY (only unload/load)

  • SMALLINT

  • SMALLMONEY

  • MONEY

  • BIGINT

  • NVARCHAR

  • TINYINT

  • NUMERIC(X,Y)

  • DECIMAL(X,Y)

  • FLOAT

  • NCHAR

  • BIT

  • NTEXT

  • MONEY

  • Structured data types:

    • XML

    • JSON

Property values

Property

Value

SKIP.LOAD.SPLIT.COUNT.VALIDATION

false

SKIP.UNLOAD.SPLIT.COUNT.VALIDATION

false

For default values, see Configuration settings

Known limitations

  • If the applied algorithm's produced mask data exceeds the corresponding target table columns datatype's max value range, then job execution will fail in load service.

  • Schemas, tables, and column names having special characters are not supported.

  • Masking of columns with VARBINARY datatype is not supported.

  • Hyperscale Compliance can mask up to a maximum 1000 tables in a single job.

  • If Change Data Capture (CDC) is enabled on the target SQL database, the masking job may fail. Run the following SQL to disable CDC:

Copy 
USE USER_DATABASE
GO
IF EXISTS (SELECT 1 FROM master.sys.databases WHERE name = 'USER_DATABASE' AND is_cdc_enabled = 1)
EXEC sys.sp_cdc_disable_db
GO