Using Kafka Connect’s JDBC Sink to Write IoT sensor data to GridDB

In this tutorial we will explain how to write data from the Casas Dataset using Kafka to GridDB using a Kafka Connect JDBC Sink.

Get Started With GridDB and JDBC

Talk about new JDBC support, how to configure it, sample, etc.

Install and Start Kafka

Get Kafka running via docker, confluent platform, or use vanilla apache scripts.

Setup JDBC Sink

Setup one of the JDBC connectors for kafka.

Ingest Data

Feed the CSV data into a Kafka consumer.

View Data

Use sqlworkbench/j to view incoming data.

Watch out for our upcoming tutorials on using GridDB’s JDBC support to perform advanced analysis and visualization of the Casas dataset!

If you have any questions about the blog, please create a Stack Overflow post here https://stackoverflow.com/questions/ask?tags=griddb .
Make sure that you use the “griddb” tag so our engineers can quickly reply to your questions.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.