python - Load data from kafka to mssql

Question

There is a task to take data from Kafka. I use Python for this. To write data to txt, I did it like this. I'm not sure if it's true, but at least they appeared. Is it possible to write data directly to the mssql database?

 from kafka import KafkaConsumer

    consumer = KafkaConsumer('test' , bootstrap_servers='servers',auto_offset_reset='earliest', enable_auto_commit=True)

    for msg in consumer:
     with open("f:/test.txt", "w") as text_file:
        print(msg, file=text_file)

I connect to mssql via pyodbc. Has anyone done such a task? But I don't understand the syntax of how to insert data ..

question from:https://stackoverflow.com/questions/65939672/load-data-from-kafka-to-mssql

Answer 1

Waitting for answers