Aiven JDBC Sink Connector
Kafka Connectors have been deprecated and will be removed on October, 1st 2024. Please refer to the deprecation notice for more information.
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:
| Database | JDBC Driver |
|---|---|
| PostgreSQL | postgresql-42.3.3 |
| MySQL | mysql-connector-java-8.0.28 |
| MS SQL Server | mssql-jdbc-10.2.0 |
| Snowflake | snowflake-jdbc-3.13.16 |
| ClickHouse | clickhouse-jdbc-0.3.2-patch11 |
| SQLite | sqlite-jdbc-3.36.0.3 |
Was this page helpful?