sqlserver通过confluent实时同步到kafka

sqlserver安装

https://www.cnblogs.com/xuanqust/p/11106679.html

sqlserver开启cdc

– Create the test database
CREATE DATABASE ReportServerTempDB;
GO
USE ReportServerTempDB;
EXEC sys.sp_cdc_enable_db;

– Create some customers …
CREATE TABLE customers (
id INTEGER IDENTITY(1001,1) NOT NULL PRIMARY KEY,
first_name VARCHAR(255) NOT NULL,
last_name VARCHAR(255) NOT NULL,
email VARCHAR(255) NOT NULL UNIQUE
);
INSERT INTO customers(first_name,last_name,email)
VALUES (‘Sally’,‘Thomas’,‘sally.thomas@acme.com’);
INSERT INTO customers(first_name,last_name,email)
VALUES (‘George’,‘Bailey’,‘gbailey@foobar.com’);
INSERT INTO customers(first_name,last_name,email)
VALUES (‘Edward’,‘Walker’,‘ed@walker.com’);
INSERT INTO customers(first_name,last_name,email)
VALUES (‘Anne’,‘Kretchmar’,‘annek@noanswer.org’);

EXEC sys.sp_cdc_enable_table
@source_schema = ‘dbo’,
@source_name = ‘customers’,
@role_name = NULL,
@supports_net_changes = 0;
GO

查看数据库是否启用cdc

SELECT name,is_cdc_enabled FROM sys.databases WHERE is_cdc_enabled = 1;

查看表是否启用cdc

SELECT name,is_tracked_by_cdc FROM sys.tables WHERE is_tracked_by_cdc = 1;

confluent下载地址

wget http://packages.confluent.io/archive/5.2/confluent-5.2.3-2.11.zip

解压

tar -zxvf confluent-5.2.3-2.11.zip confluent-5.2.3-2.11
#将CONFLUENT_HOME配置进环境变量里:
vi /etc/profile
export CONFLUENT_HOME=/web/connector/confluent/confluent-5.2.3
export PATH=$CONFLUEN{T}_{H}OME/bin:$PATH