liveBook · Manning

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.

How 2 Manning books explain it

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

Related concepts

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.