Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-7753

Introduce `RawToString` transform for converting GUIDs stored in Oracle `RAW(16)` columns to Guid string

XMLWordPrintable

      Problem:

      From within Oracle it is common to store GUIDs in a `RAW(16)`. When Debezium streams CDC events to Kafka it streams a Base64 encoding of the byte[]. This means all consumers need to have logic that decodes from Base64, then convert the `byte[]` into a GUID.

      Suggestion:

      There should be a `Raw16GuidToString` transform package into Debezium that converts the Base64 encoded value into a GUID string all programming languages understand natively. For example: Within the Source connector`KwnMrgaqRaqi8d0OTARySQ==` is transformed to `2b09ccae-06aa-45aa-a2f1-dd0e4c047249` before it is written to the Kafka topic.

      Justification:

      This would cut down on the need for each consumer needing to have the Base64 > byte[] > GUID logic. Instead, the transformation would happen once (within the Source Connector) and downstream, consumers would receive the GUID string.

              ccranfor@redhat.com Chris Cranford
              bmt-cayman Timothy Dilbert (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: