Kafka Connect when we have multiple queries

Question

How can we use Kafka Connect when there are multiple tables to be inserted?

I am trying to implement Kafka connect sink to insert to multiple Oracle table.

Answer 1

You can either define one JDBC Sink Connector per table, or a single JDBC Sink Connector with multiple topics specified - each topic will be written to a separate table. The table will take the topic name, which you can also map using the table.name.format option.