Hi @Haitam Dadsi,
That something you could easily achieve using Apache NiFi. You could have a simple workflow looking like: GenerateTableFetch -> ExecuteSQL -> PublishKafkaRecord
You will find plenty of examples for such processors.
Hope this helps.
@Pierre Villard in fact what im trying to do is , i want to get data from mssql server database in real time , to get them into streaming (machine learning or whatever) then do a reporting dashboard , and i want it all in real time