I am trying to write data from a topic (json data) into a MySql Database. I believe I want a JDBC Sink Connector.
How do I configure the connector to map the json data in the topic to how to insert data into the database.
The only documentation I can find is this.
"The sink connector requires knowledge of schemas, so you should use a suitable converter e.g. the Avro converter that comes with Schema Registry, or the JSON converter with schemas enabled. Kafka record keys if present can be primitive types or a Connect struct, and the record value must be a Connect struct. Fields being selected from Connect structs must be of primitive types. If the data in the topic is not of a compatible format, implementing a custom Converter may be necessary."
But how do you configure? Any examples?