Does Kafka Connect work if CT is enabled instead of CDC on SQL server

Kafka Connect
1

We are trying to implement Kafka Connect for our project to extract data from SQL server and push to kafka cluster. We have millions of records to push. Heard the “kafka-connect-jdbc” may not work , if CT (Change tracking) is enabled instead of CDC (Change Data Capture). Is it true ?

Due to performance reasons, CDC is not enabled and we have CT .
I am also new to kafka and trying to understand the components still .
Appreciate if any one share feedback or inputs on this. Thank you

2

JDBC connector runs queries on a schedule, and doesn’t poll the database OPlog like Debezium would, therefore isn’t doing and “tracking” on its own - that would be logic specific to your consumer, but you’d be missing specific operations like update/delete actions and only see net-new database rows

3

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.