topic Re: Qlik Replicate task converting the datetime datatype to long in Qlik Replicate

Qlik Replicate task converting the datetime datatype to long

Rak — Wed, 23 Feb 2022 17:37:16 GMT

Trying to replicate the data from sql server to kafka (avro format) and noticed that datetime is converted to long.

On the target end point (Kafka), I did select "Use logical data types for specific data types" under Avro Format settings in Message Properties.

Can you let me know how to preserve the source data types while writing to kafka target?

shashi_holla — Wed, 23 Feb 2022 19:18:42 GMT

Hi,

Here is user guide which shows Data type conversion to Avro Primitive and Logical Data formats:

This should provide more information on internal transformations.

Thank you,

Rak — Wed, 23 Feb 2022 19:22:29 GMT

I see. Datetime from sql server is TIMESTAMP-MICROS Annotates an Avro LONG.

Can I force it to store it as String? How can I achieve this ?

shashi_holla — Wed, 23 Feb 2022 19:31:13 GMT

Yes, Table Settings -> Transform -> Change the data type to STRING from available options.

Just have to validate the DDL in target to check if the data type matches the transformation.

Thank you,