Set attribute - field

Class Name

Specify a class name that is, com.datamirror.ts.target.publication.userexit.sample.kafka.KcopDefaultBehaviourIntegrated.

Append command to properties file

Your properties file is in CDC_kafka_installation_directory/conf/filename.properties.

Properties file content

schema.registry.url=http://localhost:8081
MODIFY_FIELD_value.SOURCEDB.ORACLE.TAB3$PCKOL_SET_ATTRIBUTE="fheader1":"cool","fheader2":111,"fheader3":true

curl command

To check the schema, use the following curl command:

[root@beauty1 bin]# curl -X GET -i -H "Content-Type: application/vnd.schemaregistry.v1+json"
http://localhost:8081/subjects/cdc_kafka_testing.kdbi.sourcedb.oracle.tab3-value/versions/latest

Output:

{"type":"record","name":"TAB3","namespace":"value.SOURCEDB.ORACLE","fields":[{"name":"PCKOL","type":[{"type":"string","logicalType":"DECIMAL","dbColumnName":"PCKOL","precision":38,"scale":0},"null"],"doc":"","default":"0","fheader1":"cool","fheader2":111,"fheader3":true},{"name":"PCKOLDATA","type":[{"type":"string","logicalType":"VARCHAR","dbColumnName":"PCKOLDATA","length":255},"null"],"doc":"","default":""}]}