how to create multiple topics and multiple table in kafka in jdbc connector?

Question

i tried to install kafka connect in command prompt .

i have a connector look like this

name=test-source-oracle-jdbc

connector.class=io.confluent.connect.jdbc.JdbcSourceConnector

tasks.max=1
connection.url=jdbc:oracle:thin:@172.26.70.84:1621/OPICSDEV

connection.user=KFK_USER

connection.password=kafka_user012345

mode=bulk

topic.prefix=opics-demo

query=select * from OPICS.cust where rownum < 5

poll.interval.ms=900000

score 0 · Answer 1 · answered Jul 16 '19 at 05:26

0

If you want to read from multiple tables, you'll need to run multiple connectors at the same time.

Similarly, different topic prefixes could be provided as well within different Connector properties

answered Jul 16 '19 at 05:26

OneCricketeer

179,855
19
132
245

Really? We run hundreds of connectors at once. Why can't you? – OneCricketeer Jul 16 '19 at 06:49
If you are using `connect-standalone`, then I'd immediately suggest that you use `connect-distributed` instead – OneCricketeer Jul 16 '19 at 06:50
really ? i will try it tomorrow . thanks for the suggestion. – Jr Dones Jul 16 '19 at 09:24
hi i used the connect-standalone but i got this error. – Jr Dones Jul 17 '19 at 00:56
WARN could not get type for name com.amazonaws.auth.Signer from any class loader – Jr Dones Jul 17 '19 at 00:57
That's just a warning, but JDBC Connector doesn't load any AWS classes anyway – OneCricketeer Jul 17 '19 at 02:42

how to create multiple topics and multiple table in kafka in jdbc connector?

1 Answers1