As part of a project in my company, I’d like to introduce Kafka with Debezium for doing CDC replication from MongoDB to PostgreSQL. We have a system in place already, but it’s having scalability issues.
After doing a proof of concept, we got an error when trying to write to a Postgres array type (int, text, etc) via the JDBC connector. Looking for a solution, I found this PR: https://github.com/confluentinc/kafka-connect-jdbc/pull/805
My question is, is there any way to write a Postgres array from Kafka at the moment? Or how could we help accelerate the merge of this feature?
We had a similar issue for writing a Struct into JSON/JSONB, but it could be fixed by keeping the data as a String instead of a Struct.