Kafka Connect JDBC Connector¶
You can use the JDBC source connector to import data from any relational database with a JDBC driver into Kafka topics. You can use the JDBC sink connector to export data from Kafka topics to any relational database with a JDBC driver. The JDBC connector supports a wide variety of databases without requiring custom code for each one.
Install the JDBC Connector¶
This connector is bundled natively with Confluent Platform. If you have Confluent Platform installed and running, there are no additional steps required to install.
If you do not have Confluent Platform installed and running, you can install the connector using the Confluent Hub client (recommended) or manually download the ZIP file.
If you are running a multi-node Connect cluster, the JDBC connector and JDBC driver JARs must be installed on every Connect worker in the cluster.
Install Connector Using Confluent Hub¶
- Confluent Hub Client must be installed. This is installed by default with Confluent Platform commercial features.
Navigate to your Confluent Platform installation directory and run this command to install the latest (
latest) connector version.
The connector must be installed on every machine where Connect will be run.
confluent-hub install confluentinc/kafka-connect-jdbc:latest
You can install a specific version by replacing
latest with a version number. For example:
confluent-hub install confluentinc/kafka-connect-jdbc:5.1.0