Aiven JDBC Source Connector allows you to capture any changes in your SQL dialect relational databases and store them as messages on your Kafka topics. In this guide, we will walk you through creating the Aiven JDBC Source Connector.

Get Started

Create a Kafka Cluster

If you do not have a Kafka cluster and/or topic already, follow these steps to create one.

Create the Connector

Go to the Connectors tab, and create your first connector by clicking the New Connector button.

Choose your connector as Aiven JDBC Connector Source

Enter the required properties.

The advanced screen is for any other configuration that the selected connector supports. At the top of this screen, you can find a link to related documentation. We can proceed with what we have and click the Connect button directly.

Congratulations! You have created an Aiven JDBC Source Connector. As you put data into your relational database, your topics will be created and populated with new data.

You can go to the Messages section to see latest events as they are coming from Kafka.

Supported Databases

These are the currently supported databases and JDBC drivers:

DatabaseJDBC Driver
PostgreSQLpostgresql-42.3.3
MySQLmysql-connector-java-8.0.28
MS SQL Servermssql-jdbc-10.2.0
Snowflakesnowflake-jdbc-3.13.16
ClickHouseclickhouse-jdbc-0.3.2-patch11
SQLitesqlite-jdbc-3.36.0.3