How to ingest Kafka topics messages to any rdbms system using nifi

[#1]

Hi team,

I have a Kafka topics having messages in XML format. I am trying to ingest these messages to MySQL system using NiFi. Could you please help me which NiFi processors I should use for ingestions.

Thanks in advance,

Wasim

[#2]

@Wasim Akram

Consumer Kafka -> TransformXML(xml to json) -> PutDatabaseRecord

[#3]

@Wasim Akram Could you please take a moment and accept my answer if it was helpful for you.

[#4]

Thanks @hmatta.