Hi Team, We have a requirement to sync table records between 2 database . We use strimzi kafka and debezium source connector for CDC.
Now we have records from 100 tables into 100 topics in kafka which need to be inserted into target database. I was trying to use camel sql server/Jdbc sink connector . Can i create a single kafka connector CRD to read from all topics and insert into database tables? Or do I have to create 100 camel kafka connector files since I need to include query and topic in configuration? Any example of sink connector config for my use case would be helpful. Thanks, Shiva