KsqlDB + Kafka Connect: Move data IN/OUT of Kafka with just SQL! Tutorial with MySQL and REDIS

In this new episode we will do an overview of Kafka Connect and then see how we can use it in combination with KsqlDB.
We will move data from MySQL to Redis!
Github repository: github.com/Pro...

[@thaddeuscleo5920]

Hei Mati, First of all, I want to say thank you because I have been trying to find this solution for a while. It can be solved using KSqlDB, which is amazing. Great video! However, I am really curious about the Redis side. When an event is created on the MySQL side, will it be able to replicate in json format so that the value stored on Redis is in JSON? I'm really looking forward to your answer.

[@monu3252]

Hi Mati, I am trying to use this tutorial and get data from Oracle DB on OCI to Kafka, but when I try to start run.sh it fails with error
INFO ksqlDB shutdown called (io.confluent.ksql.rest.server.KsqlRestApplication:484)
ERROR Failed to start KSQL (io.confluent.ksql.rest.server.KsqlServerMain:96)
java.lang.IllegalStateException: Not started
at io.confluent.ksql.api.server.Server.stop(Server.java:178)
at io.confluent.ksql.rest.server.KsqlRestApplication.shutdown(KsqlRestApplication.java:531)
at io.confluent.ksql.rest.server.MultiExecutable.doAction(MultiExecutable.java:68)
at io.confluent.ksql.rest.server.MultiExecutable.shutdown(MultiExecutable.java:47)
at io.confluent.ksql.rest.server.KsqlServerMain.runExecutable(KsqlServerMain.java:160)
at io.confluent.ksql.rest.server.KsqlServerMain.tryStartApp(KsqlServerMain.java:115)
at io.confluent.ksql.rest.server.KsqlServerMain.main(KsqlServerMain.java:94)

[@ankitaghadge.1337]

I have created Employee project in React js and .net. now my task is to send data to Kafka Queue once user edit and save the employee data. I have used the Microsoft SQL. Will you plz plz help me. how i can do that?

[@programmingwithmati]

If you follow the steps in this tutorial, you are almost set… you only need to download the MS SQL Server jdbc driver.

[@quangphongtran3558]

cool