Limitations

The following limitations apply:

• UPDATE/DELETE DMLs are not supported during change processing. If an UPDATE/DELETE DML was captured on the source, it will be ignored on the target and a warning will be written to the log. If the Store Changes option is enabled in the task settings, these records will be written to the Change Table.
• Limited LOB support only.
• Dropping columns and changing column data types or the data type length is not supported and will suspend the table in all cases except for data types that are mapped to STRING. Changes to the data type length of a data type mapped to STRING (e.g. VARCHAR(50) to VARCHAR(100)) will simply be ignored.

• Writing to "special" tables such as tables with partitions, buckets, or skews 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.

• Table and column names can only contain ASCII characters.
• Column names cannot contain the '?' symbol. If needed, the '?' symbol can be replaced with a valid ASCII character using a transformation.

• Blob storage limitations:

  • Supported on Windows only
  • Append operation is not supported

• Proxy:

  • Does not affect the ODBC (Hive) connection. Affects the storage connection only.
  • When using Blob storage, the HTTPS scheme is not supported.
  • Accessing Azure Data Lake Storage (ADLS) Gen2 storage via a proxy is not supported with HTTPS protocol.
  • Connecting to a proxy server with a username and password is not supported with Azure Data Lake Storage (ADLS) Gen2 storage.