{
"name": "OracleCDC_Confluent_Cloud",
"config":{
"connector.class": "io.confluent.connect.oracle.cdc.OracleCdcSourceConnector",
"name": "OracleCDC_Confluent_Cloud",
"tasks.max":3,
"oracle.server": "<database-url>",
"oracle.sid":"<SID of the CDB>",
"oracle.pdb.name":"<name of the PDB where tables reside. If you don't have PDB, remove this config property>",
"oracle.username": "<username e.g. C##MYUSER>",
"oracle.password": "<password>",
"start.from":"snapshot",
"redo.log.topic.name": "oracle-redo-log-topic",
"redo.log.consumer.bootstrap.servers":"<your-bootstrap-server e.g. xyz.us-central1.gcp.confluent.cloud:9092>",
"redo.log.consumer.sasl.jaas.config":"org.apache.kafka.common.security.plain.PlainLoginModule required username=\"<kafka-api-key>\" password=\"<kafka-api-secret>\";",
"redo.log.consumer.security.protocol":"SASL_SSL",
"redo.log.consumer.sasl.mechanism":"PLAIN",
"table.inclusion.regex":"<regex-expression e.g. ORCL[.]ADMIN[.]MARIPOSA.*>",
"_table.topic.name.template_":"Using template vars to set change event topic for each table",
"table.topic.name.template": "${databaseName}.${schemaName}.${tableName}",
"connection.pool.max.size": 20,
"confluent.topic.replication.factor":3,
"topic.creation.groups":"redo",
"topic.creation.redo.include":"oracle-redo-log-topic",
"topic.creation.redo.replication.factor":3,
"topic.creation.redo.partitions":1,
"topic.creation.redo.cleanup.policy":"delete",
"topic.creation.redo.retention.ms":1209600000,
"topic.creation.default.replication.factor":3,
"topic.creation.default.partitions":5,
"topic.creation.default.cleanup.policy":"compact",
"confluent.topic.bootstrap.servers":"<your-bootstrap-server e.g. xyz.us-central1.gcp.confluent.cloud:9092>",
"confluent.topic.sasl.jaas.config":"org.apache.kafka.common.security.plain.PlainLoginModule required username=\"<kafka-api-key>\" password=\"<kafka-api-secret>\";",
"confluent.topic.security.protocol":"SASL_SSL",
"confluent.topic.sasl.mechanism":"PLAIN",
"value.converter":"io.confluent.connect.avro.AvroConverter",
"value.converter.basic.auth.credentials.source":"USER_INFO",
"value.converter.schema.registry.basic.auth.user.info":"<schema-registry-api-key>:<schema-registry-api-secret>",
"value.converter.schema.registry.url":"<your-schema-registry-url e.g https://xyz.us-east-2.aws.confluent.cloud>"
}
}