topic User defined data message format in Qlik Replicate

User defined data message format

ramyakan7 — Mon, 08 Jul 2024 11:10:38 GMT

Hi,

I am extracting CDC data from replicate in Json format and sending it to Kafka. Is it possible to send a message in user defined/Debezium format?

My new JSON format be like:

{
  "before": {
    "id": 111,
    "name": "scooter",
    "description": "Big 2-wheel scooter",
    "weight": 5.18
  },
  "after": {
    "id": 111,
    "name": "scooter",
    "description": "Big 2-wheel scooter",
    "weight": 5.15
  },
  "source": {...},
  "op": "u",
  "ts_ms": 1589362330904,
  "transaction": null
}

can we achieve this is Replicate?

Thanks,

Ramya

Re: User defined data message format

john_wang — Tue, 09 Jul 2024 14:20:13 GMT

Hello @ramyakan7 ,

Welcome to Qlik Community forum and thanks for reaching out here!

Looks to me it should be fine in Qlik Replicate, there are rich header columns can be customized in JSON format messages, for example:

Hope this helps.

John.

Re: User defined data message format

ramyakan7 — Mon, 15 Jul 2024 11:18:58 GMT

Hello @john_wang

Thanks for your reply. I understood we can choose the header columns from the various options.

By any chance, can we rename it?

For ex: 'operation' to 'op'

Many thanks,

Ramya

Re: User defined data message format

john_wang — Tue, 16 Jul 2024 02:36:22 GMT

Hello Ramya, @ramyakan7

No, there is no option to change the predefined header columns name.

Regards,

John.

Re: User defined data message format

Dana_Baldwin — Tue, 16 Jul 2024 17:52:22 GMT

Hi @ramyakan7

If renaming the header column is a feature you would like to see, we encourage you to post this feature request directly to our Product Management team here: https://community.qlik.com/t5/Ideas/idb-p/qlik-ideas

Thanks,

Dana