본문 바로가기

Open Source/Kafka

JDBC Sink Connector For Oracle

{
"connector.class": "io.confluent.connect.jdbc.JdbcSinkConnector",
"transforms.TimestampConverter.target.type": "Timestamp",
"connection.password": "******",
"transforms.TimestampConverter.field": "update_date",
"tasks.max": "1",
"transforms": "unwrap, route, TimestampConverter",
"tombstones.on.delete": "true",
"transforms.route.type": "org.apache.kafka.connect.transforms.RegexRouter",
"schema.registry.url": "http://schema-registry:8081",
"transforms.route.regex": "([^.]+)\\.([^.]+)\\.([^.]+)",
"auto.evolve": "false",
"transforms.unwrap.drop.tombstones": "true",
"transforms.unwrap.type": "io.debezium.transforms.ExtractNewRecordState",
"value.converter": "io.confluent.connect.avro.AvroConverter",
"insert.mode": "upsert",
"transforms.route.replacement": "$3",
"key.converter": "io.confluent.connect.avro.AvroConverter",
"table.name.format": "MYUSER.${topic}",
"transforms.TimestampConverter.type": "org.apache.kafka.connect.transforms.TimestampConverter$Value",
"transforms.TimestampConverter.format": "yyyy-MM-dd HH:mm:ss",
"topics.regex": "postgre_source.public.(.*)",
"value.converter.schema.registry.url": "http://schema-registry:8081",
"key.converter.schemas.enable": "false",
"delete.enabled": "true",
"connection.user": "system",
"value.converter.schemas.enable": "true",
"name": "Oracle Sink Connector",
"auto.create": "true",
"connection.url": "jdbc:oracle:thin:@172.18.0.8:1521:xe",
"key.converter.schema.registry.url": "http://schema-registry:8081",
"pk.mode": "record_key"
}