If I need to copy the same data from a topic to multiple databases with different IPs, do I need to create multiple sink connectors or I can somehow specify multiple destinations in connection.url or some other way.
Your help is most appreciated
I'm assuming that you're talking about Kafka Connect and the JDBC Sink connector? If so, then you need to create one sink connector per target database. One connector cannot target multiple databases.