Skip to content

Instantly share code, notes, and snippets.

@thierryturpin
Created October 7, 2021 14:46
Show Gist options
  • Save thierryturpin/17d78df30369962791b8bd40bd465d19 to your computer and use it in GitHub Desktop.
Save thierryturpin/17d78df30369962791b8bd40bd465d19 to your computer and use it in GitHub Desktop.
MSSQL source connector
{
"name": "mssql-dbo-orders",
"config": {
"connector.class": "io.debezium.connector.sqlserver.SqlServerConnector",
"database.hostname": "172.31.59.71",
"database.port": "1433",
"database.user": "sa",
"database.password": "",
"database.dbname": "demo",
"database.server.name": "dev",
"table.include.list": "dbo.ORDERS",
"include.schema.changes": "false",
"topic.creation.default.replication.factor": 2,
"topic.creation.default.partitions": 10,
"database.history.kafka.bootstrap.servers": "b-1.dev-msk.o64p78.c1.kafka.eu-central-1.amazonaws.com:9096,b-2.dev-msk.o64p78.c1.kafka.eu-central-1.amazonaws.com:9096",
"database.history.kafka.topic": "dbhistory.dbo.orders",
"database.history.consumer.security.protocol": "SASL_SSL",
"database.history.consumer.sasl.mechanism": "SCRAM-SHA-512",
"database.history.consumer.sasl.jaas.config": "org.apache.kafka.common.security.scram.ScramLoginModule required username=\"connect\" password=\"\";",
"database.history.producer.security.protocol": "SASL_SSL",
"database.history.producer.sasl.mechanism": "SCRAM-SHA-512",
"database.history.producer.sasl.jaas.config": "org.apache.kafka.common.security.scram.ScramLoginModule required username=\"connect\" password=\"\";"
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment