JDBC source connector
A JDBC source connector is a Kafka Connect connector that reads data from a relational database using JDBC and publishes it to Kafka.
Apache Kafka in Action
A JDBC source connector is a Kafka Connect connector that reads records from relational databases through JDBC and publishes them to Kafka.
- How it is used
- Moves relational table data into Kafka topics through Kafka Connect.
- How deep it goes
- Configures database access, table selection, topic naming, and JSON output, then notes change-capture limits and defers to CDC.
- Examples
- Demonstrates a SQLite customers table, JSON records, connector registration, and consumption from sqlite_customers.
- What you can do after
- Configure a Kafka Connect JDBC source to read selected database tables and publish records to named Kafka topics.
Read how Apache Kafka in Action explains JDBC source connector →
Kafka for Architects
JDBC Source Connector is a Kafka Connect connector implementation that reads records from relational databases through JDBC and publishes them to Kafka.
- How it is used
- Loads relational-table data into Kafka topics through Kafka Connect as a configuration-driven alternative to custom transfer code.
- How deep it goes
- Explains polling modes, table-to-topic mapping, query extraction, and data constraints without detailing connector internals.
- Examples
- Uses immutable transactions loaded with ID-based incrementing and shows a PostgreSQL and Avro configuration.
- What you can do after
- Configure and deploy a connector through Kafka Connect’s REST API to load immutable rows using an incrementing column.
Read how Kafka for Architects explains JDBC source connector →
Also covered in
What to know first
- topicA topic is a named channel or stream that organizes messages or records for publication and retrieval by interested consumers.
Related concepts
- topicproduces · A topic is a named channel or stream that organizes messages or records for publication and retrieval by interested consumers.
- Debeziumcontrasts with · Debezium is an open-source distributed change data capture platform that captures database changes and streams them to downstream consumers.
- JDBCuses · JDBC (Java Database Connectivity) is the standard Java API for connecting to databases, executing SQL statements, and processing results.
- Kafka Connectused by · Kafka Connect is a framework for reliably transferring data between Apache Kafka and external systems through configurable source and sink connectors.
Questions about JDBC source connector
What is JDBC source connector?
A JDBC source connector is a Kafka Connect connector that reads data from a relational database using JDBC and publishes it to Kafka.
Which Manning books explain JDBC source connector?
Apache Kafka in Action and Kafka for Architects.
What should I know before learning JDBC source connector?
Manning books that teach JDBC source connector usually introduce topic first.
What is the difference between JDBC source connector and Debezium?
A JDBC source connector is a Kafka Connect connector that reads data from a relational database using JDBC and publishes it to Kafka. Debezium is an open-source distributed change data capture platform that captures database changes and streams them to downstream consumers.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.

