Stack it.

https://www.cloudera.com/solutions/gallery/striim-real-time-data-streaming-from-oracle-to-kafka.html

https://community.hortonworks.com/questions/12787/how-to-integrate-kafka-to-pull-data-from-rdbms.html

https://www.google.com/search?rlz=1C1CHBF_enUS723US723&ei=OEf1W9OMJuq_jwT56IDQBw&q=sql+server+change+data+capture+to+kafka&oq=sql+server+change+data+capturing+to+k&gs_l=psy-ab.3.0.0i22i30.4682.20638..22504…12.0..2.675.6585.9j30j0j2j1j2……0….1..gws-wiz…….0j0i71j35i39j0i67j0i131j0i20i263j0i10j0i13j33i160j0i22i10i30.F-L0WNFjk4c

https://www.google.com/search?source=hp&ei=Ykj1W7i5JtCyzwKoyInoBA&q=striim+vs+kafka&oq=striim+vs+ka&gs_l=psy-ab.1.0.0j0i22i30.154.6522..9598…3.0..0.83.1273.18……0….1..gws-wiz…..6..35i39j0i131i67j0i67j0i131j0i10j0i20i263.F_FUujjf9Ck

Kafka Connect CDC Microsoft SQL