Search

Microsoft Azure Synapse SQL Connector

Microsoft Azure Synapse SQL Connector

Back Next

Changed data capture limitations

Changed data capture limitations

Consider the following limitations when working with a

Microsoft Azure Synapse SQL

change data capture (CDC) target:

The staging temporary tables are not dropped if a mapping task is terminated. You must clean up the temporary tables manually.

The following keywords are not allowed for the CDC target:

Keywords not allowed in the table name: "

(

", "

SET

", "

WHERE

", "

.

"

Keywords not allowed in column name: "

) VALUES

", "

,

", "

SET

", "

WHERE

", "

= ?

", "

AND

"

Consider the leading and trailing spaces with certain keywords.

You cannot capture changed data for

datatimeoffset

and

time

data type.

Date conversion from other data types to smalldatetime is not applicable.

Microsoft Azure Synapse SQL targets in mappings

Watch

Comments

Cloud Connectivity Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.