Skip to content

Instantly share code, notes, and snippets.

@s-chb
Created July 15, 2020 07:43
Show Gist options
  • Save s-chb/7bdac47cc0b37d540b9cea8aeb6c207b to your computer and use it in GitHub Desktop.
Save s-chb/7bdac47cc0b37d540b9cea8aeb6c207b to your computer and use it in GitHub Desktop.
CREATE SOURCE CONNECTOR jdbc_source WITH (
'connector.class' = 'io.confluent.connect.jdbc.JdbcSourceConnector',
'connection.url' = 'jdbc:postgresql://postgres:5432/camunda',
'connection.user' = 'camunda',
'connection.password' = 'camunda',
'topic.prefix' = 'jdbc_',
'table.whitelist' = 'act_hi_taskinst',
'mode' = 'incrementing',
'numeric.mapping' = 'best_fit',
'incrementing.column.name' = 'id',
'key' = 'id',
'key.converter' = 'org.apache.kafka.connect.converters.IntegerConverter');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment