Hi Team,
We are using CDC oracle connector to get events from Oracle DB tables.
Requirement : For ex if we have to include all tables that start with PFL_ and exclude only one table with name PFL_BANK_DATA. I tried adding exclusion regex but it’s not getting excluded, am getting events for that also. Please help or let know if am doing wrongly.
Below is the config i use:
{
“name”: “NEXTGENUSERCDCConnector_292”,
“config”:{
“connector.class”: “io.confluent.connect.oracle.cdc.OracleCdcSourceConnector”,
“name”: “NEXTGENUSERCDCConnector_292”,
“tasks.max”:1,
“key.converter”: “io.confluent.connect.avro.AvroConverter”,
“key.converter.schema.registry.url”: “http:/localhost:8081”,
“value.converter”: “io.confluent.connect.avro.AvroConverter”,
“value.converter.schema.registry.url”: “http:/localhost:8081”,
“confluent.topic.bootstrap.servers”:“localhost:9092”,
“oracle.server”: “ECH-10-170-129-203.xxxx.int”,
“oracle.port”: 1527,
“oracle.sid”:“dctf1s”,
“oracle.username”: “NEXTGENUSER”,
“oracle.password”: “boss”,
“start.from”:“snapshot”,
“redo.log.topic.name”: “redo-topic20”,
“table.inclusion.regex”:“dctf1s[.]NEXTGENUSER.”,
“table.exclusion.regex”:“dctf1s[.]NEXTGENUSER.”,
“table.topic.name.template”: “”,
“connection.pool.max.size”: 20,
“confluent.topic.replication.factor”:1,
“topic.creation.groups”: “redo”,
“topic.creation.redo.include”: “redo-log-topic”,
“topic.creation.redo.replication.factor”: 1,
“topic.creation.redo.partitions”: 1,
“topic.creation.redo.cleanup.policy”: “insert”,
“topic.creation.redo.retention.ms”: 120960,
“topic.creation.default.replication.factor”: 1,
“topic.creation.default.partitions”: 1,
“topic.creation.default.cleanup.policy”: “insert”
}
}