# Oracle CDC source connector

**URL:** <https://forum.confluent.io/t/oracle-cdc-source-connector/2555>\
**Category:** Kafka Connect\
**Created:** [23 August 2021 12:38 UTC](https://forum.confluent.io/t/oracle-cdc-source-connector/2555 "2021-08-23T12:38:59Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![shubhamshirur](https://avatars.discourse-cdn.com/v4/letter/s/4bbf92/32.png) [@shubhamshirur](https://forum.confluent.io/u/shubhamshirur)\
**Post date:** [23 August 2021 12:38 UTC](https://forum.confluent.io/t/oracle-cdc-source-connector/2555/1 "2021-08-23T12:38:59Z")

</div>

Hi,

I am using [Oracle CDC Source Connector | Confluent Hub](https://www.confluent.io/hub/confluentinc/kafka-connect-oracle-cdc). I don’t want to take all the columns for tables. I went through the documentation but I could find inclusion and exclusion property which helps to filter table. Can this connector filter columns also? Where I can find the configuration for the same?

Thank you.

---

<div class="post-metadata">

**Author:** ![nbuesing](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/nbuesing/32/1433_2.png) [@nbuesing](https://forum.confluent.io/u/nbuesing)\
**Post date:** [1 September 2021 12:23 UTC](https://forum.confluent.io/t/oracle-cdc-source-connector/2555/2 "2021-09-01T12:23:10Z")

</div>

Look at the ReplaceField Single Message Transform (SMT); there is an field exclusion list.

Also if you are on 2.6+ you can leverage predicates to allow for different replace filter rules based on a matching predicate ([[KAFKA-9673] Conditionally apply SMTs - ASF JIRA](https://issues.apache.org/jira/browse/KAFKA-9673)).

---

<div class="post-metadata">

**Author:** ![rmoff](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/rmoff/32/3_2.png) [@rmoff](https://forum.confluent.io/u/rmoff)\
**Post date:** [1 September 2021 13:59 UTC](https://forum.confluent.io/t/oracle-cdc-source-connector/2555/3 "2021-09-01T13:59:42Z")

</div>

> [@nbuesing](#):
>
> Look at the ReplaceField Single Message Transform (SMT)

Here’s a nice video and article I did about it 🙂

> **[🎄 Twelve Days of SMT 🎄 - Day 10: ReplaceField](https://rmoff.net/2020/12/21/twelve-days-of-smt-day-10-replacefield/)**

---

<div class="post-metadata">

**Author:** ![shubhamshirur](https://avatars.discourse-cdn.com/v4/letter/s/4bbf92/32.png) [@shubhamshirur](https://forum.confluent.io/u/shubhamshirur)\
**Post date:** [1 September 2021 14:11 UTC](https://forum.confluent.io/t/oracle-cdc-source-connector/2555/4 "2021-09-01T14:11:29Z")

</div>

Hey, thank you so much. Let me try it out.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex019/uploads/confluentcommunity/original/1X/c49438c90c9df282e9996fdf6971be890c71b65a.svg) [@system](https://forum.confluent.io/u/system)\
**Post date:** [1 October 2021 14:11 UTC](https://forum.confluent.io/t/oracle-cdc-source-connector/2555/5 "2021-10-01T14:11:34Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.