返回到文章

采纳

编辑于 2年前

kafka sqlserver connector 同步数据,怎么从启用连接器的那一刻开时监听吗?

kafka sqlserver

kafka配置sqlserver连接器,会监听到表中所有数据,以op:r的类型存入kafka(现有一个表有20w数据),可以配置从启用连接器的那一刻开时监听吗?

{
    "name": "sqlserver-cdc-source",
    "config": {
        "connector.class": "io.debezium.connector.sqlserver.SqlServerConnector",
        "database.hostname": "xxx.com",
        "database.server.name": "xxx",
        "database.port": "1433",
        "database.user": "user",
        "database.password": "password",
        "database.dbname": "dbname",
        "table.whitelist": "dbo.table",
        "schemas.enable": "false",
        "mode": "incrementing",
        "incrementing.column.name": "id",
        "database.history.kafka.bootstrap.servers": "172.28.153.222:9092",
        "database.history.kafka.topic": "YwHddzCdc",
        "value.converter.schemas.enable": "false",
        "value.converter": "org.apache.kafka.connect.json.JsonConverter"
    }
}