Is there a possibility of automatic dead letter topic creation on producing message to a topic? Or DLQs only associated with consumers and not producers


I am new to Confluent cloud. I have a scenario where we send huge load of messages from Boomi platform to Kafka using Boomi’s Kafka connector. I want to know if dead letter queues can be automatically created in case of failure during message transaction from Boomi to Kafka.

I see using HTTP sink connector, I could achieve automatic DLT creation on failure. But topic accepts all error and success message. So dead letter mechanism is only applicable to consumers and not producers?.

Thanks in advance.