Aiven JDBC Sink Connector allows you to continuously store the data from your Kafka Topics in any sql dialect relational database like Mysql,PostgreSql etc. In this guide, we will walk you through creating an Aiven JDBC Sink 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 Sink

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 Sink Connector.

As you put data into your selected topics, the data will be written into your relational database.

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