5

I wanna use Oracle GoldenGate (it's orcale cdc tool) to integrate oracle with Kafka. i have find a two Handler:

  1. http://docs.oracle.com/goldengate/bd123110/gg-bd/GADBD/using-kafka-connect-handler.htm#GADBD-GUID-81730248-AC12-438E-AF82-48C7002178EC with avro formatter
  2. http://docs.oracle.com/goldengate/bd123110/gg-bd/GADBD/using-kafka-handler.htm#GADBD449

Both this handler do not support decimal type(i mean they do not treat decimal in avro as logical type, or else how), this tools just convert decimal to double type. And in this case, we loose precision.

Does any one know a good way to treat decimals, except write own handler?

OneCricketeer
  • 179,855
  • 19
  • 132
  • 245
Grigoriev Nick
  • 1,099
  • 8
  • 24

1 Answers1

1

You need 12.3.1.1.4 and the following:

gg.handler.<name>.format.mapLargeNumbersAsStrings=false
gg.handler.<name>.format.enableDecimalLogicalType=true
gg.handler.<name>.format.enableTimestampLogicalType=true
pheeleeppoo
  • 1,491
  • 6
  • 25
  • 29
Rudi Cuvelier
  • 26
  • 1
  • yes i see that new release has this feature. But our company use 11.X oracle. And will not migrate to new one in neares two year. So i just migrate CDC to XStream API. Also i check Debezium, but it was in Alpha when i try. – Grigoriev Nick Oct 19 '18 at 13:06