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

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

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

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