I am a new to Kafka.
I have a requirement in which I want to consume a text message from a single partition Kafka topic.

I have a large sql queries with multiple joins, where clauses, string concatenations ans distinct selections used for data replication from Firebird to Postgres once a day. Tables became larger also they are required to be replicated immediately after data change. Is it possible to process such queries using Apache Kafka? Is there any other tools used to solve this task? Up to 10 tables can be involved in one query. Is there any examples for such data processing?

heartbeat interval ms