# From multiple tables to single topic - JDBC source connector

**URL:** <https://forum.confluent.io/t/from-multiple-tables-to-single-topic-jdbc-source-connector/3055>\
**Category:** Kafka Connect\
**Created:** [11 October 2021 15:57 UTC](https://forum.confluent.io/t/from-multiple-tables-to-single-topic-jdbc-source-connector/3055 "2021-10-11T15:57:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![satyauec](https://avatars.discourse-cdn.com/v4/letter/s/c2a13f/32.png) [@satyauec](https://forum.confluent.io/u/satyauec)\
**Post date:** [11 October 2021 15:57 UTC](https://forum.confluent.io/t/from-multiple-tables-to-single-topic-jdbc-source-connector/3055/1 "2021-10-11T15:57:12Z")

</div>

For a source connector on the oracle database. I want to push data in increment mode from multiple tables into a single topic. But it seems table.whitelist and topic.prefix are tightly coupled. Connector would look for as many topics as many table.whitelist. Is there a way to achieve this?

---

<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:** [12 October 2021 08:40 UTC](https://forum.confluent.io/t/from-multiple-tables-to-single-topic-jdbc-source-connector/3055/2 "2021-10-12T08:40:53Z")

</div>

`topic.prefix` will be applied to the name of each table that the connector fetches. The tables that the connector fetches is defined by the whitelist.

I’m not clear on what the tight coupling or limitation here is that you’re encountering - can you elaborate, perhaps with an example please?

---

<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:** [11 November 2021 08:41 UTC](https://forum.confluent.io/t/from-multiple-tables-to-single-topic-jdbc-source-connector/3055/3 "2021-11-11T08:41:49Z")

</div>

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