JDBC connector
A JDBC connector is a Kafka Connect connector that transfers records between Kafka and databases through the Java Database Connectivity interface.
Kafka Streams in Action, Second Edition
A JDBC connector is a Kafka Connect connector that reads from or writes to databases through the Java Database Connectivity interface.
- How it is used
- Connects database tables to Kafka topics through a JDBC source connector and configurable change detection.
- How deep it goes
- Explains connection, timestamp polling, topic naming, converters, and REST configuration, but stops short of sink-specific operation.
- Examples
- Uses a PostgreSQL table, timestamp column, Docker initialization, REST configuration, JSON conversion, and a topic prefix.
- What you can do after
- Operate/configure a JDBC source connector that imports changed database rows into Kafka topics.
Read how Kafka Streams in Action, Second Edition explains JDBC connector →
Apache Kafka in Action
A JDBC sink connector is a Kafka Connect connector that writes records from Kafka to a relational database through JDBC.
- How it is used
- Moves Kafka records into relational databases through JDBC, with connection and write-retry controls.
- How deep it goes
- Explains connector-level retries, backoff, dead-letter handling, and transformations without detailing database schema mapping.
- Examples
- Uses database maintenance, temporary network outages, locked entries, and table-filtered integrations as operational examples.
- What you can do after
- Operate/configure it by setting database connection attempts, backoff intervals, write retries, and dead-letter handling.
Related concepts
- JDBCuses · JDBC is the standard Java API for connecting applications to relational databases, executing SQL statements, and processing results.
- databaseuses · A database is an organized collection of persistent data managed by software for storage, retrieval, querying, and modification.
- source connectorkind of · A source connector is a Kafka Connect connector that reads data from an external source system and publishes records to Kafka.
- JDBC source pluginincludes · A JDBC source connector is a Kafka Connect connector that reads records from relational databases through JDBC and publishes them to Kafka.
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.