FLINK SQL CDC 同步

1.源端使用CDC，目标端常规jdbc
CREATE TABLE ftin (
id INT,
name VARCHAR(50),
PRIMARY KEY (id) NOT ENFORCED
) WITH (
'connector' = 'sqlserver-cdc',
'hostname' = 'xx.xx.xx.x',
'port' = '1433',
'username' = 'sa',
'password' = '123456',
'database-name' = 'dw_bak',
'table-name' = 'dbo.ft',
'scan.startup.mode' = 'latest-offset'
);

CREATE TABLE ftout(
id INT,
name varchar(50),
PRIMARY KEY (id) NOT ENFORCED
) WITH (
'connector' = 'jdbc',
'url' = 'jdbc:sqlserver://xx.xx.xx.xx:1433;DatabaseName=sink_dw',
'table-name' = 'ft',
'username' = 'sa',
'password' = '123456',
'driver' = 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
);

insert into ftout select * from ftin;