topic Re: Customize schema name before publishing to schema registry in Qlik Replicate

Customize schema name before publishing to schema registry

gd_accent — Fri, 02 Oct 2020 09:40:15 GMT

Hello,

Is it possible to rename value/key schemas before publishing to schema registry (Confluent Schema Registry) ?

When replicating database tables (oracle) to kafka topics and activating metadata message publication to Confluent Schema Registry, it seems not possible to set custom schemas name.

All schema are published like this : source_db_schema.source_db_table-value and source_db_schema.source_db_table-key.

Expl : APP_DBA.TABLE1-value

Is there any internal parameters or transformation to change this behaviour ?

Thank you.

Re: Customize schema name before publishing to schema registry

EyalSilner — Mon, 05 Oct 2020 10:55:36 GMT

Hi,

You can simply go to Task Settings >> Target Metadata tab and set a new (global) schema name to the Target table schema field.

BTW, you cannot suppress the dot between the schema and the table name (so it is better to avoid including a dot in the new schema name).

Hope it helps 🙂

Re: Customize schema name before publishing to schema registry

gd_accent — Wed, 07 Oct 2020 07:09:39 GMT

Hello,

Perfect just tested this and it works fine thank you.

As you said, we can just customize before the dot but in case of kafka endpoint, both topics and avro schemas are properly renamed.