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!