Définir l'alias-AP

Nom de classe

Indiquez un nom de classe, com.datamirror.ts.target.publication.userexit.sample.kafka.KcopSingleRowAvroAuditIntegrated.

Ajouter la commande au fichier de propriétés

Votre fichier de propriétés se trouve dans CDC_kafka_installation_directory/conf/filename.properties.

Contenu du fichier de propriétés

[cdc@beauty1 conf]$ cat kcops_prop.properties
schema.registry.url=http://localhost:8081
audit.jcfs=ENTTYP,CCID,TIMSTAMP
MODIFY_FIELD_value.SOURCEDB.ORACLE.TAB3$PCKOL_ALIASAP=ibmers.blues

curl Commande

Pour vérifier les zones de schéma, utilisez la commande curl suivante:

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

Sortie :

{"type":"record","name":"AuditRecord","fields":[{"name":"beforeImage","type":["null",{"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","aliases":["ibmers","blues"]},{"name":"PCKOLDATA","type":[{"type":"string","logicalType": "VARCHAR","dbColumnName":"PCKOLDATA","length":255},"null"],"doc":"","default":""}]}]},{"name":"afterImage","type":["null","value.SOURCEDB.ORACLE.TAB3"]},{"name":"A_ENTTYP","type":["null","string"]},{"name":"A_CCID","type":["null","string"]},{"name":"A_TIMSTAMP","type":["null","string"]}]}