SQL Server Source Connector
Source connector
SQL Server Source Connector
SQL Server replication uses Debezium with SQL Server CDC enabled on the database and selected tables. Validate the Database Store connection before selecting replication scope.
Connector Class
io.debezium.connector.sqlserver.SqlServerConnector
Parameters
| Category | Parameter | Required | Recommended / Default | Description |
|---|---|---|---|---|
| Basic | name | Yes | User-defined | Unique connector name. GIFROST derives topic.prefix as <name>-server. |
| Basic | tasks.max | Yes | 1 | Keep one task for ordered CDC reading. |
| Database Connection | database.hostname | Yes | From Database Store | SQL Server host. |
| Database Connection | database.port | Yes | 1433 | SQL Server port. |
| Database Connection | database.user | Yes | From Database Store | Database user. |
| Database Connection | database.password | Yes | Hidden | Password or secret reference. |
| Database Connection | database.names | Yes | From Database Store | Database names captured by the connector. |
| Database Wizard | table.include.list / table.exclude.list | No | Generated | Fully qualified table filters. |
| Database Wizard | column.include.list / column.exclude.list | No | Generated | Column filters. |
| Database Wizard | message.key.columns | Conditional | Generated | Custom keys for tables without primary keys. |
| Snapshot | snapshot.mode | No | initial | Initial loading behavior. |
| Snapshot | snapshot.isolation.mode | No | Deployment-specific | Isolation used during snapshot. |
| Signal | signal.data.collection | Conditional | <databaseName>.<schemaName>.<tableName> | Signal table. |
| Connector | poll.interval.ms | No | Defaults | Frequency for polling change tables. |