Kafka Connect JDBC

By Confluent, Inc.

confluentinc/kafka-connect-jdbc:5.2.1
149786 %
Version

5.2.1

Fonctionnalités

  • Transformation de message unique
  • Intégration de Control Center
  • API Kafka Connect
Télécharger le Connecteur

Mots-clés

Kafka Connect JDBC

Confluent, Inc.

confluentinc/kafka-connect-jdbc:5.2.1
149786 %

The JDBC source and sink connectors allow you to exchange data between relational databases and Kafka.

The JDBC source connector allows you to import data from any relational database with a JDBC driver into Kafka topics. By using JDBC, this connector can support a wide variety of databases without requiring custom code for each one.

Data is loaded by periodically executing a SQL query and creating an output record for each row in the result set.

By default, all tables in a database are copied, each to its own output topic. The database is monitored for new or deleted tables and adapts automatically. When copying data from a table, the connector can load only new or modified rows by specifying which columns should be used to detect new or modified data.

The JDBC sink connector allows you to export data from Kafka topics to any relational database with a JDBC driver. By using JDBC, this connector can support a wide variety of databases without requiring a dedicated connector for each one. The connector polls data from Kafka to write to the database based on the topics subscription. It is possible to achieve idempotent writes with upserts. Auto-creation of tables, and limited auto-evolution is also supported.

Plus......Moins

Install your connector

Use the Confluent Hub client to install this connector with:

confluent-hub install confluentinc/kafka-connect-jdbc:5.2.1

Or download the ZIP file and extract it into one of the directories that is listed on the Connect worker's plugin.path configuration properties. This must be done on each of the installations where Connect will be run. See here for more detailed instructions.

Configure an instance of your connector

Once installed, you can then create a connector configuration file with the connector's settings, and deploy that to a Connect worker. See here for more detailed instructions.

The source code is located in this repository.

For more information, see the documentation.

Confluent supports the JDBC sink and source connectors alongside community members as part of its Confluent Platform offering.
Évaluez ce connecteur

Nous utilisons des cookies afin de comprendre comment vous utilisez notre site et améliorer votre expérience. Cliquez ici pour en apprendre davantage ou pour modifier vos paramètres de cookies. En poursuivant la navigation, vous consentez à ce que nous utilisions des cookies.