SqlServer CDC
SqlServer CDC source connector
Descriptionâ
The SqlServer CDC connector allows for reading snapshot data and incremental data from SqlServer database. This document describes how to setup the SqlServer CDC connector to run SQL queries against SqlServer databases.
Key featuresâ
Optionsâ
name | type | required | default value |
---|---|---|---|
hostname | String | Yes | - |
port | Integer | No | 3306 |
username | String | Yes | - |
password | String | Yes | - |
database-name | String | Yes | - |
table-name | String | Yes | - |
startup.mode | Enum | No | INITIAL |
startup.timestamp | Long | No | - |
startup.specific-offset.file | String | No | - |
startup.specific-offset.pos | Long | No | - |
stop.mode | Enum | No | NEVER |
stop.timestamp | Long | No | - |
stop.specific-offset.file | String | No | - |
stop.specific-offset.pos | Long | No | - |
incremental.parallelism | Integer | No | 1 |
snapshot.split.size | Integer | No | 8096 |
snapshot.fetch.size | Integer | No | 1024 |
server-time-zone | String | No | UTC |
connect.timeout | Duration | No | 30s |
connect.max-retries | Integer | No | 3 |
connection.pool.size | Integer | No | 20 |
chunk-key.even-distribution.factor.upper-bound | Double | No | 1000 |
chunk-key.even-distribution.factor.lower-bound | Double | No | 0.05 |
debezium.* | config | No | - |
format | Enum | No | DEFAULT |
common-options | no | - |
hostname [String]â
IP address or hostname of the database server.
port [Integer]â
Integer port number of the database server.
username [String]â
Name of the database to use when connecting to the database server.
password [String]â
Password to use when connecting to the database server.
database-name [String]â
Database name of the database to monitor.
table-name [String]â
Table name is a combination of schema name and table name (schemaName.tableName).
startup.mode [Enum]â
Optional startup mode for SqlServer CDC consumer, valid enumerations are "initial", "earliest", "latest" and "specific".
startup.timestamp [Long]â
Start from the specified epoch timestamp (in milliseconds).
Note, This option is required when the "startup.mode" option used 'timestamp'
.
startup.specific-offset.file [String]â
Start from the specified binlog file name.
Note, This option is required when the "startup.mode" option used 'specific'
.
startup.specific-offset.pos [Long]â
Start from the specified binlog file position.
Note, This option is required when the "startup.mode" option used 'specific'
.
stop.mode [Enum]â
Optional stop mode for SqlServer CDC consumer, valid enumerations are "never".
stop.timestamp [Long]â
Stop from the specified epoch timestamp (in milliseconds).
Note, This option is required when the "stop.mode" option used 'timestamp'
.
stop.specific-offset.file [String]â
Stop from the specified binlog file name.
Note, This option is required when the "stop.mode" option used 'specific'
.
stop.specific-offset.pos [Long]â
Stop from the specified binlog file position.
Note, This option is required when the "stop.mode" option used 'specific'
.
incremental.parallelism [Integer]â
The number of parallel readers in the incremental phase.
snapshot.split.size [Integer]â
The split size (number of rows) of table snapshot, captured tables are split into multiple splits when read the snapshot of table.
snapshot.fetch.size [Integer]â
The maximum fetch size for per poll when read table snapshot.
server-time-zone [String]â
The session time zone in database server.
connect.timeout [Duration]â
The maximum time that the connector should wait after trying to connect to the database server before timing out.
connect.max-retries [Integer]â
The max retry times that the connector should retry to build database server connection.
connection.pool.size [Integer]â
The connection pool size.
debezium [Config]â
Pass-through Debezium's properties to Debezium Embedded Engine which is used to capture data changes from SqlServer server.
See more about the Debezium's SqlServer Connector properties
format [Enum]â
Optional output format for SqlServer CDC, valid enumerations are "DEFAULT"ã"COMPATIBLE_DEBEZIUM_JSON".
exampleâ
source {
SqlServer-CDC {
debezium {
snapshot.mode = "never"
decimal.handling.mode = "double"
}
}
}
common optionsâ
Source plugin common parameters, please refer to Source Common Options for details.
Exampleâ
source {
SqlServer-CDC {
result_table_name = "customers"
hostname = "sqlserver-host"
port = "1433"
username = "sa"
password = "Password!"
database-name = "column_type_test"
table-name = "dbo.full_types"
}
}
Changelogâ
next versionâ
- Add SqlServer CDC Source Connector
- [Doc] Add SqlServer CDC Source Connector document (3993)