Qlik Replicate: Create Unique ID Column Header for Kafka Target

[Dana_Baldwin]

Scenario: A task with Sybase ASE as the Source and Confluent Kafka as the Destination.

Requirement: Create a new column with a unique identifier "UUID" to identify the message in Confluent Kafka.

Is there any customization in Qlik Replicate that allows the creation of a unique sequencer for each replicated record per table?

Resolution

The following transformation is provided as is. For more detailed customization assistance, post your requirement in the Qlik Replicate forum, where your knowledgeable Qlik peers and our active Support Agents can help. If you need direct assistance, contact Qlik's Consulting Services.

You can add a new column and hard-code it to a unique (random) value by using the Transform tab in Table Settings.

Example Expression Value: 

substr(lower(hex(randomblob(16))),1,8) || '-' || substr(lower(hex(randomblob(16))),9,4) || '-4' || substr(lower(hex(randomblob(16))),13,3) || '-' || substr('89ab', abs(random()) % 4 + 1, 1) || substr(lower(hex(randomblob(16))),17,3) || '-' || substr(lower(hex(randomblob(16))),21,12)

For more information on transformations, see Defining transformations for a single table/view.

Environment

• Qlik Replicate