REPLICATE - CDC TO KAFKA USING JSON FORMAT - NUMERIC SHOWS AS STRING WITH DOUBLE QUOTE - ADD LOGICAL OPTION AS YOU DO HAVE USING AVRO FORMAT
means that messages using NUMERIC fields will go with AVRO LOGICAL FORMAT and only as the PRIMITVE FORMAT where NUMERIC goes with : "5" so it will go as : 5.
our use case :
in critical bussiness cases where we want to acheive up-to-date data in near real time any conversion that need to be done is time consuming and critical chaning thousnds of rows replicated from "5" to 5 with parsing in the developer program is adding up to a long time waste.
Thanks
please refer to
case # 02043166