test(source): add kafka-cdc compatibility test (#16360)

test(source): add kafka-cdc compatibility test (#16360) #5478