Generate new Schema Registry schema version after DDL change - Connect_CDC - aws_mainframe_modernization_service - connect_cdc_mimix_share - Latest

Connect CDC Getting Started Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
Latest
Language
English
Product name
Connect CDC
Title
Connect CDC Getting Started Guide
Copyright
2024
First publish date
2003
Last edition
2024-09-11
Last publish date
2024-09-11T13:50:21.429182

When user defined as mapping from any DBMS to Kafka target using Schema Registry/Avro, a topic is created in Kafka and a subject with a initial version of schema is created in Schema Registry.

The Avro definition will contain a JSON like string that reflects the fields definitions of mapped source fields.

To trigger a refresh and generate a source table DDL change
  1. Refresh source table in Director's catalog to retrieve the definition after DDL change.
  2. Generate a new schema version for the subject in Schema Registry based on the new source table fields definition.
  3. Refresh target topic definition in Director to reflect the new schema version.
  4. Refresh the fields mapping in Director to:
    • Remove suppressed fields
    • Add new fields added and default map them with "Copy method"

This feature can be access from the GUI menu by right-clicking a mapping.