We are trying to use JDBC source connector with nested JSON structures (to read SQL Server CDC data using Kafka Connect).
But as per the examples we came across & tried, found that the JDBC connector supports flat Json structure only.
We thus tried creating nested Json in DB and pulled the same through the connector. But JDBC connector treats this as “string”, which then doesn’t allow Json schema versioning.
Can anyone help me with how to use the JDBC source connector with nested JSON structures?
Thanks in advance,