Limitations and considerations

The following limitations apply to the Microsoft Azure ADLS target endpoint:

• The following DDLs are supported only: Truncate table, Drop table, Create table, Add Column, Rename Column, Drop Column, and Convert Data Type.
• Full LOB Mode is not supported
• UPDATE and DELETE statements are not supported in Apply Changes replication mode
• Batch optimized apply mode is not supported
• Target lookup is not supported
• The <target folder> parameter cannot include special characters

• Limitations when using Parquet file format:

  • When the DDL Handling Policy for source tables is set to Ignore ALTER, the RENAME COLUMN DDL (on a Primary Key column) is not supported.

  • LOB columns larger than 1 MB are not supported.

• Database names, schema names, or table names containing slash (/) or backslash (\) characters are not supported.
• Proxy:
  • Accessing Azure Data Lake Storage (ADLS) Gen2 storage via a proxy is not supported with HTTPS protocol.
  • Accessing Azure Data Lake Storage (ADLS) Gen2 storage via an authenticated proxy is not supported.
• The following Control Tables are not supported as they require UPDATE/DELETE operations, which are not supported:

  • Replication Status (requires UPDATE).

    Name on target: attrep_status

  • Suspended Tables (requires DELETE).

    Name on target: attrep_suspended_tables

    For more information on Control Tables, see Control tables.