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